public string UpdateDCRLockToReleaseMob(string user_Code, string lock_Type, string locked_Date, string dcr_Actual_Date) { try { string company_Code = objCurr.GetCompanyCode(); DataControl.BLApproval _objBlApproval = new DataControl.BLApproval(); _objBlApproval = new BLApproval(); MVCModels.DCRActivityLockModel dcrLock = new MVCModels.DCRActivityLockModel(); dcrLock.Lock_Type = lock_Type; dcrLock.Locked_Date = locked_Date; dcrLock.DCR_Actual_Date = dcr_Actual_Date; dcrLock.User_Code = user_Code; dcrLock.Released_By = objCurr.GetUserCode(); return(_objBlApproval.UpdateDCRLockToRelease(company_Code, dcrLock)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Tree Selected user:"******"Lock Type:", lock_Type); //Filter indicates UI level filters dicContext.Add("Locked Date:", locked_Date); //Filter indicates UI level filters dicContext.Add("DCR Actual Date:", dcr_Actual_Date); //Filter indicates UI level filters DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message); } }
public string GetSFCInCPTPDCRPopup(string region_Code, string sfcCodes) { BLApproval objBlApproval = new BLApproval(); _objCurrentInfo = new CurrentInfo(); string company_Code = _objCurrentInfo.GetCompanyCode(); DataSet ds = objBlApproval.GetSFCInCPTPDCRPopup(company_Code, region_Code, sfcCodes); StringBuilder sbTableContent = new StringBuilder(); sbTableContent.Append("<table id='tblPopsummary' class='table table-striped' >"); sbTableContent.Append("<thead style='background-color: gainsboro; font-weight: bold' class='active'>"); sbTableContent.Append("<tr>"); sbTableContent.Append("<td>SFC Row</td>"); sbTableContent.Append("<td>Screen</td>"); sbTableContent.Append("<td>Name</td>"); sbTableContent.Append("<td>Date</td>"); sbTableContent.Append("<td>Status</td>"); sbTableContent.Append("</tr>"); sbTableContent.Append("</thead>"); sbTableContent.Append("<tbody>"); if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables.Count; i++) { for (int j = 0; j < ds.Tables[i].Rows.Count; j++) { sbTableContent.Append("<tr><td>" + ds.Tables[i].Rows[j]["Row_Number"] + "</td>"); sbTableContent.Append("<td>" + ds.Tables[i].Rows[j]["Transaction"] + "</td>"); sbTableContent.Append("<td>" + ds.Tables[i].Rows[j]["Name"] + "</td>"); sbTableContent.Append("<td>" + ds.Tables[i].Rows[j]["Date"] + "</td>"); sbTableContent.Append("<td>" + ds.Tables[i].Rows[j]["Status"] + "</td></tr>"); } } } sbTableContent.Append("</tbody>"); sbTableContent.Append("</table>"); return(sbTableContent.ToString()); }
public string ChangeStatus(FormCollection collection) { try { //Added DCR History details for Mobile BLApproval _objApproval = new BLApproval(); DALApproval _objDALApproval = new DALApproval(); string leaveEntry = collection["LeaveValidation"].ToString(); string remarks = collection["Remarks"].ToString(); string status = collection["Status"].ToString(); string dcrCode = collection["DCRCode"].ToString(); string flag = collection["Flag"].ToString(); string leaveType = collection["LeaveTypeName"].ToString(); string userCode = collection["UserCode"].ToString(); string calcFields = collection["CalcFields"].ToString(); string DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK = collection["DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK"].ToString(); string dcr_Actual_Date = collection["DCR_Actual_Date"].ToString(); string twoActivityExpenseValidation = collection["twoActivityExpenseValidation"].ToString(); string fareDailyAllowance = collection["fareDailyAllowance"].ToString(); string calcFieldStatus = calcFields.ToUpper() == "APPLIED" ? "1" : "2"; string[] privValues; // string leaveTypeName = ""; // bool isCurBalanceNeed = false; // double dblLeaveBalance = 0.0; string dcrStatus; int CurrexpenseClaimValidation = 0; privValues = leaveEntry.Split(','); if (status == "0") { if (string.IsNullOrEmpty(remarks)) { return("FAIL:Reason must be given for unapproval"); } } if (twoActivityExpenseValidation.ToUpper() != "NO" && fareDailyAllowance != "" && flag != "L" && status == "0") { string twoActivityDCRApproval = _objDALApproval.GetTwoActivityDCRApproval(dcrCode, flag, fareDailyAllowance); objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "'"); } if (dcrStatus == "2") { CurrexpenseClaimValidation = _objDALApproval.CheckExpenseClaim(_objCurrentInfo.GetCompanyCode(), userCode, dcrCode, flag, dcr_Actual_Date); if (CurrexpenseClaimValidation > 0) { return("FAIL:You Cannot Unapprove the DCR-" + dcr_Actual_Date + " " + ((flag == "F") ? "Field" : ((flag == "A") ? "Attendace" : "Leave")) + " as the expenses are claimed in expenses claim"); } string expenseClaimValidation = _objDALApproval.CheckDayExpenseClaim(dcrCode, flag); if (expenseClaimValidation != "") { return("FAIL:You Cannot Unapprove the other DCR-" + expenseClaimValidation.Split('|')[0] + " " + ((expenseClaimValidation.Split('|')[1] == "F") ? "Field" : ((expenseClaimValidation.Split('|')[1] == "A") ? "Attendace" : "Leave")) + " as the expenses are claimed in expenses claim"); } } if (twoActivityDCRApproval != "") { string TwoActivitydcrCode = twoActivityDCRApproval.Split('|')[0]; string TwoActivityflag = twoActivityDCRApproval.Split('|')[1]; string TwoActivitydcrStatusOld = twoActivityDCRApproval.Split('|')[2]; // dcrStatusOld = ((dcrStatusOld == "Applied") ? "1" : "0"); string TwoActivityoldReason = twoActivityDCRApproval.Split('|')[3]; string TwoActivityleaveTypeName = twoActivityDCRApproval.Split('|')[4]; string TwoActivitydcrDate = twoActivityDCRApproval.Split('|')[5]; objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + TwoActivitydcrCode + "','" + TwoActivityflag + "'"); } if (dcrStatus == "1" || dcrStatus == "2") // Applied and Approved { objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + TwoActivitydcrCode + "','" + TwoActivityflag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + TwoActivitydcrStatusOld + "','" + userCode + "'"); } int firstexpenseRowCount = 0; firstexpenseRowCount = _objDALApproval.DeleteDCRExpense(TwoActivityflag, TwoActivitydcrCode, fareDailyAllowance); if (DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK.ToUpper().Trim() == "ENABLED") { IDCRLock objDCRLock = new BLDCRLock(); List <DCRActivityLockModel> lstDCRActivityLockModel = new List <DCRActivityLockModel>(); DCRActivityLockModel dcrActivityLockModel = new DCRActivityLockModel(); string comany_Code = _objCurrentInfo.GetCompanyCode(); dcrActivityLockModel.User_Code = userCode; dcrActivityLockModel.DCR_Actual_Date = dcr_Actual_Date; dcrActivityLockModel.Activity_Flag = TwoActivityflag; dcrActivityLockModel.Locked_Date = DateTime.Now.ToShortDateString(); lstDCRActivityLockModel.Add(dcrActivityLockModel); int result = objDCRLock.InsertActivityLock(comany_Code, lstDCRActivityLockModel); } int result_History = _objApproval.InsertDcrHistory(_objCurrentInfo.GetCompanyCode(), TwoActivitydcrCode, TwoActivityflag); } else { return("FAIL:You cannot change the status of Unapproved DCRs."); } } } objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "'"); } if (dcrStatus == "1" || dcrStatus == "2") // Applied and Approved { //START: The Leave entry validation finctionality commented as per Customer Service Request. //if (flag == "L") // { //leaveTypeName = leaveType; //isCurBalanceNeed = false; //for (int j = 0; j < privValues.Length; j++) //{ // if (privValues[j].ToString().Trim().ToUpper() == leaveTypeName.ToUpper()) // { // isCurBalanceNeed = true; // break; // } //} //dblLeaveBalance = 0.0; //if (isCurBalanceNeed) //{ // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // object leaveBal = objData.ExecuteScalar("exec SP_hdGetLeaveBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + userCode + "'"); // if (leaveBal.ToString() != "" && leaveBal != null) // { // if (!string.IsNullOrEmpty(leaveBal.ToString())) // { // dblLeaveBalance = float.Parse(leaveBal.ToString()); // } // } // } // if (dblLeaveBalance > 0) // { // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'"); // } // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // objData.ExecuteNonQuery("exec SP_hdUpdateUserLeaveCurBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + userCode + "','" + dcrStatus + "','" + status + "'"); // } // } // else if (status == "0") // { // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'"); // } // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // objData.ExecuteNonQuery("exec SP_hdUpdateUserLeaveCurBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + userCode + "','" + dcrStatus + "','" + status + "'"); // } // } // else // { // return "FAIL:Due to insufficient leave balance, unable to approve leave for " + leaveTypeName + ""; // } //} //else //{ // objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); // { // objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'"); //} //} //} //END: The Leave entry validation finctionality commented as per Customer Service Request. objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'"); } if (flag.ToUpper() != "L" && status == "0") { int secondexpenseRowCount = 0; secondexpenseRowCount = _objDALApproval.DeleteDCRExpense(flag, dcrCode, fareDailyAllowance); } if (DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK.ToUpper().Trim() == "ENABLED") { IDCRLock objDCRLock = new BLDCRLock(); List <DCRActivityLockModel> lstDCRActivityLockModel = new List <DCRActivityLockModel>(); DCRActivityLockModel dcrActivityLockModel = new DCRActivityLockModel(); string comany_Code = _objCurrentInfo.GetCompanyCode(); dcrActivityLockModel.User_Code = userCode; dcrActivityLockModel.DCR_Actual_Date = dcr_Actual_Date; dcrActivityLockModel.Activity_Flag = flag; dcrActivityLockModel.Locked_Date = DateTime.Now.ToShortDateString(); lstDCRActivityLockModel.Add(dcrActivityLockModel); int result = objDCRLock.InsertActivityLock(comany_Code, lstDCRActivityLockModel); if (result > 0) { return("SUCCESS:Status Changed Successfully. But Insert Activity Lock Fail."); } } int result_History = _objApproval.InsertDcrHistory(_objCurrentInfo.GetCompanyCode(), dcrCode, flag); } else { return("FAIL:You cannot change the status of Unapproved DCRs."); } return("SUCCESS:Status Changed Successfully"); } finally { objData.CloseConnection(); } }