/// <summary>
/// Release the Activity lock.
/// </summary>
/// <param name="user_Code"></param>
/// <param name="dcrActualDate"></param>
/// <param name="flag"></param>
/// <returns></returns>
///
public bool ReleasetheActivityLock(string user_Code, string dcrDetails)
{
bool result = false;
// Creates Instance.
_objCurrentInfo = new CurrentInfo();
_objdcrLock = new BLDCRLock();
// Assign to the Model property.
DCRActivityLockModel dcrActivityLockModel = new DCRActivityLockModel();
dcrActivityLockModel.User_Code = user_Code;
// multiple dcr actual dates and flags with ^ symbol.
// dcrActivityLockModel.DCR_Actual_Date = dcrActualDates;
// dcrActivityLockModel.Activity_Flag = flags;
dcrActivityLockModel.Released_By = _objCurrentInfo.GetUserCode();
dcrActivityLockModel.Released_Date = DateTime.Now.ToShortDateString();
dcrActivityLockModel.Request_Released_By = dcrActivityLockModel.Request_Released_By;
dcrActivityLockModel.Released_Reason = dcrActivityLockModel.Released_Reason;
// Call the funtion.
string activityResult = _objdcrLock.ReleaseActivityLock(_objCurrentInfo.GetCompanyCode(), user_Code, dcrDetails, _objCurrentInfo.GetUserCode());
if (activityResult.ToUpper() == "SUCCESS")
{
result = true;
}
return(result);
}
/// <summary>
/// Convertes the LockReader to Lock Model List.
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private List <DCRActivityLockModel> ActvityDataReader_MaptoList(SqlDataReader reader)
{
List <DCRActivityLockModel> lstdcrLockModel = new List <DCRActivityLockModel>();
while (reader.Read())
{
DCRActivityLockModel dcrLockModel = new DCRActivityLockModel();
dcrLockModel.DCR_Actual_Date = reader["DCR_Actual_Date"].ToString();
dcrLockModel.User_Code = reader["User_Code"].ToString();
dcrLockModel.User_Name = reader["User_Name"].ToString();
dcrLockModel.Locked_Date = reader["Locked_Date"].ToString();
dcrLockModel.Activity_Flag = reader["Activity_Flag"].ToString();
dcrLockModel.Unapprove_Reason = reader["Unapproval_Reason"].ToString();
dcrLockModel.Unapproved_by = reader["Unapproved_by"].ToString();
lstdcrLockModel.Add(dcrLockModel);
}
return(lstdcrLockModel);
}
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();
}
}
