protected void showgrid() { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; DataTable dtschList = objmysqldb.GetData("Select School_List_ID,School_Name,School_Id from school_list where IsDelete=0 order by School_List_ID"); objmysqldb.disposeConnectionObj(); if (dtschList != null) { string schid = ""; for (int i = 0; i < dtschList.Rows.Count; i++) { schid += dtschList.Rows[i]["School_Id"].ToString() + " - " + dtschList.Rows[i]["School_Name"].ToString() + ","; } Application["schId"] = schid.TrimEnd(','); grd.DataSource = dtschList; grd.DataBind(); btnExport.Visible = true; } else { ltrErr.Text = "No Data Found."; btnExport.Visible = false; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("Manage_Organization 84: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
protected void showgrid() { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; DataTable dtcasteList = objmysqldb.GetData("select caste_id,caste_name,IsMasterData from caste_master WHERE IsDelete=0 order by caste_id"); objmysqldb.disposeConnectionObj(); if (dtcasteList != null) { grd.DataSource = dtcasteList; grd.DataBind(); btnExport.Visible = true; } else { ltrErr.Text = "No Data Found."; btnExport.Visible = false; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("Manage_Caste 79: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
private void getBinddata() { objmysqldb.ConnectToDatabase(); try { DataTable dttimegrpDetails = objmysqldb.GetData("SELECT Group_id,Group_Name,Absent_SMS_After,OutPuch_SMS_After,Changes_Applicable_Date,DATE_FORMAT(DATE_ADD('0001-01-01 00:00:00',INTERVAL Changes_Applicable_Date/10000000 SECOND_MICROSECOND), '%d/%m/%Y')as date FROM group_master where IsDelete=0"); if (dttimegrpDetails != null) { grd.DataSource = dttimegrpDetails; grd.DataBind(); btnExport.Visible = true; } else { ltrErr.Text = "No Data Found."; btnExport.Visible = false; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("Time_Group_List 79: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
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); }
private void bindEmpGroup() { objmysqldb.ConnectToDatabase(); try { DataTable dtgrplist = objmysqldb.GetData("SELECT * FROM employee_management.report_group_list"); //dtgrplist.Columns.Add("----Select Group-----"); ddlgrouplist.DataSource = dtgrplist; ddlgrouplist.DataTextField = "report_grp_name"; ddlgrouplist.DataValueField = "report_grp_id"; ddlgrouplist.DataBind(); ddlgrouplist.Items.Insert(0, new ListItem("Select All Employee", "-1")); ddlmonthlist.Enabled = true; ddlyear.Enabled = true; // btnsave.Visible = true; } catch (Exception ex) { Logger.WriteCriticalLog("EmpLeaveConfiguration 94: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void showgrid() { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; DataTable dtempprofile = objmysqldb.GetData("Select * from employee_query_profile where IsDelete=0 order by Profile_Id"); if (dtempprofile != null && dtempprofile.Rows.Count > 0) { grd.DataSource = dtempprofile; grd.DataBind(); } else { ltrErr.Text = "No Data Found."; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("addeditprofile 78: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void getprofiledata() { DataTable dtprofile = new DataTable(); try { objmysqldb.ConnectToDatabase(); int profileid = 0; int.TryParse(profile_idHidden.Value.ToString(), out profileid); dtprofile = objmysqldb.GetData("select * from employee_query_profile where Profile_Id=" + profileid + " and IsDelete=0;"); if (dtprofile != null && dtprofile.Rows.Count > 0) { txtprofile.Text = dtprofile.Rows[0]["Profile_Name"].ToString(); txtquery.Text = dtprofile.Rows[0]["Profile_Text"].ToString(); } } catch (Exception ex) { Logger.WriteCriticalLog("addnewqueryprofile 97: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void showgrid() { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; DataTable dtreligion = objmysqldb.GetData("Select religion_id,religion_name,IsMasterData from religion_master where IsDelete=0 order by religion_id"); objmysqldb.disposeConnectionObj(); if (dtreligion != null) { grd.DataSource = dtreligion; grd.DataBind(); btnExport.Visible = true; } else { ltrErr.Text = "No Data Found."; btnExport.Visible = false; grd.DataSource = null; } //UpdatePanel1.Update(); } catch (Exception ex) { Logger.WriteCriticalLog("Manage_Religion 79: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
protected void bindgvdata(int grpid, int flg) { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; Button1.Visible = false; Button2.Visible = false; DataTable dtbindGrp = new DataTable(); if (flg == 1) { dtbindGrp = 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,if(1=1,0,1)as selects from employee_master where employee_master.IsDelete=0 order by empid"); } else { dtbindGrp = 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,if(1=1,0,1)as selects from employee_master where employee_master.IsDelete=0 and EmpStatusFlag=0 order by empid"); } if (dtbindGrp != null && dtbindGrp.Rows.Count > 0) { DataTable dtselectEmp = objmysqldb.GetData("SELECT emp_ids,report_grp_name,Is_Default FROM report_group_list where IsDelete=0 and report_grp_id=" + grpid + " "); if (dtselectEmp != null && dtselectEmp.Rows.Count > 0) { //for (int i = 0; i < dtselectEmp.Rows.Count; i++) //{ txtgroup.Text = dtselectEmp.Rows[0]["report_grp_name"].ToString(); chkIsDefault.Checked = false; if (dtselectEmp.Rows[0]["Is_Default"].ToString().Equals("1")) { chkIsDefault.Checked = true; } DataRow[] drselect = dtbindGrp.Select("empid IN(" + dtselectEmp.Rows[0]["emp_ids"].ToString() + ")"); foreach (DataRow dr in drselect) { dr["selects"] = "1"; } //} } GridView1.DataSource = dtbindGrp; GridView1.DataBind(); Button1.Visible = true; Button2.Visible = true; } else { GridView1.DataSource = null; GridView1.DataBind(); ltrErr.Text = "Receord does not exsits for selected criteria"; } } catch (Exception ex) { Logger.WriteCriticalLog("ManageEmployeeGroupReports 123: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
public void fillWithData() { objmysqldb.ConnectToDatabase(); // BindAcademicYear(); try { DataTable dtData = objmysqldb.GetData("SELECT year_id,Academic_Year,Start_Date as startdate,End_Date as enddate FROM academicyear where IsDelete=0;"); if (dtData.Rows.Count > 0 && dtData != null) { dtData.Columns.Add("Start_Date"); dtData.Columns.Add("End_Date"); int c = dtData.Rows.Count; for (int i = 0; i < dtData.Rows.Count; i++) { //string startDate = dtData.Rows[i]["startdate"].ToString(); long startdate = long.Parse(dtData.Rows[i]["startdate"].ToString()); DateTime startdt = new DateTime(startdate); //String myString_new = startdt.ToString().Replace("00:00:00", ""); //String myString_new = String.Format("{0:MM/dd/yyyy}", startdt); String myString_new = String.Format("{0:dd/MM/yyyy}", startdt); dtData.Rows[i]["Start_Date"] = myString_new; long enddate = long.Parse(dtData.Rows[i]["enddate"].ToString()); DateTime enddt = new DateTime(enddate); //String myString_new1 = enddt.ToString().Replace("00:00:00", ""); String myString_new1 = String.Format("{0:dd/MM/yyyy}", enddt); dtData.Rows[i]["End_Date"] = myString_new1; } // dtYear.AcceptChanges(); //dlYear.DataSource = dtYear; //dlYear.DataBind(); //dlYear.Items.Insert(0, new ListItem("Select Year", "-2")); grdyearlist.AutoGenerateColumns = false; grdyearlist.DataSource = dtData; grdyearlist.DataBind(); } else { //BindAcademicYear(); grdyearlist.AutoGenerateColumns = false; grdyearlist.DataSource = dtData.Clone(); grdyearlist.DataBind(); } } catch (Exception ex) { Logger.WriteCriticalLog("Academic Year Set Up 141: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
private void bindgvdata() { objmysqldb.ConnectToDatabase(); try { btnExport.Visible = false; DataTable dtdata = objmysqldb.GetData("SELECT report_grp_id,report_grp_name,emp_ids FROM report_group_list where IsDelete=0"); DataTable dtempdata = objmysqldb.GetData("SELECT EmpId,EmpFirstName FROM employee_master where IsDelete=0 and EmpStatusFlag=0"); if (dtdata != null && dtdata.Rows.Count > 0 && dtempdata != null && dtempdata.Rows.Count > 0) { dtdata.Columns.Add("emp_name"); for (int i = 0; i < dtdata.Rows.Count; i++) { string empids = dtdata.Rows[i]["emp_ids"].ToString(); if (!empids.Trim().Equals("")) { DataRow[] drdata = dtempdata.Select("EmpId IN (" + empids + ")"); string emp_name = ""; foreach (DataRow dr in drdata) { emp_name += dr["EmpFirstName"].ToString() + ","; } emp_name = emp_name.TrimEnd(','); dtdata.Rows[i]["emp_name"] = emp_name; } } ViewState["gvdata"] = dtdata; grd.DataSource = dtdata; grd.DataBind(); btnExport.Visible = true; } else { grd.DataSource = null; grd.DataBind(); } } catch (Exception ex) { Logger.WriteCriticalLog("EmployeeGroupForReports 99: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
public void BindData(string emp_id) { objmysqldb.ConnectToDatabase(); try { DataTable EmpDetail = objmysqldb.GetData("select empid as emp_id,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"); string dt = lblDate1.Text.ToString(); DateTime oDate = Convert.ToDateTime(dt.ToString()); long Tikcs = oDate.Ticks; DataTable dtEmpAttendance = objmysqldb.GetData("SELECT distinct Dateticks,emp_id,Day_id,concat(In_hour,':',In_min)as InMin,concat(out_hour,':',out_min)As outHour,concat(Ext_Early_hour,':',Ext_Early_min)as ExtEarlyHour,concat(Ext_Late_hour,':',Ext_Late_min)as ExtLateHour FROM employee_management.employeewise_punchtime_details_datewise where Dateticks <" + Tikcs + " and emp_id=" + emp_id + ""); if (dtEmpAttendance != null && dtEmpAttendance.Rows.Count > 0) { string InTime = ""; string outTime = ""; string ExtEarly = ""; string ExtLate = ""; foreach (DataRow drEmp in dtEmpAttendance.Rows) { InTime = drEmp["InMin"].ToString(); outTime = drEmp["outHour"].ToString(); ExtEarly = drEmp["ExtEarlyHour"].ToString(); ExtLate = drEmp["ExtLateHour"].ToString(); } txtinTime.Text = InTime; txtoutTime.Text = outTime; txtExtremeEarly.Text = ExtEarly; txtExtremeLate.Text = ExtLate; } if (EmpDetail != null && EmpDetail.Rows.Count > 0) { GrdEmpList.DataSource = EmpDetail; GrdEmpList.DataBind(); } } catch (Exception ex) { } finally { //objmysqldb.CloseSQlConnection(); objmysqldb.disposeConnectionObj(); } }
protected void BindSearchCriteria() { objmysqldb.ConnectToDatabase(); try { DataTable dtschList = objmysqldb.GetData("Select School_List_ID,School_Name,School_Id from school_list where IsDelete=0 order by School_List_ID"); ddlschool.DataSource = dtschList; ddlschool.DataTextField = "School_Name"; ddlschool.DataValueField = "School_List_ID"; ddlschool.DataBind(); ddlschool.Items.Insert(0, new ListItem("Select Organization", "-1")); DataTable dtdepartment = objmysqldb.GetData("Select department_id,Department_Name from department_master where IsDelete=0 order by department_id"); ddldepartment.DataSource = dtdepartment; ddldepartment.DataTextField = "Department_Name"; ddldepartment.DataValueField = "department_id"; ddldepartment.DataBind(); ddldepartment.Items.Insert(0, new ListItem("Select Department", "1000")); DataTable dtdesignation = objmysqldb.GetData("Select designation_id,Designation_Name from designation_master where IsDelete=0 order by designation_id"); ddlDesignation.DataSource = dtdesignation; ddlDesignation.DataTextField = "Designation_Name"; ddlDesignation.DataValueField = "designation_id"; ddlDesignation.DataBind(); ddlDesignation.Items.Insert(0, new ListItem("Select Designation", "1000")); DataTable dttimegrp = objmysqldb.GetData("Select Group_id,Group_Name from group_master where IsDelete=0 order by Group_id"); ddltimegrp.DataSource = dttimegrp; ddltimegrp.DataTextField = "Group_Name"; ddltimegrp.DataValueField = "Group_id"; ddltimegrp.DataBind(); ddltimegrp.Items.Insert(0, new ListItem("Select Time Group", "1000")); objmysqldb.disposeConnectionObj(); } catch (Exception ex) { Logger.WriteCriticalLog("Employee_AssignToTimeGroup 101: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
protected void holidayProfile() { objmysqldb.ConnectToDatabase(); try { DataTable dtbindholiday = objmysqldb.GetData("SELECT * FROM holiday_profile_master;"); ddlholidaylist.DataSource = dtbindholiday; ddlholidaylist.DataTextField = "Holiday_Profile_Name"; ddlholidaylist.DataValueField = "Holiday_Profile_Id"; ddlholidaylist.DataBind(); ddlholidaylist.Items.Insert(0, new ListItem("Select Holiday Profile", "0")); } catch (Exception ex) { Logger.WriteCriticalLog("EmployeeAssignHolidayProfile 74: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void bindGrplist() { objmysqldb.ConnectToDatabase(); try { DataTable dtbindGrp = objmysqldb.GetData("select module_group_id,module_group_name from employee_app_module_group where IsDelete=0"); ddlgrouplist.DataSource = dtbindGrp; ddlgrouplist.DataTextField = "module_group_name"; ddlgrouplist.DataValueField = "module_group_id"; ddlgrouplist.DataBind(); ddlgrouplist.Items.Insert(0, new ListItem("Select Module Group", "0")); } catch (Exception ex) { Logger.WriteCriticalLog("ModuleGrp_AssignTo_Employee 74: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
private void bindEmpGroup() { objmysqldb.ConnectToDatabase(); try { DataTable dtgrplist = objmysqldb.GetData("SELECT * FROM employee_management.report_group_list"); DataTable EmpList = new DataTable(); ddlgrouplist.DataSource = dtgrplist; ddlgrouplist.DataTextField = "report_grp_name"; ddlgrouplist.DataValueField = "report_grp_id"; ddlgrouplist.DataBind(); ddlgrouplist.Items.Insert(0, new ListItem("Select All Emp", "0")); } catch (Exception ex) { Logger.WriteCriticalLog("SalaryConfiguration 77: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void getbindReportingManager() { objmysqldb.ConnectToDatabase(); try { DataTable dtReportingMg = objmysqldb.GetData("select Reporting_manager_id,Emp_id,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 reporting_manager_master inner join employee_master on reporting_manager_master.Emp_id =employee_master.empid where reporting_manager_master.IsDelete=0 and employee_master.IsDelete=0 and EmpStatusFlag=0"); ddlmanager.DataSource = dtReportingMg; ddlmanager.DataTextField = "FullName"; ddlmanager.DataValueField = "Reporting_manager_id"; ddlmanager.DataBind(); ddlmanager.Items.Insert(0, new ListItem("Select Reporting Manager", "0")); } catch (Exception ex) { Logger.WriteCriticalLog("Employee_AssignToReportingManager 74: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
private void BindEmployeeList() { objmysqldb.ConnectToDatabase(); try { DataTable dtemplist = 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 EmpStatusFlag=0 and employee_master.IsDelete=0"); ddlemplist.DataSource = dtemplist; ddlemplist.DataTextField = "FullName"; ddlemplist.DataValueField = "EmpId"; ddlemplist.DataBind(); ddlemplist.Items.Insert(0, new ListItem("Select Reporting Manager", "-1")); } catch (Exception ex) { Logger.WriteCriticalLog("Employee_Attendance_Override 74: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
private void BindImg(int repgrp) { objmysqldb.ConnectToDatabase(); try { DataTable dtdata = objmysqldb.GetData("SELECT A4L_Img,LegelP_Img,LegelL_Img FROM report_group_list where report_grp_id=" + repgrp + " "); string test = "http://" + HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port; IMgA4L.ImageUrl = test + "//HeaderImages.jpg"; imglegelP.ImageUrl = test + "//HeaderImages.jpg"; ImgLegelL.ImageUrl = test + "//HeaderImages.jpg"; string uploadFolderPath = "~/HeaderImages/"; if (dtdata != null && dtdata.Rows.Count > 0) { if (!dtdata.Rows[0]["A4L_Img"].ToString().Equals(""))//A4 { string pathSign = HttpContext.Current.Server.MapPath(uploadFolderPath) + "\\" + dtdata.Rows[0]["A4L_Img"].ToString(); if (File.Exists(pathSign)) { test = "http://" + HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port + "//HeaderImages"; IMgA4L.ImageUrl = test + "//" + dtdata.Rows[0]["A4L_Img"].ToString(); } } if (!dtdata.Rows[0]["LegelP_Img"].ToString().Equals("")) //Legel port { string pathSign = HttpContext.Current.Server.MapPath(uploadFolderPath) + "\\" + dtdata.Rows[0]["LegelP_Img"].ToString(); if (File.Exists(pathSign)) { test = "http://" + HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port + "//HeaderImages"; imglegelP.ImageUrl = test + "//" + dtdata.Rows[0]["LegelP_Img"].ToString(); } } if (!dtdata.Rows[0]["LegelL_Img"].ToString().Equals("")) //Legel Lan { string pathSign = HttpContext.Current.Server.MapPath(uploadFolderPath) + "\\" + dtdata.Rows[0]["LegelL_Img"].ToString(); if (File.Exists(pathSign)) { test = "http://" + HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port + "//HeaderImages"; ImgLegelL.ImageUrl = test + "//" + dtdata.Rows[0]["LegelL_Img"].ToString(); } } } } catch (Exception ex) { Logger.WriteCriticalLog("ManageEmployeeGroupReportsHeaderImage 111: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { objmysqldb.disposeConnectionObj(); } }
protected void showgrid() { objmysqldb.ConnectToDatabase(); try { DataTable dtfieldlist = objmysqldb.GetData("Select Employee_Field_id,FieldName,FieldDisplayName,Is_Show,SortNumber from employee_search_field_config order by Employee_Field_id"); objmysqldb.disposeConnectionObj(); if (dtfieldlist != null) { grd.DataSource = dtfieldlist; grd.DataBind(); } else { ltrErr.Text = "No Data Found."; //btnExport.Visible = false; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("DisplayColumnConfigurationForSearchEmployee 80: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
private void bindholidayprofile() { objmysqldb.ConnectToDatabase(); try { DataTable dtHolidayProfile = objmysqldb.GetData("SELECT Holiday_Profile_Id,Holiday_Profile_Name FROM holiday_profile_master "); ddlholiday.DataSource = dtHolidayProfile; ddlholiday.DataTextField = "Holiday_Profile_Name"; ddlholiday.DataValueField = "Holiday_Profile_Id"; ddlholiday.DataBind(); ddlholiday.Items.Insert(0, new ListItem("Select Holiday Profile", "-1")); } catch (Exception ex) { Logger.WriteCriticalLog("Holiday_Setup 83: exception:" + ex.Message + "::::::::" + ex.StackTrace); } finally { 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 Search() { objmysqldb.ConnectToDatabase(); try { ltrErr.Text = ""; DataTable dtmodule = objmysqldb.GetData("Select module_id,module_name from employee_module_master where IsDelete=0"); DataTable dtcategory = objmysqldb.GetData("Select module_group_id,module_group_name,module_ids from employee_app_module_group where IsDelete=0"); objmysqldb.disposeConnectionObj(); dtcategory.Columns.Add("module_name"); for (int i = 0; i < dtcategory.Rows.Count; i++) { string module_name = " "; string abc = dtcategory.Rows[i]["module_ids"].ToString(); string[] ar = abc.Split(','); for (int a = 0; a < ar.Length; a++) { DataRow[] dr1 = dtmodule.Select("module_id ='" + ar[a].Trim() + "'"); if (dr1.Length > 0) { foreach (DataRow dr in dr1) { module_name += dr["module_name"].ToString() + ","; } dtcategory.Rows[i]["module_name"] = module_name.TrimEnd(','); } } } if (dtcategory != null) { grd.DataSource = dtcategory; grd.DataBind(); btnExport.Visible = true; } else { ltrErr.Text = "No Data Found."; btnExport.Visible = false; grd.DataSource = null; } } catch (Exception ex) { Logger.WriteCriticalLog("employee_module_group 102: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
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 BindSearchCriteria() { objmysqldb.ConnectToDatabase(); try { DataTable dtprofile = objmysqldb.GetData("Select Profile_Id,Profile_Name,Profile_Text from employee_query_profile where IsDelete=0 order by Profile_Id"); ddlprofile.DataSource = dtprofile; ddlprofile.DataTextField = "Profile_Name"; ddlprofile.DataValueField = "Profile_Id"; ddlprofile.DataBind(); ddlprofile.Items.Insert(0, new ListItem("Select Profile", "-1")); DataTable dtyear = new DataTable(); //dtyear.Columns.Add("Year_id", typeof(int)); dtyear.Columns.Add("Year", typeof(int)); DataTable dtdoj = objmysqldb.GetData("select distinct EmpDOJ from employee_master where EmpDOJ !=null or EmpDOJ!='';"); dtdoj.Columns.Add("year"); for (int i = 0; i < dtdoj.Rows.Count; i++) { string doj = dtdoj.Rows[i]["EmpDOJ"].ToString(); if (doj != null && doj != "") { string[] doj1 = doj.Split('/'); dtdoj.Rows[i]["year"] = doj1[2].ToString(); } } dtyear = dtdoj.DefaultView.ToTable(true, "year"); DataView dv = dtyear.DefaultView; dv.Sort = "year"; ddlyear.DataSource = dtyear; ddlyear.DataTextField = "Year"; ddlyear.DataBind(); ddlyear.Items.Insert(0, new ListItem("Select Year", "-1")); DataTable dtschList = objmysqldb.GetData("Select School_List_ID,School_Name,School_Id from school_list where IsDelete=0 order by School_List_ID"); ddlschList.DataSource = dtschList; ddlschList.DataTextField = "School_Name"; ddlschList.DataValueField = "School_List_ID"; ddlschList.DataBind(); ddlschList.Items.Insert(0, new ListItem("Select Organization", "-1")); DataTable dtdepartment = objmysqldb.GetData("Select department_id,Department_Name from department_master where IsDelete=0 order by department_id"); ddldepart.DataSource = dtdepartment; ddldepart.DataTextField = "Department_Name"; ddldepart.DataValueField = "department_id"; ddldepart.DataBind(); ddldepart.Items.Insert(0, new ListItem("Select Department", "1000")); DataTable dtdesignation = objmysqldb.GetData("Select designation_id,Designation_Name from designation_master where IsDelete=0 order by designation_id"); ddldesig.DataSource = dtdesignation; ddldesig.DataTextField = "Designation_Name"; ddldesig.DataValueField = "designation_id"; ddldesig.DataBind(); ddldesig.Items.Insert(0, new ListItem("Select Designation", "1000")); objmysqldb.disposeConnectionObj(); DataTable dtstatus = new DataTable(); dtstatus.Columns.Add("Status_id"); dtstatus.Columns.Add("Status"); ddlStatus.DataSource = dtstatus; ddlStatus.DataTextField = "Status"; ddlStatus.DataValueField = "Status_id"; ddlStatus.DataBind(); ddlStatus.Items.Insert(0, new ListItem("Select Status", "-1")); ddlStatus.Items.Insert(1, new ListItem("Working", "0")); ddlStatus.Items.Insert(2, new ListItem("Left", "1")); DataTable dtcolList = new DataTable(); dtcolList.Columns.Add("col_id"); dtcolList.Columns.Add("col_name"); ddlColumnList.DataSource = dtcolList; ddlColumnList.DataTextField = "col_id"; ddlColumnList.DataValueField = "col_name"; ddlColumnList.DataBind(); ddlColumnList.Items.Insert(0, new ListItem("Select Filter", "0")); ddlColumnList.Items.Insert(1, new ListItem("Employee Name", "1")); ddlColumnList.Items.Insert(2, new ListItem("Employee DOJ", "2")); ddlColumnList.Items.Insert(3, new ListItem("Employee DOB", "3")); ddlColumnList.Items.Insert(4, new ListItem("Employee Gender", "5")); ddlColumnList.Items.Insert(5, new ListItem("Employee Phone", "6")); DataTable dtAssignStatus = new DataTable(); dtAssignStatus.Columns.Add("Status_id"); dtAssignStatus.Columns.Add("Status"); ddlstatusAssign.DataSource = dtAssignStatus; ddlstatusAssign.DataTextField = "Status"; ddlstatusAssign.DataValueField = "Status_id"; ddlstatusAssign.DataBind(); ddlstatusAssign.Items.Insert(0, new ListItem("All Employee", "-1")); ddlstatusAssign.Items.Insert(1, new ListItem("Assign Employee", "0")); ddlstatusAssign.Items.Insert(2, new ListItem("Un Assign Employee", "1")); } catch (Exception ex) { Logger.WriteCriticalLog("Search_Employee 165: exception:" + ex.Message + "::::::::" + ex.StackTrace); } }
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 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(); } }
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(); } }