Comments by pankajgarg1986

pankajgarg1986 16-Sep-16 7:47am View

Deleted

my code for it

 public bool CheckLeaveStatus(int empid, DateTime date)
    {
        bool temp = false;
        int totalleave = 0;
        string qry = "select joining from profile where profileid=@id";
        MySqlParameter idP = new MySqlParameter("@id", empid);
        DataRow dr = MySqlHelper.ExecuteDataRow(Common.GetConnectionString(), qry, idP);
        if (dr != null)
        {
            DateTime joiningdate = Convert.ToDateTime(dr["joining"]);
            int legaldate = joiningdate.Day;
            if (legaldate <= 15)
            {
                totalleave += 2;
            }
            else
            {
                totalleave += 0;
            }
            //TimeSpan t1 = date - joiningdate;
            int monthspassed = Common.MonthDifference(date, joiningdate);
            if (monthspassed > 3)//then he is allowd to take leave
            {
                int startmonth = joiningdate.Month + 1;
                int endmonth = date.Month;
                int monthdiffernce = endmonth - startmonth;
                if (monthdiffernce > 24)
                {
                    monthdiffernce = 24;
                }
                int leaves = (monthdiffernce) * 2;
                int allowedleaves = leaves + totalleave;
                int availablelaves = allowedleaves - LeaveTaken(empid);
                if (availablelaves > 0)
                {
                    temp = true;
                }
            }
            DateTime previousdate = date.AddYears(-2);
        }
        return temp;
    }
    public void AddLeaves(int empid, DateTime date, string status)
    {
        if (status == "L")
        {
            string qry = "insert into leavestatus(empid,takenon)values(@empid,@takenon)";
            MySqlParameter idP = new MySqlParameter("@empid", empid);
            MySqlParameter takenonP = new MySqlParameter("@takenon", date);
            MySqlParameter[] p = { idP, takenonP };
            MySqlHelper.ExecuteNonQuery(Common.GetConnectionString(), qry, p);
        }
    }

pankajgarg1986 16-Sep-16 5:38am View

i don't have idea pls suggest

pankajgarg1986 16-Sep-16 5:22am View

every month employee can take 2 leaves and in a month if he takes less than 2 leaves suppose 1 then 1 leave is remaining this leave is valid for two years.he can take this leaves + 2 leaves in next months and so on. but these carry forward leaves can't be used after two years passed.

pankajgarg1986 16-Sep-16 4:51am View

how can i calculate two years passed and employee can use not taken leave up to 2 years after that all leaves lapsed not carry forward.

pankajgarg1986 16-Sep-16 2:51am View

i am using sql server with asp .net c#

pankajgarg1986 16-Sep-16 2:12am View

how can i done this if total balance is valid for 2 years after that it can't be added to leave balance

pankajgarg1986 17-Feb-14 6:35am View

It problem only from local host on same machine And its working fine from any host.But giving IP Address not solve my problem from same machine..
Here is My my.conf file pls check and let me know aany chaned any it.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3307
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3307
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
#skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 256M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections = 2000
wait_timeout=10
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 2M
query_cache_size = 1024M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
server-id = 5
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 30
#max_binlog_size = 100M
#binlog_do_db = pos
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
innodb_file_per_table
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=8
innodb_buffer_pool_size=8G
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

pankajgarg1986 17-Feb-14 5:08am View

MySQL server is accessible through Workbench using remote host.But Application can not to it.

pankajgarg1986 12-Sep-13 4:35am View

i am not using Bulkinsert due to address detai in my query.In Address it appears , then problem in insert

pankajgarg1986 4-Sep-13 0:30am View

friends pls help me in this issue,thanks in advance

pankajgarg1986 4-Sep-13 0:11am View

here i am used for loop in it and
error is you have error in sql syntax check the manual that correspondence to your mysql server version to right syntax use near
for (int i = 1; i <= 161953; i++)
{

str.Append("update commonparmarth");
str.Append("set receiptnoid=" + no + "");
str.Append("where accountid=" + Accountid + "and commonparmarthid=" + i + "");
no++;

}
MySqlCommand command = new MySqlCommand(str.ToString(), con, tran);
command.ExecuteNonQuery();

pankajgarg1986 12-Feb-13 23:53pm View

I debug my application no of times.but never find these types of error in debudding.But After installed on windows 7.Its shows this kind of problem

pankajgarg1986 12-Feb-13 23:46pm View

This Apllication is used Mysql as backend.Connected to Windows server 2008 R2.

pankajgarg1986 1-Feb-13 7:11am View

currently i have no code.can you pls suggest me the write code for doing that task

pankajgarg1986 6-Jan-13 23:08pm View

What why this query return Large amount of rows.In databse there are less records something 30 rows.but this query returns 308 rows.Pls find solution.

pankajgarg1986 6-Jan-13 23:03pm View

Thanks Pallavi waikar.Nice reply form you.i really thanksfull to you

pankajgarg1986 6-Jan-13 3:13am View

how to execute multiple select query in easy way

pankajgarg1986 3-Jan-13 23:54pm View

then javascript retrun false.i want p.UpadteIssuePass is not called.

pankajgarg1986 26-Dec-12 6:40am View

This Script is not Working.Pls Help me in finding the solution.

string t = "<script type='text/javascript'>window.open(window.location+'contributionreceipt.aspx?Name=" + ddlaccount.SelectedItem + "&Name1= " + ddlpanno.SelectedItem + "&Name2= " + receiptno + "&Name3= " + date + "&Name4= " + txtname.Text + "&Name5= " + txtfathername.Text + "&Name6= " + txtaddress.Text + "&Name7= " + txtdistt.Text + "&Name8= " + txtstate.Text + "&Name9= " + txtmobileno.Text + "&Name10= " + txtamount.Text + "');</script>";
Response.Write(t);

pankajgarg1986 16-Dec-12 23:20pm View

in debugging its show error in line
CSV += lstNumbers[i].ToString() + ",";

pankajgarg1986 13-Dec-12 0:43am View

this query is also not working
string qry = "select * from parmarth where date >=@start and date <=@end and accountid=@accountid having sum(amount)<=@amount";

pankajgarg1986 12-Dec-12 23:40pm View

In Query .how to write sql query.This Below query gives error.Invalid use of group function
string qry = "select * from Account where date >=@start and date <=@end and accountid=@accountid and sum(amount)=@amount";

pankajgarg1986 1-Dec-12 0:58am View

how to check for system.dbnull in if statement

pankajgarg1986 25-Nov-12 3:06am View

Thanks OriginalGriff ..

pankajgarg1986 25-Nov-12 3:04am View

it is solved and answer is:-
string qry = "select * from " + tableName + "where campaignid='" + campaignid + "'";

pankajgarg1986 22-Nov-12 5:59am View

Parameters type is correct

pankajgarg1986 22-Nov-12 5:56am View

function is not called ..error is not in dt.roes.count.

pankajgarg1986 22-Nov-12 5:55am View

yes i have debug it ..but no solution find

pankajgarg1986 22-Nov-12 5:53am View

DataTable dt = inch.Searchincharge( Convert.ToInt32(ddlcon.SelectedValue), Convert.ToInt32(ddlstate.SelectedValue), Convert.ToInt32(ddldistrict.SelectedValue), Convert.ToInt32(ddlblock.SelectedValue), Convert.ToInt32(ddldesignation.SelectedValue), txtname.Text, txtfathername.Text, Convert.ToInt32(txtinsanno.Text), Convert.ToInt32(txtmobileno.Text) );

pankajgarg1986 22-Nov-12 5:41am View

sir, when call searchincharge() function then show error! input string is not in correct formate

pankajgarg1986 16-Nov-12 6:51am View

how to hide ddl item in code behind..ddl fill form the database

pankajgarg1986 15-Nov-12 23:48pm View

Thanks a lot ..now its is solved

Comments by pankajgarg1986 (Top 32 by date)