void GetReport() { DataTable dt = new DataTable(); dt.Columns.Add("Company_Name"); dt.Columns.Add("Image"); dt.Columns.Add("Month"); dt.Columns.Add("Year"); dt.Columns.Add("Emp_Id"); dt.Columns.Add("Emp_Name"); dt.Columns.Add("Claim_Name"); dt.Columns.Add("Claim_Amount"); dt.Columns.Add("Sum_Claim"); string Id = (string)Session["Querystring"]; int ClaimType = (int)Session["ClaimType"]; double SumClaim = 0; foreach (string str in Id.Split(',')) { if (str != "") { DataTable dtClaimRecod = (DataTable)Session["ClaimRecord"]; dtClaimRecod = new DataView(dtClaimRecod, "Emp_Id=" + str + "", "", DataViewRowState.CurrentRows).ToTable(); if (dtClaimRecod.Rows.Count > 0) { DataTable dtsalary = ObjSalary.GetEmployeeParameterByEmpId(str, Session["CompId"].ToString()); string[] Montharr = new string[12]; Montharr[0] = "January"; Montharr[1] = "February"; Montharr[2] = "March"; Montharr[3] = "April"; Montharr[4] = "May"; Montharr[5] = "June"; Montharr[6] = "July"; Montharr[7] = "August"; Montharr[8] = "September"; Montharr[9] = "October"; Montharr[10] = "November"; Montharr[11] = "December"; for (int i = 0; i < dtClaimRecod.Rows.Count; i++) { string salary = string.Empty; if (dtsalary.Rows.Count > 0) { salary = dtsalary.Rows[0]["Basic_Salary"].ToString(); } string Claimamount = string.Empty; if (dtClaimRecod.Rows[i]["Value_Type"].ToString() == "2") { string value = dtClaimRecod.Rows[i]["Value"].ToString(); Claimamount = (float.Parse(salary) * float.Parse(value) / 100).ToString("0.000"); } else { Claimamount = Convert.ToDouble(dtClaimRecod.Rows[i]["Value"]).ToString("0.000"); } int Month = Convert.ToInt32(dtClaimRecod.Rows[i]["Claim_Month"]); DataRow dr = dt.NewRow(); dr[0] = ""; dr[1] = ""; dr[2] = Montharr[Month - 1].ToString(); dr[3] = dtClaimRecod.Rows[i]["Claim_Year"].ToString(); dr[4] = dtClaimRecod.Rows[i]["Emp_Id"].ToString(); dr[5] = dtClaimRecod.Rows[i]["Emp_Name"].ToString(); dr[6] = dtClaimRecod.Rows[i]["Claim_Name"].ToString(); dr[7] = Claimamount; SumClaim += double.Parse(Claimamount); dr[8] = SumClaim.ToString("0.000"); //dr[7] = System.Math.Round(Claimamount, 3); dt.Rows.Add(dr); } } } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = Objcompany.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = Objaddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } Objreport.SetImage(Imageurl); Objreport.SetCompanyName(CompanyName); Objreport.SetAddress(CompanyAddress); Objreport.setSumClaimAmount(SumClaim); if (ClaimType == 1) { Objreport.setTitleName("Claim Approved Report"); } if (ClaimType == 2) { Objreport.setTitleName("Claim Cancelled Report"); } if (ClaimType == 3) { Objreport.setTitleName("Claim Pending Report"); } Objreport.DataSource = dt; Objreport.DataMember = "EmployeeClaim"; ReportViewer1.Report = Objreport; ReportToolbar1.ReportViewer = ReportViewer1; }
protected void btnApply_Click(object sender, EventArgs e) { int b = 0; if (rbtnOfficial.Checked == false && rbtnPersonal.Checked == false) { DisplayMessage("Please select Personal or Official"); return; } if (txtEmpName.Text == "") { DisplayMessage("Enter Employee Name"); txtEmpName.Focus(); return; } if (txtApplyDate.Text == "") { DisplayMessage("Enter Apply Date"); txtApplyDate.Focus(); return; } else { try { objSys.getDateForInput(txtApplyDate.Text); } catch { DisplayMessage("Enter Correct Apply Date Format dd-MMM-yyyy"); txtApplyDate.Focus(); return; } } if (txtInTime.Text == "") { DisplayMessage("Enter In Time"); txtInTime.Focus(); return; } if (txtOuttime.Text == "") { DisplayMessage("Enter Out Time"); txtOuttime.Focus(); return; } if (txtDescription.Text == "") { DisplayMessage("Enter Description"); txtDescription.Focus(); return; } if (rbtnPersonal.Checked) { bool IsCompPartial = Convert.ToBoolean(objAppParam.GetApplicationParameterValueByParamName("Partial_Leave_Enable", Session["CompId"].ToString())); if (IsCompPartial) { DataTable dtEmpParam = objEmpParam.GetEmployeeParameterByEmpId(hdnEmpId.Value, Session["CompId"].ToString()); if (dtEmpParam.Rows.Count > 0) { bool IsEmpPartial = Convert.ToBoolean(dtEmpParam.Rows[0]["Is_Partial_Enable"].ToString()); if (IsEmpPartial) { int totalminutes = 0; int useinday = 0; double leaveCount = 0; totalminutes = int.Parse(dtEmpParam.Rows[0]["Partial_Leave_Mins"].ToString()); useinday = int.Parse(dtEmpParam.Rows[0]["Partial_Leave_Day"].ToString()); leaveCount = double.Parse(dtEmpParam.Rows[0]["Partial_Leave_Mins"].ToString()) / double.Parse(dtEmpParam.Rows[0]["Partial_Leave_Day"].ToString()); leaveCount = System.Math.Round(leaveCount); leaveCount = leaveCount - getCurrentMonthLeaveCount(objSys.getDateForInput(txtApplyDate.Text)); if (leaveCount > 0) { if (totalminutes > 0) { int CurrentUseMin = getCurrentMonth(objSys.getDateForInput(txtApplyDate.Text)); if (CurrentUseMin > 0) { totalminutes = totalminutes - CurrentUseMin; } int OneDayMin = getMinuteInADay(objSys.getDateForInput(txtApplyDate.Text)); if (OneDayMin >= useinday) { DisplayMessage("You cannot request more than " + useinday.ToString() + " minutes in a day"); return; } int RequestMin = GetMinuteDiff(txtOuttime.Text, txtInTime.Text); if (RequestMin <= totalminutes) { if (RequestMin > useinday) { DisplayMessage("You cannot request more than " + useinday.ToString() + " minutes in a day"); return; } else { int remainmin = totalminutes - RequestMin; if (hdnEdit.Value == "") { b = objPartial.InsertPartialLeaveRequest(Session["CompId"].ToString(), hdnEmpId.Value, "0", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave submitted"); btnReset_Click(null, null); FillLeaveStatus(); } } else { b = objPartial.UpdatePartialLeaveRequest(hdnEdit.Value, Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave updated"); btnCancel_Click(null, null); FillLeaveStatus(); hdnEdit.Value = ""; btnNew.Text = Resources.Attendance.New; txtEmpName.Enabled = true; } } } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Partial leave cannot assign to this employee"); return; } } else { DisplayMessage("Partial leave cannot assign to this employee"); return; } } else { DisplayMessage("Company does not provide partial leave"); return; } } else { bool IsCompPartial = Convert.ToBoolean(objAppParam.GetApplicationParameterValueByParamName("Partial_Leave_Enable", Session["CompId"].ToString())); if (IsCompPartial) { if (hdnEdit.Value == "") { b = objPartial.InsertPartialLeaveRequest(Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave submitted"); btnReset_Click(null, null); FillLeaveStatus(); } } else { b = objPartial.UpdatePartialLeaveRequest(hdnEdit.Value, Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave updated"); btnCancel_Click(null, null); FillLeaveStatus(); hdnEdit.Value = ""; btnNew.Text = Resources.Attendance.New; txtEmpName.Enabled = true; } } } else { DisplayMessage("Company does not provide partial leave"); return; } } }
void GetReport() { DataTable dt = new DataTable(); dt.Columns.Add("EmpId"); dt.Columns.Add("EmpName"); dt.Columns.Add("Penalty_Name"); dt.Columns.Add("Penalty_Value"); dt.Columns.Add("Penalty_Date"); dt.Columns.Add("Month"); dt.Columns.Add("Year"); string Id = (string)Session["Querystring"]; //int ClaimType = (int)Session["ClaimType"]; double Penaltysum = 0; foreach (string str in Id.Split(',')) { if (str != "") { DataTable dtClaimRecod = (DataTable)Session["ClaimRecord"]; dtClaimRecod = new DataView(dtClaimRecod, "Emp_Id=" + str + "", "", DataViewRowState.CurrentRows).ToTable(); if (dtClaimRecod.Rows.Count > 0) { DataTable dtsalary = ObjSalary.GetEmployeeParameterByEmpId(str, Session["CompId"].ToString()); string[] Montharr = new string[12]; Montharr[0] = "January"; Montharr[1] = "February"; Montharr[2] = "March"; Montharr[3] = "April"; Montharr[4] = "May"; Montharr[5] = "June"; Montharr[6] = "July"; Montharr[7] = "August"; Montharr[8] = "September"; Montharr[9] = "October"; Montharr[10] = "November"; Montharr[11] = "December"; double salary = 0; for (int i = 0; i < dtClaimRecod.Rows.Count; i++) { if (dtsalary.Rows.Count > 0) { salary = Convert.ToDouble(dtsalary.Rows[0]["Basic_Salary"]); } double Claimamount = 0; if (dtClaimRecod.Rows[i]["Value_Type"].ToString() == "2") { int value = Convert.ToInt32(dtClaimRecod.Rows[i]["Value"]); Claimamount = salary * value / 100; } else { Claimamount = Convert.ToDouble(dtClaimRecod.Rows[i]["Value"].ToString()); } int Month = Convert.ToInt32(dtClaimRecod.Rows[i]["Penalty_Month"]); DataRow dr = dt.NewRow(); dr[0] = dtClaimRecod.Rows[i]["Emp_Id"].ToString(); dr[1] = dtClaimRecod.Rows[i]["Emp_Name"].ToString(); dr[2] = dtClaimRecod.Rows[i]["Penalty_Name"].ToString(); dr[3] = Claimamount.ToString("0.000"); dr[4] = dtClaimRecod.Rows[i]["Penalty_Date"].ToString(); dr[5] = Montharr[Month - 1].ToString(); dr[6] = dtClaimRecod.Rows[i]["Penalty_Year"].ToString(); Penaltysum += Claimamount; dt.Rows.Add(dr); } } } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = Objcompany.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = Objaddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } objReport.SetImage(Imageurl); objReport.setTitleName("Employee Penalty Report"); objReport.SetCompanyName(CompanyName); objReport.SetAddress(CompanyAddress); objReport.setSum(Penaltysum); objReport.DataSource = dt; objReport.DataMember = "EmpPenalty"; ReportViewer1.Report = objReport; ReportToolbar1.ReportViewer = ReportViewer1; }