public int UpdateLeaveType(string CompanyCode, string LeaveTypeCode, string LeaveTypeName, string updatedBy, string updatedDate, string payrollleavetypeCode, string IsLop)
{
try
{
_objSPData = new SPData();
_objData = new Data();
SqlCommand command = new SqlCommand(SP_HD_UpdateLeaveType);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, CompanyCode);
_objSPData.AddParamToSqlCommand(command, "@LeaveTypeCode", ParameterDirection.Input, SqlDbType.VarChar, 30, LeaveTypeCode);
_objSPData.AddParamToSqlCommand(command, "@LeaveTypeName", ParameterDirection.Input, SqlDbType.VarChar, 30, LeaveTypeName);
_objSPData.AddParamToSqlCommand(command, "@UpdatedBy", ParameterDirection.Input, SqlDbType.VarChar, 10, updatedBy);
_objSPData.AddParamToSqlCommand(command, "@UpdatedDate", ParameterDirection.Input, SqlDbType.VarChar, 10, updatedDate);
_objSPData.AddParamToSqlCommand(command, "@PayrollleavetypeCode", ParameterDirection.Input, SqlDbType.VarChar, 30, payrollleavetypeCode);
_objSPData.AddParamToSqlCommand(command, "@IsLOP", ParameterDirection.Input, SqlDbType.VarChar, 10, IsLop);
_objData.OpenConnection(CompanyCode);
string returnvale = _objData.ExecuteScalar(command).ToString();
_objData.CloseConnection();
return(Convert.ToInt32(returnvale));
}
catch (Exception ex)
{
throw ex;
}
}
public string GetAttendanceDetail(string companyCode, string userCode, string dcrDate)
{
string result = string.Empty;
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_HD_V4_GetTPAttendanceDetails);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@DCRDate", ParameterDirection.Input, SqlDbType.VarChar, 15, dcrDate);
_objData.OpenConnection(companyCode);
result = Convert.ToString(_objData.ExecuteScalar(command));
return(result);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
public bool IsEDAvailable(string companyCode, string userTypeCode)
{
try
{
int count = 0;
SqlCommand command = new SqlCommand(SPEDCHECKEDACCESS);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserTypeCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userTypeCode);
_objData.OpenConnection();
count = (int)_objData.ExecuteScalar(command);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
finally
{
_objData.CloseConnection();
}
}
public string InsertBrand(FormCollection collection)
{
string result = "";
DataControl.Data ds = new DataControl.Data();
try
{
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string CompanyCode = objCurInfo.GetCompanyCode();
string BrandName = collection["BrandName"].ToString();
string BrandCode = collection["BrandCode"].ToString();
string Mode = collection["Mode"].ToString();
string strSQL = "EXEC sp_sdInsertBrand '" + CompanyCode + "','" + BrandName + "','" + BrandCode + "','" + Mode + "'";
result = (string)ds.ExecuteScalar(strSQL);
}
return(result);
}
finally
{
ds.CloseConnection();
}
}
public string UserProductMap(FormCollection collection)
{
string str = "";
try
{
string Emp_No = collection["Emp_No"].ToString();
string Product_Ref_Key = collection["Product_Ref_Key"].ToString();
DataControl.Data ds = new DataControl.Data();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
string strSQL = "";
strSQL = "EXEC SP_HD_InwardBulk_UserProductMap '" + Emp_No + "','" + Product_Ref_Key + "'";
str = ds.ExecuteScalar(strSQL).ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(str);
}
public string GetHolidayCount(FormCollection collection)
{
try
{
string result = string.Empty;
BLRegion objRegion = new BLRegion();
JSONConverter objJson = new JSONConverter();
string fromDate = collection["fromDate"].ToString();
string toDate = collection["toDate"].ToString();
string companyCode = _objCurr.GetCompanyCode();
_objData.OpenConnection(companyCode);
{
result = Convert.ToString(_objData.ExecuteScalar("exec SP_hdGetHolidayCount '" + companyCode + "','" + _objCurr.GetUserCode() + "','" + fromDate + "','" + toDate + "','" + _objCurr.GetRegionCode() + "'"));
}
#region WeekendDays
List <MVCModels.HiDoctor_Master.WeekendDaysForARegion> lstWeekend = new List <MVCModels.HiDoctor_Master.WeekendDaysForARegion>();
lstWeekend = objRegion.GetWeekendDaysForARegion(companyCode, _objCurr.GetRegionCode(), fromDate, toDate);
#endregion WeekendDays
return(result + "$" + objJson.Serialize(lstWeekend));
}
finally
{
_objData.CloseConnection();
}
}
public int InsertUserLeaveTypeMaster(string Company_Code, string Effective_From, string Effective_To, string IS_Added_Weekend_Holiday,
string IS_Added_Holiday, string Leave_Type_Code, string Min_Leave, string Max_Leave, string User_Code, string User_Type_Code,
string Created_By, string Created_Date, string User_Leave_Status, string Updated_By, string Updated_Date,
string User_Leave_Type_Code, string clubbing, int leaveeligible, string leaveconfirmation, string leaveoncompletion, int noofdays, int applicdays, string validation_Mode, string leave_Occurrence_Count, string leave_Max_Count, string Document_Upload, string consecutvie_Leave_Allowed, string mode)
{
//int rowsAffected = 0;
try
{
_objSPData = new SPData();
_objData = new Data();
SqlCommand command = new SqlCommand(SP_HD_InsertUserLeaveTypeMapping);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, Company_Code);
_objSPData.AddParamToSqlCommand(command, "@Effective_From", ParameterDirection.Input, SqlDbType.VarChar, 30, Effective_From);
_objSPData.AddParamToSqlCommand(command, "@Effective_To", ParameterDirection.Input, SqlDbType.VarChar, 30, Effective_To);
_objSPData.AddParamToSqlCommand(command, "@IS_Added_Weekend_Holiday", ParameterDirection.Input, SqlDbType.VarChar, 1, IS_Added_Weekend_Holiday);
_objSPData.AddParamToSqlCommand(command, "@IS_Added_Holiday", ParameterDirection.Input, SqlDbType.VarChar, 1, IS_Added_Holiday);
_objSPData.AddParamToSqlCommand(command, "@Leave_Type_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, Leave_Type_Code);
_objSPData.AddParamToSqlCommand(command, "@Min_Leave", ParameterDirection.Input, SqlDbType.VarChar, 8, Min_Leave);
_objSPData.AddParamToSqlCommand(command, "@Max_Leave", ParameterDirection.Input, SqlDbType.VarChar, 8, Max_Leave);
_objSPData.AddParamToSqlCommand(command, "@User_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, User_Code);
_objSPData.AddParamToSqlCommand(command, "@User_Type_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, User_Type_Code);
_objSPData.AddParamToSqlCommand(command, "@User_Leave_Type_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, User_Leave_Type_Code);
_objSPData.AddParamToSqlCommand(command, "@User_Leave_Status", ParameterDirection.Input, SqlDbType.VarChar, 30, User_Leave_Status);
_objSPData.AddParamToSqlCommand(command, "@Created_By", ParameterDirection.Input, SqlDbType.VarChar, 30, Created_By);
_objSPData.AddParamToSqlCommand(command, "@Created_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, Created_Date);
_objSPData.AddParamToSqlCommand(command, "@Updated_By", ParameterDirection.Input, SqlDbType.VarChar, 30, Updated_By);
_objSPData.AddParamToSqlCommand(command, "@Updated_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, Updated_Date);
_objSPData.AddParamToSqlCommand(command, "@clubbing", ParameterDirection.Input, SqlDbType.VarChar, 200, clubbing);
_objSPData.AddParamToSqlCommand(command, "@leaveeligible", ParameterDirection.Input, SqlDbType.Int, 32, leaveeligible);
_objSPData.AddParamToSqlCommand(command, "@leaveconfirmation", ParameterDirection.Input, SqlDbType.VarChar, 10, leaveconfirmation);
_objSPData.AddParamToSqlCommand(command, "@leaveoncompletion", ParameterDirection.Input, SqlDbType.VarChar, 10, leaveoncompletion);
_objSPData.AddParamToSqlCommand(command, "@noofdays", ParameterDirection.Input, SqlDbType.Int, 32, noofdays);
_objSPData.AddParamToSqlCommand(command, "@applicdays", ParameterDirection.Input, SqlDbType.Int, 32, applicdays);
_objSPData.AddParamToSqlCommand(command, "@Validation_Mode", ParameterDirection.Input, SqlDbType.VarChar, 1, validation_Mode);
_objSPData.AddParamToSqlCommand(command, "@Leave_Occurrence_Count", ParameterDirection.Input, SqlDbType.VarChar, 10, leave_Occurrence_Count);
_objSPData.AddParamToSqlCommand(command, "@Leave_Max_Count", ParameterDirection.Input, SqlDbType.VarChar, 10, leave_Max_Count);
_objSPData.AddParamToSqlCommand(command, "@Document_Upload", ParameterDirection.Input, SqlDbType.VarChar, 10, Document_Upload);
_objSPData.AddParamToSqlCommand(command, "@Consecutvie_Leave_Allowed", ParameterDirection.Input, SqlDbType.VarChar, 10, consecutvie_Leave_Allowed);
_objSPData.AddParamToSqlCommand(command, "@mode", ParameterDirection.Input, SqlDbType.VarChar, 30, mode);
_objData.OpenConnection(Company_Code);
string returnvalue = _objData.ExecuteScalar(command).ToString();
_objData.CloseConnection();
return(Convert.ToInt32(returnvalue));
}
catch (Exception ex)
{
throw ex;
}
}
private string GetNextTwoPossibleDays(string dcrDate)
{
try
{
string possibleDays = string.Empty;
objData.OpenConnection(objCurr.GetCompanyCode());
{
possibleDays = Convert.ToString(objData.ExecuteScalar("exec SP_hdGetNextTwoPossibleDays '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + objCurr.GetRegionCode() + "','" + dcrDate + "'"));
}
return(possibleDays);
}
finally
{
objData.CloseConnection();
}
}
public string InsertSpeciality(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
try
{
string result = "";
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC sp_sdInsertSpeciality '" + objCurInfo.GetCompanyCode() + "','" + collection["SpecialityName"].ToString() + "','" + collection["SpecialityCount"].ToString() + "','" + collection["SpecialityCode"].ToString() + "','" + collection["Mode"].ToString() + "'";
result = (string)ds.ExecuteScalar(strSQL);
}
return(result);
}
finally
{
ds.CloseConnection();
}
}
public int CheckKangleAccess()
{
try
{
string str = "";
SqlCommand command = new SqlCommand(SP_HD_KANGLE_CHECKACCESS);
command.CommandType = CommandType.StoredProcedure;
_ObjData.OpenConnection();
str = _ObjData.ExecuteScalar(command).ToString();
if (str == "YES")
return 1;
else
return 0;
}
catch(Exception ex)
{
return 0;
}
}
public int CheckItranProduct(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
try
{
int count = 0;
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC sp_sdCheckItranProduct '" + objCurInfo.GetCompanyCode() + "','" + collection["ProductCode"].ToString() + "'";
count = (int)ds.ExecuteScalar(strSQL);
}
return(count);
}
finally
{
ds.CloseConnection();
}
}
public string BatchAutoCreate(FormCollection collection)
{
string ProductCode = collection["ProductCode"].ToString();
string User_Code = objCurInfo.GetUserCode();
DataControl.Data ds = new DataControl.Data();
try
{
string str = "";
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC SP_HD_ProductBatchMigrate '" + ProductCode + "','" + User_Code + "'";
str = ds.ExecuteScalar(strSQL).ToString();
}
return(str);
}
finally
{
ds.CloseConnection();
}
}
public string ChangeBatchStatus(FormCollection collection)
{
string mappingId = collection["MappingId"].ToString();
string Status = collection["Status"].ToString();
string User_Code = objCurInfo.GetUserCode();
DataControl.Data ds = new DataControl.Data();
try
{
string str = "";
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC SP_HD_UPD_BatchStatus " + mappingId.ToString() + "," + Status.ToString() + ",'" + User_Code + "'";
str = ds.ExecuteScalar(strSQL).ToString();
}
return(str);
}
finally
{
ds.CloseConnection();
}
}
public string SaveBatch(FormCollection collection)
{
string ProductCode = collection["ProductCode"].ToString();
string BatchNumber = collection["Batch_Number"].ToString();
string ExpiryDate = collection["Expiry_Date"].ToString();
string Effective_From = collection["Effective_From"].ToString();
string Effective_To = collection["Effective_To"].ToString();
string User_Code = objCurInfo.GetUserCode();
string Merge_Qty = collection["MergeQty"].ToString();
int Mode = Convert.ToInt32(collection["Mode"].ToString());
int MappingId = Convert.ToInt32(collection["MappingId"].ToString() == "" ? "0" : collection["MappingId"].ToString());
DataControl.Data ds = new DataControl.Data();
try
{
string str = "";
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "";
if (Mode == 0)
{
strSQL = "EXEC SP_HD_INS_ProductBatch '" + ProductCode + "','" + BatchNumber + "','" + ExpiryDate + "','" + Effective_From + "','" + Effective_To + "','" + User_Code + "','" + Merge_Qty + "'";
}
else if (Mode == 1)
{
strSQL = "EXEC SP_HD_UPD_ProductBatch " + MappingId + ",'" + ExpiryDate + "','" + Effective_To + "'";
}
str = ds.ExecuteScalar(strSQL).ToString();
}
return(str);
}
finally
{
ds.CloseConnection();
}
}
public string GetExpenseGroupMaxID(FormCollection coll)
{
try
{
string expenseID = string.Empty;
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
expenseID = Convert.ToString(_objData.ExecuteScalar("exec SP_hdGetExpenseGroupMaxID '" + _objCurr.GetCompanyCode() + "'"));
}
return(expenseID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_objData.CloseConnection();
}
}
public string ProductBatchMap(FormCollection collection)
{
string str = "";
try
{
string Product_Ref_Key = collection["Product_Ref_Key"].ToString();
string Batch_Number = collection["Batch_Number"].ToString();
string user_code = _objCurrentInfo.GetUserCode();
DataControl.Data ds = new DataControl.Data();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
string strSQL = "";
strSQL = "EXEC SP_HD_InwardBulk_ProductBatchMap '" + Product_Ref_Key + "','" + Batch_Number + "','" + user_code + "'";
str = ds.ExecuteScalar(strSQL).ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(str);
}
public string ChangeProductStatus(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
string result = string.Empty;
try
{
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC sp_sdChangeProductStatus '" + objCurInfo.GetCompanyCode() + "','" + collection["ProductCode"].ToString() + "'";
result = (string)ds.ExecuteScalar(strSQL);
}
return(result);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
finally
{
ds.CloseConnection();
}
}
public double GetExpenseSum(string dcrActualDate, string mode, string expenseTypeCode)
{
try
{
DateTime dcrDate = new DateTime();
double sum = 0.0;
string fromDate = string.Empty, toDate = string.Empty;
int startDay = 0, endDay = 0;
string expenseMode = mode.ToUpper();
dcrDate = Convert.ToDateTime(dcrActualDate);
switch (expenseMode)
{
case "MONTHLY":
startDay = 1;
endDay = DateTime.DaysInMonth(dcrDate.Year, dcrDate.Month);
fromDate = Convert.ToString(dcrDate.Year.ToString() + "-" + dcrDate.Month.ToString() + "-" + startDay.ToString());
toDate = Convert.ToString(dcrDate.Year.ToString() + "-" + dcrDate.Month.ToString() + "-" + endDay.ToString());
sum = GetSum(fromDate, toDate, expenseTypeCode);
break;
case "YEARLY":
fromDate = Convert.ToString(dcrDate.Year.ToString() + "-01-01");
toDate = Convert.ToString(dcrDate.Year.ToString() + "-12-31");
sum = GetSum(fromDate, toDate, expenseTypeCode);
break;
case "WEEKLY":
objData.OpenConnection(objCurr.GetCompanyCode());
{
sum = Convert.ToDouble(objData.ExecuteScalar("exec SP_hdGetWeeklyExpenseSum '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + dcrDate + "','" + expenseTypeCode + "'"));
}
objData.CloseConnection();
break;
//case "FORTNIGHTLY":
// if (dcrDate.Day > 15)
// {
// startDay = 16;
// endDay = DateTime.DaysInMonth(dcrDate.Year, dcrDate.Month);
// }
// else
// {
// startDay = 1;
// endDay = 15;
// }
// fromDate = Convert.ToString(dcrDate.Year.ToString() + "-" + dcrDate.Month.ToString() + "-" + startDay.ToString());
// toDate = Convert.ToString(dcrDate.Year.ToString() + "-" + dcrDate.Month.ToString() + "-" + endDay.ToString());
// sum = GetSum(fromDate, toDate, expenseTypeCode);
// break;
default:
break;
}
return(sum);
}
catch (Exception ex)
{
throw ex;
}
}
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();
}
}
//save functionality//
public string save(FormCollection collection)
{
string Result = string.Empty;
string UserCode = string.Empty;
string SelectDate = string.Empty;
string Content = string.Empty;
string UserinwardCode = string.Empty;
string UserinwardDetail = string.Empty, maxCode = string.Empty;
UserCode = collection["UserCode"];
SelectDate = collection["SelectDate"];
DataControl.Data objAppData = new DataControl.Data();
string queryMax = objAppData.getSingleValue(Session["Comp_Code"].ToString(), "SELECT CONVERT(VARCHAR,MAX(CAST(SUBSTRING(User_Inward_Code,4,LEN(User_Inward_Code)) AS INT))) FROM tbl_SFA_Inward_Stock");
maxCode = getMaxCode(Convert.ToInt64(queryMax), "UIC");
string userMaxCode = objAppData.getSingleValue(Session["Comp_Code"].ToString(), "SELECT CONVERT(VARCHAR,MAX(CAST(SUBSTRING(User_Inward_Detail,4,LEN(User_Inward_Detail)) AS INT))) FROM tbl_SFA_Inward_Details");
UserinwardCode = maxCode;
string[] strArr = collection["Content"].Split('^');
string ProductCode = "";
string InwardStock = "";
string BatchNumber = "";
string strSQL = "";
string strSqlInward = "";
string userInwardCode = "";
string Remarks = "";
//string productDetails = "";
DataControl.Data ds = new DataControl.Data();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
strSQL = "EXEC Sp_hdInwardStock_Insert " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + SelectDate + "'";
userInwardCode = ds.ExecuteScalar(strSQL).ToString();
ds.CloseConnection();
}
if (strArr.Length > 0)
{
for (int i = 0; i < strArr.Length; i++)
{
if (strArr[i] != string.Empty)
{
//userMaxCode = (Convert.ToInt64(userMaxCode) + 1).ToString();
//UserinwardDetail = objAppData.getMaxValues(userMaxCode, "UDC");
ProductCode = strArr[i].Split('_')[0];
BatchNumber = strArr[i].Split('_')[1].Trim();
InwardStock = strArr[i].Split('_')[2];
Remarks = strArr[i].Split('_')[4];
strSqlInward += "EXEC Sp_hdInwardDetails_Insert " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + userInwardCode + "','" + ProductCode + "','" + BatchNumber + "','" + InwardStock + "','" + Remarks + "';";
}
}
}
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
ds.ExecuteNonQuery(strSqlInward);
ds.CloseConnection();
}
return("INSERTED");
}
public JsonResult ExpenseDetails(FormCollection collection)
{
try
{
DataSet dsExpense = new DataSet();
DataTable dsExpenseAutoFill = new DataTable();
DataTable dsExpensePreFill = new DataTable();
string companyCode = _objCurr.GetCompanyCode();
string userTypeCode = _objCurr.GetUserTypeCode();
string regionCode = _objCurr.GetRegionCode();
string entity = collection["entity"].ToString();
string dcrDate = collection["dcrDate"].ToString();
string dcrCode = _objCurr.GetDCRCode(dcrDate);
string dcrStatus = collection["dcrStatus"].ToString();
string interMediatePlace = collection["InterMediate_Places_Needed"].ToString();
double travelKm = Convert.ToDouble(collection["Travel_Km"]);
string flag = collection["flag"].ToString();
string isExpenseGroup = string.Empty;
List <Models.DCRExpenseModel> lstExpenseAuto = new List <Models.DCRExpenseModel>();
List <Models.DCRExpenseModel> lstExpensePre = new List <Models.DCRExpenseModel>();
List <Models.DCRExpenseModel> lstDraftedExpense = new List <Models.DCRExpenseModel>();
// check whether the expense group has mapped
try
{
_objData.OpenConnection(companyCode);
{
isExpenseGroup = Convert.ToString(_objData.ExecuteScalar("exec SP_hdCheckExpenseGroupMapping '" + companyCode + "','" + _objCurr.GetUserCode() + "','" + regionCode + "'"));
}
}
finally
{
_objData.CloseConnection();
}
if (isExpenseGroup != "NO_GROUP")
{
// Get Expense Data
try
{
_objData.OpenConnection(companyCode);
{
dsExpense = _objData.ExecuteDataSet("exec SP_hdGetExpenseNG '" + companyCode + "','" + dcrDate + "','" + isExpenseGroup + "','" + entity + "'");
}
}
finally
{
_objData.CloseConnection();
}
dsExpenseAutoFill = dsExpense.Tables[0];
dsExpensePreFill = GetFareCalculatedExpense(dsExpense.Tables[1], entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
}
else
{
//old logic
// Get Expense data
try
{
_objData.OpenConnection(companyCode);
{
dsExpense = _objData.ExecuteDataSet("exec SP_hdGetExpense '" + companyCode + "','" + regionCode + "','" + userTypeCode + "','" + entity + "'");
}
}
finally
{
_objData.CloseConnection();
}
// auto fill Data
dsExpenseAutoFill = GetExpenseData(dsExpense.Tables[0], "A", entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
// PrefillData
dsExpensePreFill = GetExpenseData(dsExpense.Tables[1], "P", entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
}
if (dcrStatus == "3" || dcrStatus == "0")
{
DataSet dsDraftedExpense = new DataSet();
string userCode = _objCurr.GetUserCode();
// Get Expense Drafted item
try
{
_objData.OpenConnection(companyCode);
{
dsDraftedExpense = _objData.ExecuteDataSet("exec SP_hdGetDraftedExpense '" + companyCode + "','" + dcrCode + "','" + userCode + "','" + dcrDate + "','" + flag + "'");
}
}
finally
{
_objData.CloseConnection();
}
if (dsDraftedExpense.Tables.Count > 0)
{
if (dsDraftedExpense.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsDraftedExpense.Tables[0];
lstDraftedExpense = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseRemark = item["Expense_Remarks"].ToString(),
ExpenseAmount = item["Expense_Amount"].ToString()
}).ToList <Models.DCRExpenseModel>();
}
}
}
if (dsExpenseAutoFill.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsExpenseAutoFill;
lstExpenseAuto = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseMode = item["Expense_Mode"].ToString(),
ExpenseEntity = item["Expense_Entity"].ToString(),
ExpenseEntityCode = item["Expense_Entity_Code"].ToString(),
EligibilityAmount = item["Eligibility_Amount"].ToString(),
CanSplitAmount = item["Can_Split_Amount"].ToString(),
IsValidationOnEligibility = item["Is_Validation_On_Eligibility"].ToString(),
//IsPeriodBoundaryCheck = item["Is_Period_Boundary_Check"].ToString(),
SFC_Type = item["SFC_Type"].ToString(),
IsPrefill = item["Is_Prefill"].ToString(),
ExpenseGroupId = isExpenseGroup
}).ToList <Models.DCRExpenseModel>();
}
if (dsExpensePreFill.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsExpensePreFill;
lstExpensePre = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseMode = item["Expense_Mode"].ToString(),
ExpenseEntity = item["Expense_Entity"].ToString(),
ExpenseEntityCode = item["Expense_Entity_Code"].ToString(),
EligibilityAmount = item["Eligibility_Amount"].ToString(),
CanSplitAmount = item["Can_Split_Amount"].ToString(),
IsValidationOnEligibility = item["Is_Validation_On_Eligibility"].ToString(),
//IsPeriodBoundaryCheck = item["Is_Period_Boundary_Check"].ToString(),
SFC_Type = item["SFC_Type"].ToString(),
IsPrefill = item["Is_Prefill"].ToString(),
TotalFare = Convert.ToDouble(item["Total_Fare"]),
ExpenseGroupId = isExpenseGroup
}).ToList <Models.DCRExpenseModel>();
}
List <JsonResult> lstExpense = new List <JsonResult> {
Json(lstExpenseAuto, JsonRequestBehavior.AllowGet), Json(lstExpensePre, JsonRequestBehavior.AllowGet), Json(lstDraftedExpense, JsonRequestBehavior.AllowGet)
};
return(Json(lstExpense, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
