public DataTable getAllEmployee()
{
DataTable dtEmp = new DataTable();
try
{
objmysqldb.ConnectToDatabase();
dtEmp = objmysqldb.GetData("select empid,Concat(if(Employee_master.EmpFirstName is null,'',Employee_master.EmpFirstName) , ' ' , if(Employee_master.EmpMiddleName is null,'',Employee_master.EmpMiddleName) , ' ' , if(Employee_master.EmpLastName is null,'',Employee_master.EmpLastName)) AS FullName from employee_master where employee_master.IsDelete=0 and EmpStatusFlag=0 and employee_master.FP_Id>0 order by empid");
if (dtEmp != null && dtEmp.Rows.Count > 0)
{
ddlEmp.DataTextField = "FullName";
ddlEmp.DataValueField = "empid";
ddlEmp.DataSource = dtEmp;
ddlEmp.DataBind();
ddlEmp.Items.Insert(0, new ListItem("Select Employee", "-1"));
}
}
catch (Exception Ex)
{
//Exception exception = varAK0;
Logger.WriteCriticalLog("getEmployee 90: exception:" + Ex.Message + "::::::::" + Ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
return(dtEmp);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
ltrErr.Text = "";
if (!grp_idHidden.Value.ToString().Equals("0") && grp_idHidden.Value != "")
{
update_emp_group();
return;
}
int grpid = 0;
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
int.TryParse(grp_idHidden.Value.ToString(), out grpid);
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
int emp = 0;
int.TryParse(ddlemplist.Items[ddlemplist.SelectedIndex].Value.ToString(), out emp);
int grp = 0;
int.TryParse(ddlgrouplist.Items[ddlgrouplist.SelectedIndex].Value.ToString(), out grp);
DateTime currenttime = Logger.getIndiantimeDT();
DataTable dtdata = objmysqldb.GetData("select * from employee_app_module_rights where module_group_id<>" + grp + " and emp_id=" + emp + "");
DataTable dtdata_emp = objmysqldb.GetData("select * from employee_app_module_rights where module_group_id=" + grp + " and emp_id=" + emp + "");
if (ddlgrouplist.SelectedIndex < 1 || ddlemplist.SelectedIndex < 1)
{
ltrErr.Text = "Please Select All Details.";
}
else
{
string query = "Insert into employee_app_module_rights(module_group_id,emp_id,modify_datetime,DOC,IsDelete,IsUpdate,UserID) values (" + grp + "," + emp + "," + currenttime.Ticks + "," + currenttime.Ticks + ",0,1," + user_id + ")";
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("employeeassigngroup 209 Update error.");
}
else
{
Search();
bindgroup();
bindemployee();
ltrErr.Text = "Group Assign to Employee Successfully";
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("employeeassigngroup 224: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ltrErr.Text = "";
if (e.CommandName == "del")
{
int reporting_manager_id = 0;
int.TryParse(e.CommandArgument.ToString(), out reporting_manager_id);
objmysqldb.ConnectToDatabase();
//pending
DataTable dtemp_data = objmysqldb.GetData("Select emp_id from employee_assign_to_reporting_manager WHERE Reporting_manager_id =" + reporting_manager_id + " and IsDelete=0");
if (dtemp_data != null && dtemp_data.Rows.Count > 0)
{
ltrErr.Text = "Employee Assign to select Reporting Manager so can't delete it";
return;
}
else
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
DateTime currenttime = Logger.getIndiantimeDT();
string query = "Update reporting_manager_master set IsDelete=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where Reporting_manager_id=" + reporting_manager_id + " ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Manage_ReportingManager 258 Update error.");
}
else
{
grd.EditIndex = -1;
Search();
ltrErr.Text = "Reporting Manager Delete Successfully";
}
}
grd.EditIndex = -1;
}
else if (e.CommandName == "Edit")
{
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Manage_ReportingManager 277: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
ltrErr.Text = "";
if (!txtdesignames.Text.ToString().Equals(""))
{
objmysqldb.ConnectToDatabase();
DataTable dtdesigList = objmysqldb.GetData("select designation_id,Designation_Name from designation_master where Designation_Name like '" + txtdesignames.Text.ToString() + "' and IsDelete=0 ;");
if (dtdesigList != null && dtdesigList.Rows.Count > 0)
{
ltrErr.Text = " Designation Is Already Exist.";
return;
}
DateTime currenttime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.AddCommandParameter("designame", txtdesignames.Text.ToString());
string query = "Insert into designation_master (Designation_Name,DOC,UserID,IsDelete,IsUpdate,modify_datetime,IsMasterData) values (?designame," + currenttime.Ticks + "," + user_id + ",0,1," + currenttime.Ticks + ",1) ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("ManageDesignation 111 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
ltrErr.Text = "Designation Save Successfully.";
txtdesignames.Text = "";
}
}
else
{
ltrErr.Text = "Please Enter All Details.";
return;
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("ManageDesignation 128: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
ltrErr.Text = "";
if (!txtschID.Text.ToString().Equals("") && !txtschnames.Text.ToString().Equals(""))
{
objmysqldb.ConnectToDatabase();
DataTable dtschList = objmysqldb.GetData("Select * from school_list WHERE IsDelete=0 and (School_Name like '" + txtschnames.Text.ToString() + "' OR School_Id = " + int.Parse(txtschID.Text.ToString()) + ") ");
if (dtschList != null && dtschList.Rows.Count > 0)
{
ltrErr.Text = " Organization Is Already Exist";
return;
}
DateTime currenttime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.AddCommandParameter("schanme", txtschnames.Text.ToString());
string query = "Insert into school_list (School_Name,School_Id,DOC,UserID,IsDelete,IsUpdate,modify_datetime) values (?schanme," + int.Parse(txtschID.Text.ToString()) + "," + currenttime.Ticks + "," + user_id + ",0,1," + currenttime.Ticks + ") ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Manage_Organization 110 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
ltrErr.Text = "Organization Save Successfully";
txtschID.Text = "";
txtschnames.Text = "";
}
}
else
{
ltrErr.Text = "Please Enter All Details.";
return;
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Manage_Organization 130: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
ltrErr.Text = "";
if (!txtcategorynames.Text.ToString().Equals(""))
{
objmysqldb.ConnectToDatabase();
DataTable dtcategory = objmysqldb.GetData("Select * from category_master WHERE (category_name like '" + txtcategorynames.Text.ToString() + "') and IsDelete=0 ");
if (dtcategory != null && dtcategory.Rows.Count > 0)
{
ltrErr.Text = " Category Is Already Exist";
return;
}
DateTime currenttime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.AddCommandParameter("categoryname", txtcategorynames.Text.ToString());
string query = "Insert into category_master (category_name,UserID,modify_datetime,DOC,IsUpdate,IsMasterData,IsDelete) values (?categoryname," + user_id + "," + currenttime.Ticks + "," + currenttime.Ticks + ",1,1,0) ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Manage_Category 106 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
txtcategorynames.Text = "";
ltrErr.Text = "Category Save Successfully.";
}
}
else
{
ltrErr.Text = "Please Enter All Details.";
return;
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Manage_Category 125: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
objmysqldb.ConnectToDatabase();
try
{
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
int Emp_id = 0;
int.TryParse(ddlemplist.Items[ddlemplist.SelectedIndex].Value.ToString(), out Emp_id);
foreach (GridViewRow row in grd.Rows)
{
Label date = (Label)row.FindControl("lbldate");
Label pre_type = (Label)row.FindControl("lbltype");
HtmlSelect ddlgrp = (HtmlSelect)row.FindControl("ddlstatus");
string status = ddlgrp.Value.ToString();
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Employee_Attendance_Override 420: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ltrErr.Text = "";
objmysqldb.ConnectToDatabase();
int grp_id = 0;
if (e.CommandName == "Edit")
{
int.TryParse(e.CommandArgument.ToString(), out grp_id);
if (grp_id > 0)
{
Response.Redirect("~/Manage_TimeGroup.aspx?TimegrpId=" + grp_id + "", false);
}
}
else if (e.CommandName == "del")
{
int.TryParse(e.CommandArgument.ToString(), out grp_id);
DateTime currenttimes = Logger.getIndiantimeDT();
DataTable dttimegrpDetails = objmysqldb.GetData("SELECT emp_id from time_group_assign_emplyee_wise where Group_id=" + grp_id + " and IsDelete=0 ");
if (dttimegrpDetails != null && dttimegrpDetails.Rows.Count == 0)
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.OpenSQlConnection();
string query = "update group_master set IsDelete=1,modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_id + " where Group_id=" + grp_id + "";
int res = objmysqldb.InsertUpdateDeleteData(query);
query = "update employee_punchtime_details_datewise set IsDelete=1,modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_id + " where time_grp_id=" + grp_id + "";
res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Time_Group_List 170 Update error.");
}
else
{
grd.EditIndex = -1;
getBinddata();
ltrErr.Text = "Attendance Time Group Deleted Successfully.";
}
}
else
{
ltrErr.Text = "Employee Assign to select Time Group so you can't delete it.";
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Time_Group_List 188: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ltrErr.Text = "";
objmysqldb.ConnectToDatabase();
int reportgrpid = 0;
int.TryParse(e.CommandArgument.ToString(), out reportgrpid);
if (e.CommandName == "Edit")
{
if (reportgrpid > 0)
{
Response.Redirect("~/ManageEmployeeGroupReports.aspx?repgrp=" + reportgrpid + "", false);
}
}
else if (e.CommandName == "del")
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
DateTime currenttime = Logger.getIndiantimeDT();
string query = "Update report_group_list set IsDelete=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where report_grp_id=" + reportgrpid + " ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("EmployeeGroupForReports 131 Update error.");
}
else
{
ltrErr.Text = "Report Group Delete Successfully";
}
grd.EditIndex = -1;
bindgvdata();
}
else if (e.CommandName == "Img")
{
if (reportgrpid > 0)
{
Response.Redirect("~/ManageEmployeeGroupReportsHeaderImage.aspx?repgrp=" + reportgrpid + "", false);
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("EmployeeGroupForReports 150:: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsaveA4L_Click(object sender, EventArgs e)
{
try
{
ltrA4L.Text = "";
ltrLL.Text = "";
ltrLP.Text = "";
objmysqldb.ConnectToDatabase();
if (fileA4L.HasFile)
{
string uploadFolderPath = "~/HeaderImages/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
if (fileA4L.FileName.ToString().ToLower().Equals("HeaderImages.jpg"))
{
}
else
{
string ext = System.IO.Path.GetExtension(fileA4L.FileName.ToString());
long mode = Logger.getIndiantimeDT().Ticks;
int.TryParse(Request.QueryString["repgrp"].ToString(), out repgrp);
string fileName = repgrp.ToString() + "_" + "A4Landscape" + "_" + mode + ext;
fileA4L.SaveAs(filePath + "\\" + fileName);
string imgPath;
imgPath = System.IO.Path.Combine(filePath, fileName);
System.Drawing.Image img = System.Drawing.Image.FromFile(imgPath);
IMgA4L.ImageUrl = "~/HeaderImages/" + "/" + fileName.ToString();
objmysqldb.OpenSQlConnection();
objmysqldb.AddCommandParameter("A4L_Img", fileName);
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
int retval = objmysqldb.InsertUpdateDeleteData("update report_group_list set A4L_Img=?A4L_Img,modify_datetime=" + mode + ",IsUpdate=1,UserID=" + user_id + " where report_grp_id=" + repgrp + " ");
if (retval > 0)
{
ltrA4L.Text = "Header Image Update Successfully";
}
else
{
ltrA4L.Text = "Header Image Not Update Successfully";
}
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("ManageEmployeeGroupReportsHeaderImage 169: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void saveData()
{
int val = 0;
try
{
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
DataTable gridTable = (DataTable)grdEmplist.DataSource;
DataTable dt = GetDataTable(grdEmplist);
foreach (GridViewRow row in grdEmplist.Rows)
{
TextBox txtpayscale1 = (TextBox)row.FindControl("txtpayscale");
// HtmlInputText txtpayscale1 = (HtmlInputText)row.FindControl("txtpayscale");
Label EmpId = (Label)grdEmplist.Rows[row.RowIndex].FindControl("lblEmp_id");
DateTime currenttime = Logger.getIndiantimeDT();
double salary = 0;
double.TryParse(txtpayscale1.Text.ToString(), out salary);
int empidint = int.Parse(EmpId.Text.ToString());
if (salary > 0)
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
val = objmysqldb.InsertUpdateDeleteData("UPDATE employee_master SET modify_datetime='" + currenttime.Ticks + "',PayScale=" + salary + ",IsUpdate=1,UserID=" + user_id + " WHERE EmpId=" + empidint + " ");
}
}
if (val == 1)
{
ltrErr.Text = "Data Updated Successfully....";
btnsave.Visible = true;
int gid = 0;
//if(Session.co)
if (Session["grpid"] != null)
{
int.TryParse(Session["grpid"].ToString(), out gid);
}
BindGrid(gid);
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("SalaryConfiguration 194: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
if (e.CommandName == "Edit")
{
int.TryParse(e.CommandArgument.ToString(), out profileid);
if (profileid > 0)
{
Response.Redirect("~/addnewqueryprofile.aspx?profile=" + profileid + "", false);
}
}
else if (e.CommandName == "del")
{
int.TryParse(e.CommandArgument.ToString(), out profileid);
DateTime curtime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
string query = "update employee_query_profile set IsDelete=1,modify_datetime=" + curtime.Ticks + ",IsUpdate=1,,UserID=" + user_id + " where Profile_Id=" + profileid + "";
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("addeditprofile 129 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
ltrErr.Text = "Profile Deleted Successfully.";
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("addeditprofile 142: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
public static string getHolidayList(string id)
{
MySQLDB dbc = new MySQLDB();
try
{
int ids = 0;
int.TryParse(id, out ids);
dbc.ConnectToDatabase();
DataTable dtholiday = dbc.GetData("SELECT Holiday_day_id FROM employee_management.holiday_profile_master where Holiday_Profile_Id=" + id + " ");
string response = "";
if (dtholiday != null && dtholiday.Rows.Count > 0)
{
response = dtholiday.Rows[0]["Holiday_day_id"].ToString() + "@@@";
}
//DataTable dtHolidaydetails = dbc.GetData("SELECT Holiday_Day,Holiday_Month,Holiday_Year,Holiday_Reason,Holiday_For_Id FROM holiday_setup where IsDelete=0 and Holiday_Profile_Id=" + id + " ");
//for (int i = 0; i < dtHolidaydetails.Rows.Count; i++)
//{
// response += dtHolidaydetails.Rows[i]["Holiday_Day"].ToString() + "@" + dtHolidaydetails.Rows[i]["Holiday_Month"].ToString() + "@" + dtHolidaydetails.Rows[i]["Holiday_Year"].ToString() + "@" + dtHolidaydetails.Rows[i]["Holiday_Reason"].ToString() + "@" + dtHolidaydetails.Rows[i]["Holiday_For_Id"].ToString() + "###";
//}
response = List_of_Holiday(id, dbc, response);
response = response.TrimEnd('#');
return(response);
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Holiday_Setup 249: exception:" + ex.Message + "::::::::" + ex.StackTrace);
return("");
}
finally
{
dbc.CloseSQlConnection();
dbc.disposeConnectionObj();
}
}
protected void saveData()
{
ltrErr.Text = "";
int success = 0;
objmysqldb.ConnectToDatabase();
try
{
int.TryParse(ddlholidaylist.SelectedValue.ToString(), out holid);
string Emp_Ids = "";
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
DataTable dtselectEmp = objmysqldb.GetData("SELECT emp_id FROM assign_holidayprofile_employee where IsDelete=0 and holiday_profile_id=" + holid + " ");
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox chkAssign = (CheckBox)row.FindControl("cbSelect");
if (chkAssign.Checked)
{
int emp_id = 0;
Label emp = (Label)row.FindControl("lblemp_id");
int.TryParse(emp.Text.ToString(), out emp_id);
Emp_Ids += emp.Text.ToString() + ",";
DateTime currentTime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
//objmysqldb.OpenSQlConnection();
success = objmysqldb.InsertUpdateDeleteData("update assign_holidayprofile_employee set modify_datetime=" + currentTime.Ticks + ",IsUpdate=0,IsDelete=0,UserID=" + user_id + " where holiday_profile_id=" + holid + " and emp_id=" + emp_id + "");
if (success == 0)
{
success = objmysqldb.InsertUpdateDeleteData("INSERT INTO assign_holidayprofile_employee (emp_id,holiday_profile_id, DOC, IsUpdate,IsDelete,modify_datetime,UserID) VALUES (" + emp_id + ", " + holid + "," + currentTime.Ticks + ", '1', '0'," + currentTime.Ticks + "," + user_id + ");");
if (success == -1)
{
ltrErr.Text = "Error While Updating..";
objmysqldb.RollBackSQLTransaction();
return;
}
}
}
}
Emp_Ids = Emp_Ids.TrimEnd(',');
string[] arrempid = Emp_Ids.Split(',');
if (!Emp_Ids.Equals("") && dtselectEmp != null && dtselectEmp.Rows.Count > 0)
{
DataRow[] drdata = dtselectEmp.Select("emp_id NOt IN (" + Emp_Ids + ")");
dtselectEmp = dtselectEmp.Clone();
if (drdata.Length > 0)
{
dtselectEmp = drdata.CopyToDataTable();
}
}
foreach (DataRow dr in dtselectEmp.Rows)
{
DateTime currentTime = Logger.getIndiantimeDT();
success = objmysqldb.InsertUpdateDeleteData("update assign_holidayprofile_employee set modify_datetime=" + currentTime.Ticks + ",IsUpdate=1,IsDelete=1,UserID=" + user_id + " where holiday_profile_id=" + holid + " and emp_id=" + +int.Parse(dr["emp_id"].ToString()) + "");
}
if (success == 1)
{
ltrErr.Text = "Holiday Profile Assigned Successfully...";
objmysqldb.EndSQLTransaction();
bindgrid(holid);
}
}
catch (Exception ex)
{
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("EmployeeAssignHolidayProfile 264: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
public static string saveHolidayProfile(string id, string Name, string userid, string holiday_day)
{
MySQLDB dbc = new MySQLDB();
try
{
string msg = "";
int ids = 0;
int.TryParse(id, out ids);
dbc.ConnectToDatabase();
DataTable dtHolidayProfile = dbc.GetData("SELECT Holiday_Profile_Id,Holiday_Profile_Name,Holiday_day_id FROM holiday_profile_master ");
string response = "";
DataRow[] drdata = dtHolidayProfile.Select("Holiday_Profile_Name ='" + Name + "' and Holiday_Profile_Id <> " + id + " ");
dbc.OpenSQlConnection();
dbc.BeginSQLTransaction();
if (drdata.Length == 0)
{
holiday_day = holiday_day.TrimEnd(',');
DateTime currenttime = Logger.getIndiantimeDT();
int user_ids = 0;
int.TryParse(userid, out user_ids);
int retval = dbc.InsertUpdateDeleteData("update holiday_profile_master set Holiday_Profile_Name='" + Name + "',modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_ids + ",Holiday_day_id='" + holiday_day + "' where Holiday_Profile_Id=" + id + " ");
if (retval == 0)
{
retval = dbc.InsertUpdateDeleteData("insert into holiday_profile_master (Holiday_Profile_Name,modify_datetime,DOC,IsUpdate,UserID,Holiday_day_id) values ('" + Name + "'," + currenttime.Ticks + "," + currenttime.Ticks + ",1," + user_ids + ",'" + holiday_day + "')");
if (retval != 1)
{
msg = "please try again";
Logger.WriteCriticalLog("Holiday_Setup 123 Update error.");
}
else
{
msg = "Save sucessfully";
}
}
else
{
//Holiday setup code
DataRow[] drdatas = dtHolidayProfile.Select("Holiday_Profile_Id = " + id + " ");
if (drdatas.Length > 0)
{
string[] old_Weekoff = drdatas[0]["Holiday_day_id"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] New_Weekoff = holiday_day.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (old_Weekoff.Length > 0)
{
string weekoff = "";
for (int k = 0; k < old_Weekoff.Length; k++)
{
if (!New_Weekoff.Contains(old_Weekoff[k]))
{
weekoff += old_Weekoff[k] + ",";
}
}
string[] Weekoffday = weekoff.ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (Weekoffday.Length > 0)
{
DataTable dtholidaySetup = dbc.GetData("select distinct Holiday_Month,Holiday_Year from holiday_setup where Holiday_For_Id=2 and Holiday_Profile_Id=" + id + " and IsDelete=0;");
if (dtholidaySetup != null && dtholidaySetup.Rows.Count > 0)
{
int mon = 0;
int year = 0;
for (int mo = 0; mo < dtholidaySetup.Rows.Count; mo++)
{
int.TryParse(dtholidaySetup.Rows[mo]["Holiday_Month"].ToString(), out mon);
int.TryParse(dtholidaySetup.Rows[mo]["Holiday_Year"].ToString(), out year);
int LastDate = DateTime.DaysInMonth(year, mon);
string dates = DateOfGivenDay(Weekoffday, mon, year, LastDate);
dates = dates.TrimEnd(',');
if (!dates.Equals(""))
{
DateTime currenttimes = Logger.getIndiantimeDT();
retval = dbc.InsertUpdateDeleteData("update holiday_setup set modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_ids + ",IsDelete=1 where Holiday_Day IN(" + dates + ") and Holiday_Month=" + mon + " and Holiday_Year=" + year + " and Holiday_Profile_Id=" + id + " and Holiday_For_Id=2");
}
}
}
}
}
}
msg = "Save sucessfully";
}
dtHolidayProfile = dbc.GetData("SELECT Holiday_Profile_Id,Holiday_Profile_Name FROM holiday_profile_master ");
for (int i = 0; i < dtHolidayProfile.Rows.Count; i++)
{
if (i == 0)
{
response = response + "-1,";
response = response + "Select Holiday Profile ###";
}
response = response + dtHolidayProfile.Rows[i]["Holiday_Profile_Id"].ToString() + ",";
response = response + dtHolidayProfile.Rows[i]["Holiday_Profile_Name"].ToString() + "###";
}
response = response.TrimEnd('#');
response = response + "@@@" + msg;
}
else
{
msg = "Holiday profile name is already exists";
response = "@@@" + msg;
}
dbc.EndSQLTransaction();
return(response);
}
catch (Exception ex)
{
dbc.RollBackSQLTransaction();
Logger.WriteCriticalLog("Holiday_Setup 206: exception:" + ex.Message + "::::::::" + ex.StackTrace);
return("@@@please try again");
}
finally
{
dbc.CloseSQlConnection();
dbc.disposeConnectionObj();
}
}
public static string MangeHolidays(string id, string type, string date, string reason, string range, string flag, string userid)
{
MySQLDB dbc = new MySQLDB();
try
{
int ids = 0;
int.TryParse(id, out ids);
int typ = 0;
int.TryParse(type, out typ);
int fla = 0;
int.TryParse(flag, out fla);
string msg = "";
string[] dates = date.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
int day = 0;
int mon = 0;
int yea = 0;
dbc.ConnectToDatabase();
int user_ids = 0;
int.TryParse(userid, out user_ids);
if (dates.Length == 3)
{
dbc.OpenSQlConnection();
int.TryParse(dates[0], out day);
int.TryParse(dates[1], out mon);
int.TryParse(dates[2], out yea);
if (fla == 1) //delete
{
DateTime currenttime = Logger.getIndiantimeDT();
int retval = dbc.InsertUpdateDeleteData("update holiday_setup set modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_ids + ",IsDelete=1 where Holiday_Day=" + day + " and Holiday_Month=" + mon + " and Holiday_Year=" + yea + " and Holiday_Profile_Id=" + ids + " ");
msg = "Holiday remove Successfully";
}
else
{
string[] rangedates = range.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
int start = 0;
int end = 0;
if (rangedates.Length == 2)
{
int.TryParse(rangedates[0], out start);
int.TryParse(rangedates[1], out end);
}
int diff = end - start;
for (int i = 0; i <= diff; i++)
{
DateTime currenttime = Logger.getIndiantimeDT();
dbc.AddCommandParameter("Holiday_Reason", reason);
int retval = dbc.InsertUpdateDeleteData("update holiday_setup set modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_ids + ",Holiday_For_Id=" + typ + ",Holiday_Reason=?Holiday_Reason where Holiday_Day=" + day + " and Holiday_Month=" + mon + " and Holiday_Year=" + yea + " and Holiday_Profile_Id=" + id + " and IsDelete=0 ");
if (retval == 0)
{
dbc.AddCommandParameter("Holiday_Reason", reason);
retval = dbc.InsertUpdateDeleteData("insert into holiday_setup (Holiday_Day,Holiday_Month,Holiday_Year,Holiday_Reason,Holiday_For_Id,Holiday_Profile_Id,modify_datetime,DOC,IsUpdate,IsDelete,UserID) values (" + day + "," + mon + "," + yea + " ,?Holiday_Reason," + typ + "," + id + "," + currenttime.Ticks + "," + currenttime.Ticks + ",1,0," + user_ids + ")");
if (retval != 1)
{
msg = "Please try again";
Logger.WriteCriticalLog("Holiday_Setup 433 Update error.");
break;
}
}
day++;
}
if (msg.Equals(""))
{
msg = "Holiday save Successfully";
}
}
}
else
{
msg = "Please Select Valid Date";
}
DataTable dtholiday = dbc.GetData("SELECT Holiday_day_id FROM employee_management.holiday_profile_master where Holiday_Profile_Id=" + id + " ");
string response = "";
if (dtholiday != null && dtholiday.Rows.Count > 0)
{
response = dtholiday.Rows[0]["Holiday_day_id"].ToString() + "@@@";
}
response = List_of_Holiday(id, dbc, response);
response = response.TrimEnd('#');
response = response + "@@##" + msg;
return(response);
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Holiday_Setup 468: exception:" + ex.Message + "::::::::" + ex.StackTrace);
return("");
}
finally
{
dbc.CloseSQlConnection();
dbc.disposeConnectionObj();
}
}
public static string saveDefaultSetup(string id, string month, string userid)
{
MySQLDB dbc = new MySQLDB();
try
{
int ids = 0;
int.TryParse(id, out ids);
string[] months = month.Split('@');
int mon = 0;
int year = 0;
int.TryParse(months[0], out mon);
int.TryParse(months[1], out year);
int LastDate = DateTime.DaysInMonth(year, mon);
dbc.ConnectToDatabase();
int user_ids = 0;
int.TryParse(userid, out user_ids);
DataTable dtholiday = dbc.GetData("SELECT Holiday_day_id FROM employee_management.holiday_profile_master where Holiday_Profile_Id=" + id + " ");
string response = "";
if (dtholiday != null && dtholiday.Rows.Count > 0)
{
string[] Weekoff = dtholiday.Rows[0]["Holiday_day_id"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string dates = DateOfGivenDay(Weekoff, mon, year, LastDate);
dates = dates.TrimEnd(',');
string[] date = dates.ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
dbc.OpenSQlConnection();
dbc.BeginSQLTransaction();
for (int i = 0; i < date.Length; i++)
{
DateTime currenttime = Logger.getIndiantimeDT();
int retval = dbc.InsertUpdateDeleteData("update holiday_setup set modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_ids + " where Holiday_Day=" + int.Parse(date[i].ToString()) + " and Holiday_Month=" + mon + " and Holiday_Year=" + year + " and Holiday_Profile_Id=" + id + " and IsDelete=0 ");
if (retval == 0)
{
retval = dbc.InsertUpdateDeleteData("insert into holiday_setup (Holiday_Day,Holiday_Month,Holiday_Year,Holiday_Reason,Holiday_For_Id,Holiday_Profile_Id,modify_datetime,DOC,IsUpdate,IsDelete,UserID) values (" + int.Parse(date[i].ToString()) + "," + mon + "," + year + " ,'Week off',2," + id + "," + currenttime.Ticks + "," + currenttime.Ticks + ",1,0," + user_ids + ")");
if (retval != 1)
{
dbc.RollBackSQLTransaction();
Logger.WriteCriticalLog("Holiday_Setup 302 Update error.");
return(response);
}
}
}
response = dtholiday.Rows[0]["Holiday_day_id"].ToString() + "@@@";
}
dbc.EndSQLTransaction();
response = List_of_Holiday(id, dbc, response);
response = response.TrimEnd('#');
return(response);
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Holiday_Setup 321: exception:" + ex.Message + "::::::::" + ex.StackTrace);
return("");
}
finally
{
dbc.CloseSQlConnection();
dbc.disposeConnectionObj();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ltrErr.Text = "";
if (txtstartdate.Text == "" && txtenddate.Text == "")
{
ltrErr.Text = "Enter Valid Date..";
//ltrErr.Text = "Select Valid Dates..";
return;
}
else
{
string academicYear = dlYear.Items[dlYear.SelectedIndex].Text;
string[] AcademicYear = academicYear.Split('-');
double totalDays = CountNoOFDays();
char[] ch = { '/' };
//String myString_new1 = String.Format("{0:MM/dd/yyyy}", enddt);
//dtData.Rows[i]["End_Date"] = myString_new1;
string[] spltstart = txtstartdate.Text.Split(ch);
string[] spltend = txtenddate.Text.Split(ch);
dtStart = new DateTime(int.Parse(spltstart[2]), int.Parse(spltstart[1]), int.Parse(spltstart[0]));
dtend = new DateTime(int.Parse(spltend[2]), int.Parse(spltend[1]), int.Parse(spltend[0]));
int startmonth = int.Parse(spltstart[1]);
int endmonth = int.Parse(spltend[1]);
int startyr = int.Parse(spltstart[2]);
int endyear = int.Parse(spltend[2]);
//if ((startyr == Convert.ToInt32(AcademicYear[0])) && (endyear <= Convert.ToInt32(AcademicYear[1])) && (endyear >= Convert.ToInt32(AcademicYear[0])))
//if (startyr != Convert.ToInt32(AcademicYear[0]) && (endyear != Convert.ToInt32(AcademicYear[1])))
if ((startyr >= Convert.ToInt32(AcademicYear[0])) && (endyear <= Convert.ToInt32(AcademicYear[1])) && (startyr <= endyear))
{
if (totalDays > 366 || totalDays <= 0)
{
ltrErr.Text = "Enter Valid Date..";
//ltrErr.Text = "Choose VAlid Dates.";
return;
}
else
{
try
{
DateTime currenttime = Logger.getIndiantimeDT();
int val = 0;
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
val = objmysqldb.InsertUpdateDeleteData("insert into AcademicYear(Academic_Year,modify_datetime,DOC,Start_Date,End_Date,IsUpdate,IsDelete,UserID)values('" + academicYear + "'," + currenttime.Ticks + "," + currenttime.Ticks + " ," + dtStart.Ticks + ",'" + dtend.Ticks + "',0,0," + user_id + ")");
if (val == 1)
{
ltrErr.Text = "Academic Year Saved Suceessfully...";
txtstartdate.Text = "";
txtenddate.Text = "";
txttotaldays.Text = "";
fillWithData();
bindCombo();
}
}
//}
catch (Exception ex)
{
Logger.WriteCriticalLog("AcademicYearSetUp 280: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
}
else
{
ltrErr.Text = "Enter Valid Input..";
// ltrErr.Text = "Selected Year MustMatch With year in Seleted Date";
//ltrErr.Text = "";
}
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Academic Year SetUp 244: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
ltrErr.Text = "";
try
{
objmysqldb.ConnectToDatabase();
int fid = 0;
int sortnumber = 0;
//for (int i = 0; i < grd.Rows.Count; i++)
//{
// DataTable dataTable = (DataTable)grd.DataSource;
// foreach (DataRow dr in dataTable.Rows)
// {
// TextBox txtsno = (TextBox)grd.Rows[i].Cells[1].FindControl("txtsortnumber");
// if (dr["SortNumber"].ToString() == txtsno.Text)
// {
// ltrErr.Text = "Sort Number already exist";
// break;
// }
// }
//}
objmysqldb.OpenSQlConnection();
foreach (GridViewRow row in grd.Rows)
{
CheckBox chk1 = (CheckBox)row.FindControl("cbSelect");
TextBox txtfield = new TextBox();
Label lblfid = new Label();
TextBox txtsort = new TextBox();
txtfield = (TextBox)row.FindControl("txtDisplay_Name");
lblfid = (Label)row.FindControl("lblEmployee_Field_id");
txtsort = (TextBox)row.FindControl("txtsortnumber");
string fieldname = txtfield.Text.ToString().Trim();
int.TryParse(txtsort.Text.ToString(), out sortnumber);
int.TryParse(lblfid.Text.ToString(), out fid);
DateTime currenttime = Logger.getIndiantimeDT();
DataTable dtsort = objmysqldb.GetData("Select * from employee_search_field_config where SortNumber=" + sortnumber + " and Is_Show=1 and Employee_field_id<>" + fid + "");
if (chk1.Checked)
{
if (fieldname == "")
{
ltrErr.Text = "Please Enter Field Display Name.";
return;
}
else
{
if (dtsort.Rows.Count > 0 && dtsort != null)
{
ltrErr.Text = "Please Enter Different Sort Number";
return;
}
else
{
//objmysqldb.ConnectToDatabase();
objmysqldb.AddCommandParameter("fieldname", fieldname);
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
string query = "update employee_search_field_config set FieldDisplayName=?fieldname,Is_Show=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + ", SortNumber=" + sortnumber + " where Employee_Field_id=" + fid + "";
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("DisplayColumnConfigurationForSearchEmployee 188 Update error.");
return;
}
else
{
grd.EditIndex = -1;
chk1.Checked = true;
ltrErr.Text = "Save successfully.";
}
}
}
}
else
{
if (fieldname == "")
{
ltrErr.Text = "Please Enter Field Display Name.";
return;
}
else
{
// objmysqldb.ConnectToDatabase();
objmysqldb.AddCommandParameter("fieldname", fieldname);
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
string query = "update employee_search_field_config set FieldDisplayName=?fieldname,Is_Show=0,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " ,SortNumber=" + sortnumber + " where Employee_Field_id=" + fid + "";
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("DisplayColumnConfigurationForSearchEmployee 218 Update error.");
return;
}
else
{
grd.EditIndex = -1;
chk1.Checked = false;
ltrErr.Text = "Save successfully.";
}
}
}
}
showgrid();
}
catch (Exception ex)
{
Logger.WriteCriticalLog("DisplayColumnConfigurationForSearchEmployee 234: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
private void Savedata()
{
objmysqldb.ConnectToDatabase();
try
{
string date = txtattDate.Text.ToString();
int year = 0;
int month = 0;
int day = 0;
string[] arrdob = date.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
long dateticks = 0;
if (arrdob.Length == 3)
{
int.TryParse(arrdob[2].ToString(), out year);
int.TryParse(arrdob[1].ToString(), out month);
int.TryParse(arrdob[0].ToString(), out day);
dateticks = new DateTime(year, month, day).Ticks;
}
if (arrdob.Length != 3 && dateticks == 0)
{
ltrErr.Text = "Attendance Date is not in proper format.";
return;
}
DataTable dtAttendanceData = objmysqldb.GetData("select emp_id,DateTicks,Type,Overlap,Update_Type from employee_attendance_daily where DateTicks=" + dateticks + " ");
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
string emp_ids = "";
foreach (GridViewRow row in grd.Rows)
{
int emp_id = 0;
int type = 0;
Label emp = (Label)row.FindControl("lblEmp_id");
//CheckBox chkpresent = (CheckBox)row.FindControl("cbSelectPresent");
RadioButton chkpresent = (RadioButton)row.FindControl("cbSelectPresent");
RadioButton chkhalfday = (RadioButton)row.FindControl("cbSelectHalfday");
RadioButton chkabsent = (RadioButton)row.FindControl("cbSelectabsent");
Label overrideatt = (Label)row.FindControl("lbloverride");
int attUpdate = 0;
int.TryParse(overrideatt.Text.ToString(), out attUpdate);
int.TryParse(emp.Text.ToString(), out emp_id);
//if (attUpdate == 1)
//{
// continue;
//}
if (chkpresent.Checked)
{
type = 1;
}
if (chkhalfday.Checked)
{
if (type > 0)
{
ltrErr.Text = "Please enter valid Attendance";
objmysqldb.RollBackSQLTransaction();
bindGvdata(year, month, day);
return;
}
type = 2;
}
if (chkabsent.Checked)
{
if (type > 0)
{
ltrErr.Text = "Please enter valid Attendance";
objmysqldb.RollBackSQLTransaction();
bindGvdata(year, month, day);
return;
}
type = 3;
}
DateTime currenttime = Logger.getIndiantimeDT();
if (type > 0)//insert Update
{
//tye same old and nw?
DataRow[] drdata = dtAttendanceData.Select("emp_id=" + emp_id + "");
int retval = 0;
if (drdata.Length > 0)
{
int oldtype = 0;
int.TryParse(drdata[0]["Type"].ToString(), out oldtype);
if (type == oldtype)
{
retval = objmysqldb.InsertUpdateDeleteData(" update employee_attendance_daily set Type=" + type + ",UserID=" + user_id + ",modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,IsDelete=0 where emp_id=" + emp_id + " and DateTicks=" + dateticks + " ");
}
else
{
retval = objmysqldb.InsertUpdateDeleteData(" update employee_attendance_daily set Type=" + type + ",Overlap=1,Update_Type=" + oldtype + ",UserID=" + user_id + ",modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,IsDelete=0 where emp_id=" + emp_id + " and DateTicks=" + dateticks + " ");
}
}
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into employee_attendance_daily (emp_id,DateTicks,Type,Overlap,Update_Type,UserID,modify_datetime,DOC,IsUpdate,IsDelete) values (" + emp_id + " ," + dateticks + "," + type + ",0,0," + user_id + "," + currenttime.Ticks + "," + currenttime.Ticks + ",1,0)");
if (retval != 1)
{
ltrErr.Text = "please try again";
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Employee_Attendance 178 Update error.");
return;
}
}
else
{
emp_ids += emp_id.ToString() + ",";
}
}
}
emp_ids = emp_ids.TrimEnd(',');
if (!emp_ids.Equals("") && dtAttendanceData != null && dtAttendanceData.Rows.Count > 0)
{
//string[] employees = emp_id.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
DataRow[] drdata = dtAttendanceData.Select("emp_id NOT IN(" + emp_ids + ") ");
dtAttendanceData = dtAttendanceData.Clone();
if (drdata.Length > 0)
{
dtAttendanceData = drdata.CopyToDataTable();
}
}
DateTime currentTimes = Logger.getIndiantimeDT();
foreach (DataRow dr in dtAttendanceData.Rows)
{
int retval = objmysqldb.InsertUpdateDeleteData(" update employee_attendance_daily set UserID=" + user_id + ",modify_datetime=" + currentTimes.Ticks + ",IsUpdate=1,IsDelete=1 where emp_id=" + int.Parse(dr["emp_id"].ToString()) + " and DateTicks=" + dateticks + " ");
}
objmysqldb.EndSQLTransaction();
bindGvdata(year, month, day);
ltrErr.Text = "Employee Attendance save Successfully.";
}
catch (Exception ex)
{
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Employee_Attendance 215: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
query_insert_update();
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
if (allowinsert)
{
int profileid = 0;
int.TryParse(profile_idHidden.Value.ToString(), out profileid);
if (txtprofile.Text == "" || txtquery.Text == "")
{
ltrErr.Text = "Please Enter all Data.";
}
else
{
DateTime currenttime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
DataTable dtdata = objmysqldb.GetData("Select * from employee_query_profile where Profile_Id=" + profileid +
"");
DataTable dtprofile = objmysqldb.GetData("Select * from employee_query_profile where Profile_Name='" + txtprofile.Text + "' and Profile_Id<>" + profileid + " and IsDelete=0");
if (dtdata != null && dtdata.Rows.Count > 0)
{
if (dtprofile != null && dtprofile.Rows.Count > 0)
{
ltrErr.Text = "Profile Name Already Exist.";
return;
}
else
{
objmysqldb.AddCommandParameter("profile", txtprofile.Text.ToString());
objmysqldb.AddCommandParameter("query", txtquery.Text.ToString());
string updatequery = "update employee_query_profile set Profile_Name=?profile,Profile_Text=?query,modify_datetime=" + currenttime.Ticks + ",UserID=" + user_id + ",IsDelete=0,IsUpdate=1 where Profile_Id=" + profileid + " ";
int resupdate = objmysqldb.InsertUpdateDeleteData(updatequery);
if (resupdate != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Add New Query Profile 194 Update error.");
}
else
{
long lastp_id = objmysqldb.LastNo("employee_query_profile", "Profile_Id", currenttime.Ticks);
profile_idHidden.Value = lastp_id.ToString();
btnExport.Visible = true;
ltrErr.Text = "Query Profile Updated Successfully";
ViewState["p_id="] = profile_idHidden.Value;
ViewState["msg"] = ltrErr.Text;
}
}
}
else
{
DataTable dtprofiles = objmysqldb.GetData("Select * from employee_query_profile where Profile_Name='" + txtprofile.Text + "' and IsDelete=0");
if (dtprofiles != null && dtprofiles.Rows.Count > 0)
{
ltrErr.Text = "Profile Name Already Exist.";
return;
}
else
{
objmysqldb.AddCommandParameter("profile", txtprofile.Text.ToString());
objmysqldb.AddCommandParameter("query", txtquery.Text.ToString());
string query = "Insert into employee_query_profile(Profile_Name,Profile_Text,modify_datetime,DOC,UserID,IsDelete,IsUpdate)values(?profile,?query," + currenttime.Ticks + "," + currenttime.Ticks + "," + user_id + ",0,1)";
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Add New Query Profile 227 Update error.");
}
else
{
long lastp_id = objmysqldb.LastNo("employee_query_profile", "Profile_Id", currenttime.Ticks);
profile_idHidden.Value = lastp_id.ToString();
ltrErr.Text = "Query Profile Save Successfully";
btnExport.Visible = true;
ViewState["p_id="] = profile_idHidden.Value;
ViewState["msg"] = ltrErr.Text;
}
}
}
}
}
else
{
ltrErr.Text = "Query Not Run Successfully.";
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Add New Query Profile 251: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
private void Savedata()
{
objmysqldb.ConnectToDatabase();
try
{
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
foreach (GridViewRow row in grd.Rows)
{
int emp_id = 0;
string timegrp = "";
int late = 0;
int absent = 0;
int forgetoutPunch = 0;
int Email = 0;
int grp_id = 0;
Label emp = (Label)row.FindControl("lblEmp_id");
Label grp = (Label)row.FindControl("lblgrp_id");
CheckBox chkleft = (CheckBox)row.FindControl("cbSelectlate");
CheckBox chkabsent = (CheckBox)row.FindControl("cbSelectabsent");
CheckBox chkforgetOut = (CheckBox)row.FindControl("cbSelectOutpunch");
CheckBox chkEmail = (CheckBox)row.FindControl("cbSelectEmail");
HtmlSelect ddlgrp = (HtmlSelect)row.FindControl("ddltime");
if (chkleft.Checked)
{
late = 1;
}
if (chkabsent.Checked)
{
absent = 1;
}
if (chkforgetOut.Checked)
{
forgetoutPunch = 1;
}
if (chkEmail.Checked)
{
Email = 1;
}
int.TryParse(emp.Text.ToString(), out emp_id);
timegrp = ddlgrp.Value.ToString();
if (!timegrp.Equals("1000"))
{
int.TryParse(timegrp.ToString(), out grp_id);
}
DateTime currenttime = Logger.getIndiantimeDT();
if (grp_id > 0)
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
int retval = objmysqldb.InsertUpdateDeleteData("update time_group_assign_emplyee_wise set Group_id=" + grp_id + ",OutPuch_SMS=" + forgetoutPunch + ",Absent_Sms=" + absent + ",Late_SMS=" + late + ",Email_Sent=" + Email + ",modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where IsDelete=0 and emp_id=" + emp_id + " ");
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into time_group_assign_emplyee_wise (emp_id,Group_id,OutPuch_SMS,Absent_Sms,Late_SMS,Email_Sent,modify_datetime,DOC,IsDelete,IsUpdate,UserID) values (" + emp_id + " ," + grp_id + "," + forgetoutPunch + "," + absent + "," + late + "," + Email + "," + currenttime.Ticks + "," + currenttime.Ticks + ",0,1," + user_id + ")");
if (retval != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("TimeGroup_AssignToEmployee 345 Update error.");
objmysqldb.RollBackSQLTransaction();
return;
}
}
DataTable dtgroup = new DataTable();
dtgroup = objmysqldb.GetData("select * from group_master where Group_id=" + grp_id + "");
DataTable dtgrouptime = new DataTable();
dtgrouptime = objmysqldb.GetData("select * from groupwise_time_config where Group_Time_Id=" + grp_id + "");
if (dtgrouptime != null && dtgrouptime.Rows.Count > 0)
{
DateTime currenttimes = Logger.getIndiantimeDT();
retval = objmysqldb.InsertUpdateDeleteData("update employeewise_punchtime_details_datewise set IsDelete=1,modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_id + " where emp_id=" + emp_id + "");
long dateticks = 0;
long.TryParse(dtgroup.Rows[0]["Changes_Applicable_Date"].ToString(), out dateticks);
DateTime dtcur = MySQLDB.GetIndianTime();
DateTime dtcurrent = new DateTime(dtcur.Year, dtcur.Month, dtcur.Day);
long curdateticks = 0;
long ticks = long.Parse(dtgroup.Rows[0]["Changes_Applicable_Date"].ToString());
DateTime dt = new DateTime(ticks);
String myString_new = String.Format("{0:dd/MM/yyyy}", dt);
TimeSpan dtDiff = dt - dtcurrent;
DateTime dtstartdate = dtcurrent;
if (dtDiff.Days < 0)
{
dtDiff = dtcurrent - dt;
dtstartdate = dt;
}
for (int d1 = 0; d1 <= dtDiff.Days; d1++)
{
DateTime dtt1 = dtstartdate.AddDays(d1);
//foreach (DataRow dr in dtdata.Rows)
int days1 = (int)dtt1.DayOfWeek;
if (days1 == 0)
{
days1 = 7;
}
DataRow[] drdaywise1 = dtgrouptime.Select("Day_id =" + days1 + " ");
foreach (DataRow dr in drdaywise1)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into employeewise_punchtime_details_datewise (Dateticks,emp_id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Early_min,Ext_Late_hour,Ext_Late_min,modify_datetime,DOC,IsUpdate,UserID,IsDelete) values (" + dtt1.Ticks + "," + emp_id + "," + int.Parse(dr["Day_id"].ToString()) + "," + int.Parse(dr["In_hour"].ToString()) + "," + int.Parse(dr["In_min"].ToString()) + "," + int.Parse(dr["out_hour"].ToString()) + "," + int.Parse(dr["out_min"].ToString()) + "," + int.Parse(dr["Ext_Early_hour"].ToString()) + "," + int.Parse(dr["Ext_Early_min"].ToString()) + "," + int.Parse(dr["Ext_Late_hour"].ToString()) + "," + int.Parse(dr["Ext_Late_min"].ToString()) + "," + currenttimes.Ticks + "," + currenttimes.Ticks + ",1," + user_id + ",0)");
}
}
}
}
}
objmysqldb.EndSQLTransaction();
Search();
ltrErr.Text = "Time Group Assign Successfully.";
}
catch (Exception ex)
{
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Employee_AssignToTimeGroup 360: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.disposeConnectionObj();
objmysqldb.CloseSQlConnection();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ltrErr.Text = "";
if (e.CommandName == "del")
{
string[] arg = e.CommandArgument.ToString().Split(':');
if (arg != null && arg.Length == 2)
{
int deptId = 0;
int.TryParse(arg[1], out deptId);
objmysqldb.ConnectToDatabase();
dtdeptList = objmysqldb.GetData("Select department_id from department_master WHERE department_id =" + deptId + " ");
string qu = "Select empId from employee_master WHERE EmpDeptID=" + deptId + "";
DataTable dtemp = objmysqldb.GetData(qu);
if (dtemp != null && dtemp.Rows.Count > 0)
{
ltrErr.Text = "Employee Assign to selected Department so you can't delete it";
return;
}
else
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
DateTime currenttime = Logger.getIndiantimeDT();
string query = "Update department_master set IsDelete=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where department_id=" + deptId + " ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Manage_Department 194 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
ltrErr.Text = "Department Delete Successfully.";
}
}
}
else
{
showgrid();
ltrErr.Text = "Please Try Again.";
}
grd.EditIndex = -1;
}
else if (e.CommandName == "Edit")
{
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Manage_Department 218: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
private void savedata()
{
objmysqldb.ConnectToDatabase();
try
{
ltrErr.Text = "";
int rep_grp = 0;
int.TryParse(report_grp.Value.ToString(), out rep_grp);
if (txtgroup.Text.Equals(""))
{
ltrErr.Text = "Please enter Report Group Name";
return;
}
DataTable dtprevData = objmysqldb.GetData("select report_grp_id from report_group_list where IsDelete=0 and report_grp_name = '" + txtgroup.Text.ToString() + "' ");
//if (dtprevData != null && dtprevData.Rows.Count > 0)
//{
// ltrErr.Text = "Report Group Name Is Already Exsits";
// return;
//}
string emp_ids = "";
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox chkshow = (CheckBox)row.FindControl("cbSelect");
if (chkshow.Checked)
{
int emp_id = 0;
Label emp = (Label)row.FindControl("lblemp_id");
int.TryParse(emp.Text.ToString(), out emp_id);
emp_ids += emp_id + ",";
}
}
if (emp_ids.Equals(""))
{
ltrErr.Text = "Please select atleast one emoloyee";
return;
}
else
{
emp_ids = emp_ids.TrimEnd(',');
DateTime currentTime = Logger.getIndiantimeDT();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.OpenSQlConnection();
objmysqldb.AddCommandParameter("report_grp_name", txtgroup.Text.ToString());
int retval = objmysqldb.InsertUpdateDeleteData("update report_group_list set modify_datetime=" + currentTime.Ticks + ",IsDelete=0,IsUpdate=1,UserID=" + user_id + ",emp_ids='" + emp_ids + "',Is_Default=0,report_grp_name=?report_grp_name where report_grp_id=" + rep_grp + " ");
if (retval == 0)
{
long mode = Logger.getIndiantimeDT().Ticks;
objmysqldb.AddCommandParameter("report_grp_name", txtgroup.Text.ToString());
if (dtprevData != null && dtprevData.Rows.Count > 0)
{
ltrErr.Text = "Report Group Name Is Already Exsits";
return;
}
retval = objmysqldb.InsertUpdateDeleteData("insert into report_group_list (emp_ids,modify_datetime,DOC,IsDelete,IsUpdate,UserID,report_grp_name,Is_Default) values ('" + emp_ids + "'," + mode + "," + currentTime.Ticks + ",0,1," + user_id + ",?report_grp_name,0) ");
if (retval != 1)
{
ltrErr.Text = "please try again";
Logger.WriteCriticalLog("ManageEmployeeGroupReports 204 Update error.");
return;
}
rep_grp = int.Parse(objmysqldb.LastNo("report_group_list", "report_grp_id", mode).ToString());
if (rep_grp == 1)
{
objmysqldb.InsertUpdateDeleteData("update report_group_list set Is_Default=1 where report_grp_id=" + rep_grp + " ");
}
}
if (chkIsDefault.Checked)
{
objmysqldb.InsertUpdateDeleteData("update report_group_list set modify_datetime=" + currentTime.Ticks + ",IsDelete=0,IsUpdate=1,UserID=" + user_id + ",Is_Default=0 ");
objmysqldb.InsertUpdateDeleteData("update report_group_list set Is_Default=1 where report_grp_id=" + rep_grp + " ");
}
}
int flg = 0;
if (chkleft.Checked)
{
flg = 1;
}
bindgvdata(rep_grp, flg);
ltrErr.Text = "Report group Assign to employee Successfully.";
}
catch (Exception ex)
{
Logger.WriteCriticalLog("ManageEmployeeGroupReports 243: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
objmysqldb.ConnectToDatabase();
try
{
ltrErr.Text = "";
int grp_id = 0;
int.TryParse(time_grp.Value.ToString(), out grp_id);
if (txtgroup.Text.Equals("") || SMSintime.Value.ToString().Equals("") || smsout.Value.ToString().Equals(""))
{
ltrErr.Text = "Please enter all details";
return;
}
long dateticks = 0;
try
{
string[] arrchangeDate = date.Text.Split('/');
dateticks = new DateTime(int.Parse(arrchangeDate[2]), int.Parse(arrchangeDate[1]), int.Parse(arrchangeDate[0])).Ticks;
}
catch (Exception aa)
{
}
if (dateticks == 0)
{
ltrErr.Text = "Please Enter valid Applicable change date";
return;
}
DataTable dtPreviousTimeConfig = objmysqldb.GetData("select GroupWise_Time_Id,Group_Time_Id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Early_min,Ext_Late_hour,Ext_Late_min from groupwise_time_config where Group_Time_Id=" + grp_id + " ");
DataTable dtPreviousgrpdata = objmysqldb.GetData("select Group_id,Group_Name,Absent_SMS_After,OutPuch_SMS_After,Changes_Applicable_Date from group_master");
if (dtPreviousTimeConfig != null && dtPreviousgrpdata != null)
{
DataRow[] drgrp = dtPreviousgrpdata.Select("Group_Name ='" + txtgroup.Text.ToString() + "' and Group_id <> " + grp_id + " ");
if (drgrp.Length > 0)
{
ltrErr.Text = "Group name already exists";
return;
}
DataTable dtdata = new DataTable();
dtdata.Columns.Add("Day_id", typeof(Int32));
dtdata.Columns.Add("In_hour", typeof(Int32));
dtdata.Columns.Add("In_min", typeof(Int32));
dtdata.Columns.Add("out_hour", typeof(Int32));
dtdata.Columns.Add("out_min", typeof(Int32));
dtdata.Columns.Add("Ext_Early_hour", typeof(Int32));
dtdata.Columns.Add("Ext_Early_min", typeof(Int32));
dtdata.Columns.Add("Ext_Late_hour", typeof(Int32));
dtdata.Columns.Add("Ext_Late_min", typeof(Int32));
#region time check
foreach (GridViewRow row in grd.Rows)
{
Label dayid = (Label)row.FindControl("lbldayid");
TextBox txtIn = (TextBox)row.FindControl("txtIntime");
TextBox txtOut = (TextBox)row.FindControl("txtoutTime");
TextBox txtEarly = (TextBox)row.FindControl("txtearly");
TextBox txtLate = (TextBox)row.FindControl("txtlate");
if (txtIn.Text.ToString().Equals("") || txtOut.Text.ToString().Equals("") || txtEarly.Text.ToString().Equals("") || txtLate.Text.ToString().Equals(""))
{
ltrErr.Text = "Please enter all time slot";
return;
}
string[] intime = txtIn.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] outtime = txtOut.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] Earlytime = txtEarly.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] latetime = txtLate.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
if (intime.Length != 2 || outtime.Length != 2 || Earlytime.Length != 2 || latetime.Length != 2)
{
ltrErr.Text = "Please enter valid time ";
return;
}
int day = 0;
int.TryParse(dayid.Text.ToString(), out day);
int In_hour = 0;
int In_min = 0;
int out_hour = 0;
int out_min = 0;
int Ext_Early_hour = 0;
int Ext_Early_min = 0;
int Ext_Late_hour = 0;
int Ext_Late_min = 0;
int.TryParse(intime[0], out In_hour);
int.TryParse(intime[1], out In_min);
int.TryParse(outtime[0], out out_hour);
int.TryParse(outtime[1], out out_min);
int.TryParse(Earlytime[0], out Ext_Early_hour);
int.TryParse(Earlytime[1], out Ext_Early_min);
int.TryParse(latetime[0], out Ext_Late_hour);
int.TryParse(latetime[1], out Ext_Late_min);
if (In_hour > 23 || In_min > 59 || out_hour > 23 || out_min > 59 || Ext_Early_hour > 23 || Ext_Early_min > 59 || Ext_Late_hour > 23 || Ext_Late_min > 59)
{
ltrErr.Text = "Please enter valid time ";
return;
}
dtdata.Rows.Add(day, In_hour, In_min, out_hour, out_min, Ext_Early_hour, Ext_Early_min, Ext_Late_hour, Ext_Late_min);
}
#endregion
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
objmysqldb.AddCommandParameter("Group_Name", txtgroup.Text.ToString());
int absent = 0;
int outpunch = 0;
int.TryParse(SMSintime.Value.ToString(), out absent);
int.TryParse(smsout.Value.ToString(), out outpunch);
DateTime currenttime = Logger.getIndiantimeDT();
if (grp_id > 0)
{
objmysqldb.InsertUpdateDeleteData("update group_master set Group_Name=?Group_Name,Absent_SMS_After=" + absent + ",OutPuch_SMS_After=" + outpunch + ",Changes_Applicable_Date=" + dateticks + ",modify_datetime=" + currenttime.Ticks + ", IsUpdate=1, UserID=" + user_id + " where Group_id = " + grp_id + "");
}
else
{
long mode = currenttime.Ticks;
int res = objmysqldb.InsertUpdateDeleteData("insert into group_master (Group_Name,Absent_SMS_After,OutPuch_SMS_After,Changes_Applicable_Date,modify_datetime,DOC,IsUpdate,UserID,IsDelete) values (?Group_Name," + absent + "," + outpunch + "," + dateticks + "," + mode + "," + mode + ",1," + user_id + ",0) ");
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Manage_TimeGroup 205 Update error.");
return;
}
else
{
long lastgrpid = objmysqldb.LastNo("group_master", "Group_id", mode);
ViewState["TimegrpId"] = lastgrpid.ToString();
time_grp.Value = (string)ViewState["TimegrpId"];
int.TryParse(time_grp.Value.ToString(), out grp_id);
//Emp_idHidden.Value = lastEmpid.ToString();
//Response.Redirect("~/ManageEmployee.aspx?Emp=" + Emp_idHidden.Value.ToString() + "", false);
}
}
foreach (DataRow dr in dtdata.Rows)
{
int retval = objmysqldb.InsertUpdateDeleteData("update groupwise_time_config set In_hour=" + int.Parse(dr["In_hour"].ToString()) + ",In_min=" + int.Parse(dr["In_min"].ToString()) + ",out_hour=" + int.Parse(dr["out_hour"].ToString()) + ",out_min=" + int.Parse(dr["out_min"].ToString()) + ",Ext_Early_hour=" + int.Parse(dr["Ext_Early_hour"].ToString()) + ",Ext_Early_min=" + int.Parse(dr["Ext_Early_min"].ToString()) + ",Ext_Late_hour=" + int.Parse(dr["Ext_Late_hour"].ToString()) + ",Ext_Late_min=" + int.Parse(dr["Ext_Late_min"].ToString()) + ",modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where Group_Time_Id=" + grp_id + " and Day_id=" + int.Parse(dr["Day_id"].ToString()) + " ");
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into groupwise_time_config (Group_Time_Id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Early_min,Ext_Late_hour,Ext_Late_min,modify_datetime,DOC,IsUpdate,UserID) values (" + grp_id + "," + int.Parse(dr["Day_id"].ToString()) + "," + int.Parse(dr["In_hour"].ToString()) + "," + int.Parse(dr["In_min"].ToString()) + "," + int.Parse(dr["out_hour"].ToString()) + "," + int.Parse(dr["out_min"].ToString()) + "," + int.Parse(dr["Ext_Early_hour"].ToString()) + "," + int.Parse(dr["Ext_Early_min"].ToString()) + "," + int.Parse(dr["Ext_Late_hour"].ToString()) + "," + int.Parse(dr["Ext_Late_min"].ToString()) + "," + currenttime.Ticks + "," + currenttime.Ticks + ",1," + user_id + ")");
}
}
// Applicable Date change
string[] arrdob = date.Text.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
DateTime dtcur = MySQLDB.GetIndianTime();
if (arrdob.Length == 3)
{
DateTime dtchangeDate = new DateTime(int.Parse(arrdob[2]), int.Parse(arrdob[1]), int.Parse(arrdob[0]));
DateTime dtcurrent = new DateTime(dtcur.Year, dtcur.Month, dtcur.Day);
TimeSpan dtDiff = dtchangeDate - dtcurrent;
DateTime dtstartdate = dtcurrent;
if (dtDiff.Days < 0)
{
dtDiff = dtcurrent - dtchangeDate;
dtstartdate = dtchangeDate;
}
#region datewise entry
DateTime currenttimes = Logger.getIndiantimeDT();
for (int d = 0; d <= dtDiff.Days; d++)
{
DateTime dtt = dtstartdate.AddDays(d);
//foreach (DataRow dr in dtdata.Rows)
int days = (int)dtt.DayOfWeek;
if (days == 0)
{
days = 7;
}
DataRow[] drdaywise = dtdata.Select("Day_id =" + days + " ");
foreach (DataRow dr in drdaywise)
{
int retval = objmysqldb.InsertUpdateDeleteData("update employee_punchtime_details_datewise set In_hour=" + int.Parse(dr["In_hour"].ToString()) + ",In_min=" + int.Parse(dr["In_min"].ToString()) + ",out_hour=" + int.Parse(dr["out_hour"].ToString()) + ",out_min=" + int.Parse(dr["out_min"].ToString()) + ",Ext_Early_hour=" + int.Parse(dr["Ext_Early_hour"].ToString()) + ",Ext_Early_min=" + int.Parse(dr["Ext_Early_min"].ToString()) + ",Ext_Late_hour=" + int.Parse(dr["Ext_Late_hour"].ToString()) + ",Ext_Late_min=" + int.Parse(dr["Ext_Late_min"].ToString()) + ",modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_id + " where time_grp_id=" + grp_id + " and Day_id=" + int.Parse(dr["Day_id"].ToString()) + " and Dateticks=" + dtt.Ticks + " ");
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into employee_punchtime_details_datewise (Dateticks,time_grp_id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Early_min,Ext_Late_hour,Ext_Late_min,modify_datetime,DOC,IsUpdate,UserID,IsDelete) values (" + dtt.Ticks + "," + grp_id + "," + int.Parse(dr["Day_id"].ToString()) + "," + int.Parse(dr["In_hour"].ToString()) + "," + int.Parse(dr["In_min"].ToString()) + "," + int.Parse(dr["out_hour"].ToString()) + "," + int.Parse(dr["out_min"].ToString()) + "," + int.Parse(dr["Ext_Early_hour"].ToString()) + "," + int.Parse(dr["Ext_Early_min"].ToString()) + "," + int.Parse(dr["Ext_Late_hour"].ToString()) + "," + int.Parse(dr["Ext_Late_min"].ToString()) + "," + currenttimes.Ticks + "," + currenttimes.Ticks + ",1," + user_id + ",0)");
}
}
}
DataTable dtgroupdata = new DataTable();
dtgroupdata = objmysqldb.GetData("select * from employee_management.time_group_assign_emplyee_wise where Group_id=" + grp_id + "");
if (dtgroupdata.Rows.Count > 0 && dtgroupdata != null)
{
for (int d1 = 0; d1 <= dtDiff.Days; d1++)
{
DateTime dtt1 = dtstartdate.AddDays(d1);
//foreach (DataRow dr in dtdata.Rows)
int days1 = (int)dtt1.DayOfWeek;
if (days1 == 0)
{
days1 = 7;
}
DataRow[] drdaywise1 = dtdata.Select("Day_id =" + days1 + " ");
for (int emp = 0; emp < dtgroupdata.Rows.Count; emp++)
{
foreach (DataRow dr in drdaywise1)
{
int retval = objmysqldb.InsertUpdateDeleteData("update employeewise_punchtime_details_datewise set In_hour=" + int.Parse(dr["In_hour"].ToString()) + ",In_min=" + int.Parse(dr["In_min"].ToString()) + ",out_hour=" + int.Parse(dr["out_hour"].ToString()) + ",out_min=" + int.Parse(dr["out_min"].ToString()) + ",Ext_Early_hour=" + int.Parse(dr["Ext_Early_hour"].ToString()) + ",Ext_Early_min=" + int.Parse(dr["Ext_Early_min"].ToString()) + ",Ext_Late_hour=" + int.Parse(dr["Ext_Late_hour"].ToString()) + ",Ext_Late_min=" + int.Parse(dr["Ext_Late_min"].ToString()) + ",modify_datetime=" + currenttimes.Ticks + ",IsUpdate=1,UserID=" + user_id + " where emp_id=" + int.Parse(dtgroupdata.Rows[emp]["emp_id"].ToString()) + " and Day_id=" + int.Parse(dr["Day_id"].ToString()) + " and Dateticks=" + dtt1.Ticks + " ");
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into employeewise_punchtime_details_datewise (Dateticks,emp_id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Early_min,Ext_Late_hour,Ext_Late_min,modify_datetime,DOC,IsUpdate,UserID,IsDelete) values (" + dtt1.Ticks + "," + int.Parse(dtgroupdata.Rows[emp]["emp_id"].ToString()) + "," + int.Parse(dr["Day_id"].ToString()) + "," + int.Parse(dr["In_hour"].ToString()) + "," + int.Parse(dr["In_min"].ToString()) + "," + int.Parse(dr["out_hour"].ToString()) + "," + int.Parse(dr["out_min"].ToString()) + "," + int.Parse(dr["Ext_Early_hour"].ToString()) + "," + int.Parse(dr["Ext_Early_min"].ToString()) + "," + int.Parse(dr["Ext_Late_hour"].ToString()) + "," + int.Parse(dr["Ext_Late_min"].ToString()) + "," + currenttimes.Ticks + "," + currenttimes.Ticks + ",1," + user_id + ",0)");
}
}
}
}
}
#endregion
ltrErr.Text = "Time Group Details Save Successfully";
objmysqldb.EndSQLTransaction();
}
else
{
ltrErr.Text = "Please Enter valid Applicable change date";
objmysqldb.RollBackSQLTransaction();
}
}
else
{
ltrErr.Text = "Please try again";
return;
}
}
catch (Exception ex)
{
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Manage_TimeGroup 288: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void saveData()
{
getLeaveList();
// btnsave.Enabled = false;
try
{
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
mid = int.Parse(ddlmonthlist.SelectedIndex.ToString());
mid = mid + 1;
yid = int.Parse(ddlyear.SelectedValue.ToString());
if (mid == 0 || yid == 0)
{
ltrErr.Text = "Select Valid Month And Year...";
return;
}
int colpos = 2;
int val = 0;
System.Collections.Hashtable hsLeavePos = new System.Collections.Hashtable();
colpos++;
hsLeavePos.Add(-4, colpos);
colpos++;
hsLeavePos.Add(-1, colpos);
colpos++;
DataRow[] ClLeave = leaveList.Select("Is_CL_Leave=0");
hsLeavePos.Add(int.Parse(ClLeave[0]["Leave_Id"].ToString()), colpos);
colpos++;
DataRow[] MlLeave = leaveList.Select("Is_CL_Leave=1");
hsLeavePos.Add(int.Parse(MlLeave[0]["Leave_Id"].ToString()), colpos);
foreach (GridViewRow row in grdEmplist.Rows)
{
Label EmpId = (Label)grdEmplist.Rows[row.RowIndex].FindControl("lblEmp_id");
Label FP_Id = (Label)grdEmplist.Rows[row.RowIndex].FindControl("lblFpId");
TextBox txtlcl = (TextBox)grdEmplist.Rows[row.RowIndex].FindControl("txtlcl");
TextBox txtlwp = (TextBox)grdEmplist.Rows[row.RowIndex].FindControl("txtlwp");
TextBox txtcl = (TextBox)grdEmplist.Rows[row.RowIndex].FindControl("txtcl");
TextBox txtml = (TextBox)grdEmplist.Rows[row.RowIndex].FindControl("txtml");
DateTime currenttime = Logger.getIndiantimeDT();
int empidint = int.Parse(EmpId.Text.ToString());
int FPIdint = int.Parse(FP_Id.Text.ToString());
double lcl = 0;
double.TryParse(txtlcl.Text.ToString(), out lcl);
double lwp = 0;
double.TryParse(txtlwp.Text.ToString(), out lwp);
double cl = 0;
double.TryParse(txtcl.Text.ToString(), out cl);
double ml = 0;
double.TryParse(txtml.Text.ToString(), out ml);
foreach (DictionaryEntry keyId in hsLeavePos)
{
int leaveid = (int)keyId.Key;
int firstindex = (int)keyId.Value;
string ColName = grdEmplist.Columns[firstindex].HeaderText.ToString();
double Total_Leave = 0;
if (ColName == "LWP")
{
//int leaveid = 1;
Total_Leave = lwp;
}
if (ColName.ToLower() == "lcl")
{
Total_Leave = lcl;
}
if (ColName.ToLower() == "cl")
{
Total_Leave = cl;
}
if (ColName.ToLower() == "ml")
{
Total_Leave = ml;
}
if (Total_Leave > 0)
{
val = objmysqldb.InsertUpdateDeleteData("update Leave_History_Monthwise set IsUpdate=1,Total_Leave=" + Total_Leave + ",modify_datetime=" + currenttime.Ticks + ",DOC=" + currenttime.Ticks + " where Emp_Id=" + empidint + " and Leave_Id=" + leaveid + " and Month_Id=" + mid + " and Month_Year=" + yid + " ");
if (val == 0)
{
val = objmysqldb.InsertUpdateDeleteData("INSERT INTO Leave_History_Monthwise(Emp_Id,Leave_Id,Total_Leave,Month_Id,Month_Year,modify_datetime,DOC,IsUpdate,Isdelete,UserID)values(" + empidint + "," + leaveid + "," + Total_Leave + "," + mid + "," + yid + "," + currenttime.Ticks + "," + currenttime.Ticks + " ,0,0," + user_id + ") ");
}
}
}
if (val == 1)
{
ltrErr.Text = "Data Updated Successfully..";
btnsave.Visible = true;
// BindEmpLeave(mid, yid);
}
//mid = int.Parse(ddlmonthlist.SelectedIndex.ToString());
//mid = mid + 1;
}
BindEmpLeave(mid, int.Parse(ddlyear.SelectedValue.ToString()), int.Parse(ddlgrouplist.SelectedIndex.ToString()));
}
catch (Exception ex)
{
Logger.WriteCriticalLog("EmpLeaveConfiguration 399: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
objmysqldb.ConnectToDatabase();
if (txtleftDate.Text.ToString().Equals(""))
{
ltrErr.Text = "Please enter left date";
return;
}
else
{
string[] arrlft = txtleftDate.Text.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
if (arrlft.Length == 3)
{
string lftdate = ((arrlft[0]).ToString().Length == 1 ? "0" + (arrlft[0]).ToString() : (arrlft[0]).ToString()) + "/" + ((arrlft[1]).ToString().Length == 1 ? "0" + (arrlft[1]).ToString() : (arrlft[1]).ToString()) + "/" + ((arrlft[2]).ToString());
txtleftDate.Text = lftdate;
}
else
{
ltrErr.Text = "Left Date is not in proper format.";
return;
}
}
int emp_id = 0;
int.TryParse(Request.QueryString["Emp"].ToString(), out emp_id);
int user_ids = 0;
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_ids);
DateTime currenttime = Logger.getIndiantimeDT();
string query = "Update employee_master set EmpStatusFlag=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_ids + " where EmpId=" + emp_id + " ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res == 1)
{
objmysqldb.AddCommandParameter("Left_Date", txtleftDate.Text.ToString());
objmysqldb.AddCommandParameter("Left_Reason", txtreason.Text.ToString());
res = objmysqldb.InsertUpdateDeleteData("insert into left_employee (Emp_Id,Left_Date,Left_Reason,UserID,modify_datetime,DOC,IsUpdate,IsDelete) values(" + emp_id + ",?Left_Date,?Left_Reason," + user_ids + " ," + currenttime.Ticks + "," + currenttime.Ticks + ",1,0) ");
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("LeftEmployee 98 Update error.");
}
else
{
ltrErr.Text = "Status Update Successfully";
txtleftDate.Text = "";
txtreason.Text = "";
}
grd.EditIndex = -1;
showgrid();
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("LeftEmployee 113:: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
objmysqldb.ConnectToDatabase();
ltrErr.Text = "";
try
{
int id = 0;
int.TryParse(ddlmanager.Items[ddlmanager.SelectedIndex].Value.ToString(), out id);
DataTable dtolddata = objmysqldb.GetData("SELECT employee_assign_to_Reporting_manager_id,emp_id FROM employee_assign_to_reporting_manager where Reporting_manager_id=" + id + " ");
string emp_id = "";
int emp_ids = 0;
objmysqldb.OpenSQlConnection();
objmysqldb.BeginSQLTransaction();
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
foreach (GridViewRow row in GridAssign.Rows)
{
Label emp = (Label)row.FindControl("lblEmp_id");
int.TryParse(emp.Text.ToString(), out emp_ids);
DateTime currentTime = Logger.getIndiantimeDT();
int retval = objmysqldb.InsertUpdateDeleteData("update employee_assign_to_reporting_manager set modify_datetime=" + currentTime.Ticks + ",IsUpdate=1,UserID=" + user_id + ",IsDelete=0 where emp_id=" + emp_ids + " and Reporting_manager_id=" + id + " ");
if (retval == 0)
{
retval = objmysqldb.InsertUpdateDeleteData("insert into employee_assign_to_reporting_manager (emp_id,Reporting_manager_id,modify_datetime,DOC,IsUpdate,UserID,IsDelete) values (" + emp_ids + "," + id + "," + currentTime.Ticks + "," + currentTime.Ticks + ",1," + user_id + ",0) ");
if (retval != 1)
{
ltrErr.Text = "please try again";
objmysqldb.RollBackSQLTransaction();
Logger.WriteCriticalLog("Employee_AssignToReportingManager 357 Update error.");
return;
}
}
else
{
emp_id += emp.Text.ToString() + ",";
}
}
emp_id = emp_id.TrimEnd(',');
if (!emp_id.Equals("") && dtolddata != null && dtolddata.Rows.Count > 0)
{
//string[] employees = emp_id.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
DataRow[] drdata = dtolddata.Select("emp_id NOT IN(" + emp_id + ") ");
dtolddata = dtolddata.Clone();
if (drdata.Length > 0)
{
dtolddata = drdata.CopyToDataTable();
}
}
DateTime currentTimes = Logger.getIndiantimeDT();
foreach (DataRow dr in dtolddata.Rows)
{
int retval = objmysqldb.InsertUpdateDeleteData("update employee_assign_to_reporting_manager set modify_datetime=" + currentTimes.Ticks + ",IsUpdate=1,UserID=" + user_id + ",IsDelete=1 where emp_id=" + int.Parse(dr["emp_id"].ToString()) + " and Reporting_manager_id=" + id + " ");
}
objmysqldb.EndSQLTransaction();
dsBindGvData(id);
ltrErr.Text = "Employee Assign to reporting manager Successfully.";
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Employee_AssignToReportingManager 391: exception:" + ex.Message + "::::::::" + ex.StackTrace);
objmysqldb.RollBackSQLTransaction();
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ltrErr.Text = "";
if (e.CommandName == "del")
{
string[] arg = e.CommandArgument.ToString().Split(':');
if (arg != null && arg.Length == 2)
{
int relid = 0;
int masterdata = 0;
int.TryParse(arg[1], out relid);
objmysqldb.ConnectToDatabase();
DataTable dtreligion = objmysqldb.GetData("Select EmpReligion from employee_master WHERE EmpReligion =" + relid + " ");
DataTable dt = objmysqldb.GetData("select * from religion_master where religion_id=" + relid + "");
if (dtreligion != null && dtreligion.Rows.Count > 0)
{
ltrErr.Text = "Employee Assign to select Category so can't delete it";
return;
}
if (dt != null && dt.Rows.Count > 0)
{
int.TryParse(dt.Rows[0]["IsMasterData"].ToString(), out masterdata);
if (masterdata == 0)
{
ltrErr.Text = "Select Religion is Masterdata,So can't delete it";
return;
}
else
{
int.TryParse(Request.Cookies["LoginCookies"]["UserId"].ToString(), out user_id);
DateTime currenttime = Logger.getIndiantimeDT();
string query = "Update religion_master set IsDelete=1,modify_datetime=" + currenttime.Ticks + ",IsUpdate=1,UserID=" + user_id + " where religion_id=" + int.Parse(arg[0]) + " ";
objmysqldb.OpenSQlConnection();
int res = objmysqldb.InsertUpdateDeleteData(query);
if (res != 1)
{
ltrErr.Text = "Please Try Again.";
Logger.WriteCriticalLog("Manage_Religion 140 Update error.");
}
else
{
grd.EditIndex = -1;
showgrid();
ltrErr.Text = "Religion Delete Successfully";
txtreligionnames.Text = "";
}
}
}
}
else
{
showgrid();
ltrErr.Text = "Please Try Again.";
}
grd.EditIndex = -1;
}
else if (e.CommandName == "Edit")
{
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("Manage_Religion 166: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
objmysqldb.ConnectToDatabase();
objmysqldb.OpenSQlConnection();
try
{
string Emp_Ids = "";
DataTable dtAllDate = objmysqldb.GetData("SELECT Dateticks,emp_id,Day_id From employee_management.employeewise_punchtime_details_datewise;");
DateTime currentTime = Logger.getIndiantimeDT();
int In_hour = 0;
int In_min = 0;
int out_hour = 0;
int out_min = 0;
int Ext_Early_hour = 0;
int Ext_Early_min = 0;
int Ext_Late_hour = 0;
int Ext_Late_min = 0;
string[] intime = txtinTime.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] outtime = txtoutTime.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] Earlytime = txtExtremeEarly.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
string[] latetime = txtExtremeLate.Text.ToString().Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
int.TryParse(intime[0], out In_hour);
int.TryParse(intime[1], out In_min);
int.TryParse(outtime[0], out out_hour);
int.TryParse(outtime[1], out out_min);
int.TryParse(Earlytime[0], out Ext_Early_hour);
int.TryParse(Earlytime[1], out Ext_Early_min);
int.TryParse(latetime[0], out Ext_Late_hour);
int.TryParse(latetime[1], out Ext_Late_min);
if (In_hour > 23 || In_min > 59 || out_hour > 23 || out_min > 59 || Ext_Early_hour > 23 || Ext_Early_min > 59 || Ext_Late_hour > 23 || Ext_Late_min > 59)
{
ltrErr.Text = "Please Enter valid time ";
return;
}
//Control ctl = this.FindControlRecursive("btnAccept");
string str = string.Empty;
foreach (GridViewRow gvrow in GrdEmpList.Rows)
{
CheckBox chk = (CheckBox)gvrow.FindControl("chkSelect");
if (chk.Checked && chk != null)
{
Label emp = (Label)gvrow.FindControl("lblemp_id");
Emp_Ids += emp.Text.ToString() + ",";
}
}
string dt = "";
foreach (GridViewRow row in GvMonth.Rows)
{
CheckBox chkdt = (CheckBox)row.FindControl("Select");
if (chkdt.Checked && chkdt != null)
{
Label date1 = (Label)row.FindControl("lblDate");
dt += date1.Text.ToString() + ",";
}
}
dt = dt.TrimEnd(',');
Emp_Ids = Emp_Ids.TrimEnd(',');
string date = lblDate1.Text.ToString();
//DateTime oDate = Convert.ToDateTime(date.ToString());
//long Tikcs = oDate.Ticks;
//DateTime dtNew = new DateTime(Tikcs);
//int day1 = (int)dtNew.DayOfWeek;
string[] arrempid = Emp_Ids.Split(',');
int dayid = 0;
long Tikcs = 0;
string[] dates = dt.Split(',');
dates = dates.Where(s => !String.IsNullOrEmpty(s)).ToArray();
//string[] dates = !String.IsNullOrEmpty(dt)).ToArray();
if (dates != null && dates.Length == 0)
{
DateTime oDate = Convert.ToDateTime(date.ToString());
Tikcs = oDate.Ticks;
//DateTime dtNew = new DateTime(Tikcs);
dayid = (int)oDate.DayOfWeek;
if (dayid == 0)
{
dayid = 7;
}
}
if (arrempid != null && arrempid.Length > 0)
{
int Yes = 0;
for (int j = 0; j < arrempid.Length; j++)
{
string EmpID = arrempid[j].ToString();
if (dates != null && dates.Length == 0)
{
//DataRow[] dr = dtAllDate.Select("emp_id=" + EmpID + " And Day_id=" + dayid + " and Dateticks in('" + Tikcs + "')");
DataRow[] dr = dtAllDate.Select("emp_id=" + EmpID + " And Day_id=" + dayid + " and Dateticks=" + Tikcs + "");
if (dayid == 0)
{
dayid = 7;
}
if (dr.Length > 0)
{
Yes = objmysqldb.InsertUpdateDeleteData("update employeewise_punchtime_details_datewise set In_hour=" + In_hour + ",In_min=" + In_min + ",out_hour=" + out_hour + ",out_min=" + out_min + " ,Ext_Early_hour=" + Ext_Early_hour + ",Ext_Early_min=" + Ext_Early_min + ",Ext_Late_hour=" + Ext_Late_hour + ",Ext_Late_min=" + Ext_Late_min + ",modify_datetime=" + MySQLDB.GetIndianTime().Ticks.ToString() + ",IsUpdate=1, UserID= " + user_id + " where emp_id=" + EmpID + " and Day_id=" + dayid);
}
else
{
Yes = objmysqldb.InsertUpdateDeleteData("insert into employeewise_punchtime_details_datewise(Dateticks,emp_id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Late_hour,Ext_Late_min,Ext_Early_min,modify_datetime,IsDelete,DOC,IsUpdate,UserID)Values(" + Tikcs + "," + EmpID + "," + dayid + "," + In_hour + "," + In_min + "," + out_hour + "," + out_min + "," + Ext_Early_hour + "," + Ext_Late_hour + "," + Ext_Late_min + "," + Ext_Early_min + "," + MySQLDB.GetIndianTime().Ticks.ToString() + ",0," + MySQLDB.GetIndianTime().Ticks.ToString() + ",1," + user_id + ")");
}
}
else
{
for (int dat = 0; dat < dates.Length; dat++)
{
string dt1 = dates[dat].ToString();
DateTime oDate = Convert.ToDateTime(dt1.ToString());
Tikcs = oDate.Ticks;
dayid = (int)oDate.DayOfWeek;
if (dayid == 0)
{
dayid = 7;
}
//DataRow[] dr = dtAllDate.Select("emp_id=" + EmpID + " And Day_id=" + dayid + " and Dateticks in('" + Tikcs + "')");
DataRow[] dr = dtAllDate.Select("emp_id=" + EmpID + " And Day_id=" + dayid + " and Dateticks=" + Tikcs + "");
if (dr.Length > 0)
{
Yes = objmysqldb.InsertUpdateDeleteData("update employeewise_punchtime_details_datewise set In_hour=" + In_hour + ",In_min=" + In_min + ",out_hour=" + out_hour + ",out_min=" + out_min + " ,Ext_Early_hour=" + Ext_Early_hour + ",Ext_Early_min=" + Ext_Early_min + ",Ext_Late_hour=" + Ext_Late_hour + ",Ext_Late_min=" + Ext_Late_min + ",modify_datetime=" + MySQLDB.GetIndianTime().Ticks.ToString() + ",IsUpdate=1, UserID= " + user_id + " where emp_id=" + EmpID + " and Day_id=" + dayid);
}
else
{
Yes = objmysqldb.InsertUpdateDeleteData("insert into employeewise_punchtime_details_datewise(Dateticks,emp_id,Day_id,In_hour,In_min,out_hour,out_min,Ext_Early_hour,Ext_Late_hour,Ext_Late_min,Ext_Early_min,modify_datetime,IsDelete,DOC,IsUpdate,UserID)Values(" + Tikcs + "," + EmpID + "," + dayid + "," + In_hour + "," + In_min + "," + out_hour + "," + out_min + "," + Ext_Early_hour + "," + Ext_Late_hour + "," + Ext_Late_min + "," + Ext_Early_min + "," + MySQLDB.GetIndianTime().Ticks.ToString() + ",0," + MySQLDB.GetIndianTime().Ticks.ToString() + ",1," + user_id + ")");
}
}
}
}
if (Yes == -1)
{
ltrErr1.Text = "Error While Saving..";
}
else
{
ltrErr1.Text = "Time Configuration Saved...";
}
}
else
{
ltrErr1.Text = "Select Atleast One Employee...";
}
}
catch (Exception ex)
{
Logger.WriteCriticalLog("TimeConfigForEmp BenSaveClick(): exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
finally
{
objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}