public string InsertUpdateLeave(string fromDate, string toDate, string reason, string leaveTypeCode, string entry_mode,
int leave_Status, string doc_Url, string uploaded_files, string objDateDetails)
{
string result = "";
int originOfDCR = 0;
string company_Code = _objCurr.GetCompanyCode();
string user_Code = _objCurr.GetUserCode();
string user_Name = _objCurr.GetUserName();
string region_Code = _objCurr.GetRegionCode();
DateCapturingModel _obDateDet = JsonConvert.DeserializeObject <DateCapturingModel>(objDateDetails);
if (!(_obDateDet.Off_Set.Contains('+') && !(_obDateDet.Off_Set.Contains('-'))))
{
_obDateDet.Off_Set = '+' + _obDateDet.Off_Set.Trim();
}
if (entry_mode == "WEB" && leave_Status == 1)
{
originOfDCR = 1;
}
result = _objSP.InsertUpdateLeave(company_Code, user_Code, user_Name, region_Code, fromDate, toDate, reason, leaveTypeCode, entry_mode, leave_Status, doc_Url, originOfDCR, uploaded_files, _obDateDet);
return(result);
}
public bool InsertHeaderDetails(string companyCode, string userCode, string regionCode, string dcrCode,
string dcrDate, string dcrStatus, string distanceFareCode, string category, string categoryCode, string cpCode, string cpName,
string workPlace, string fromPlace, string toPlace, string travelMode, string distance, string startTime, string endTime,
string acc1Name, string acc1Type, string acc1StartTime, string acc1EndTime, string acc1OnlyDoctor, string acc1Mode,
string acc2Name, string acc2Type, string acc2StartTime, string acc2EndTime, string acc2OnlyDoctor, string acc2Mode,
string acc3Name, string acc3Time, string acc3OnlyDoctor, string acc3Mode,
string acc4Name, string acc4Time, string acc4OnlyDoctor, string acc4Mode,
string isrcpa, string routeWay, string activityString, string dcrFlag, string tpDeviation, string cpDeviation, string entryMode, string dataFrom,
string sfcRegionCode, string sfcVersionNo, string sfcCategoryName,
string lattitude, string longitude, string location, Boolean dcr_Freeze, string _objDateDetails, int ISchecked)
{
try
{
DateCapturingModel _obDateDet = JsonConvert.DeserializeObject <DateCapturingModel>(_objDateDetails);
if (!(_obDateDet.Off_Set.Contains('+') && !(_obDateDet.Off_Set.Contains('-'))))
{
_obDateDet.Off_Set = '+' + _obDateDet.Off_Set.Trim();
}
string result = string.Empty;
bool flag = false;
int originOfDCR = 0;
// Define Origin Of DCR.
// Its applicable for Fresh entry. For Other status DCR's the first entry of "Origin_Of_DCR" will be maintained.
// 1 = Web,2 = Mobile,3 = WA
if (dcrStatus == "1")
{
if (dataFrom == "WA")
{
originOfDCR = 3;
}
else if (entryMode == "WEB")
{
originOfDCR = 1;
}
else if (entryMode == "MOBILE")
{
originOfDCR = 2;
}
}
string loc = "NOT_FOUND";
if (lattitude == "" || lattitude == "Null" || lattitude == "0")
{
lattitude = loc;
}
if (longitude == "" || longitude == "Null" || longitude == "0")
{
longitude = loc;
}
if (location == "" || location == "Null" || location == "0")
{
location = loc;
}
result = _objDCRDAL.InsertHeaderDetails(companyCode, userCode, regionCode, dcrCode, dcrDate, dcrStatus, distanceFareCode, category, categoryCode, cpCode, cpName, workPlace, fromPlace, toPlace,
travelMode, distance, startTime, endTime, acc1Name, acc1Type, acc1StartTime, acc1EndTime, acc1OnlyDoctor, acc1Mode, acc2Name, acc2Type, acc2StartTime,
acc2EndTime, acc2OnlyDoctor, acc2Mode, acc3Name, acc3Time, acc3OnlyDoctor, acc3Mode, acc4Name, acc4Time, acc4OnlyDoctor, acc4Mode, isrcpa, routeWay, entryMode, activityString,
dcrFlag, tpDeviation, cpDeviation, sfcRegionCode, sfcVersionNo, sfcCategoryName, lattitude, longitude, location, originOfDCR, dcr_Freeze, _obDateDet, ISchecked);
if (result == "SUCCESS")
{
flag = true;
}
return(flag);
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertExpense(string companyCode, string userCode, string dcrCode, string expenseContent,
string dcrDate, string dcrStatus, string dailyAllowance, string dcrFlag, DateCapturingModel _objDateDetails)
{
try
{
bool flag = false;
string result = string.Empty;
result = _objDCRDAL.InsertExpense(companyCode, userCode, dcrCode, dcrDate, dcrStatus, expenseContent, dailyAllowance, dcrFlag, _objDateDetails);
if (result == "SUCCESS")
{
flag = true;
}
return(flag);
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertAllValues(FormCollection collection)
{
DALApproval _objApproval = new DALApproval();
try
{
bool result = true;
string stockiestData = string.Empty, expenseData = string.Empty, dailyAllowance = string.Empty, dcrCode = string.Empty, dcrDate = string.Empty, dcrStatus = string.Empty;
int isSubmit = 0;
string dcrFlag = string.Empty;
string commonRemarks = string.Empty;
string commonRemarksMandatory = string.Empty;
DateCapturingModel _objDateDetails = new DateCapturingModel();
stockiestData = collection["tblStockiestData"].ToString();
expenseData = collection["tblExpenseData"].ToString();
dailyAllowance = collection["dailyAllowance"].ToString();
dcrDate = collection["dcrDate"].ToString();
dcrCode = _objCurr.GetDCRCode(dcrDate);
dcrStatus = collection["dcrStatus"].ToString();
isSubmit = Convert.ToInt32(collection["submit"]);
dcrFlag = collection["flag"].ToString();
commonRemarks = collection["commonRemarks"].ToString();
commonRemarksMandatory = collection["comRemarkMandatory"].ToString();
_objDateDetails = JsonConvert.DeserializeObject <DateCapturingModel>(collection["_objDateDetails"]);
string companyCode = _objCurr.GetCompanyCode();
string userCode = _objCurr.GetUserCode();
if (!(_objDateDetails.Off_Set.Contains('+') && !(_objDateDetails.Off_Set.Contains('-'))))
{
_objDateDetails.Off_Set = '+' + _objDateDetails.Off_Set.Trim();
}
if (dcrFlag != "A")
{
result = _objDCRBL.InsertStockiest(companyCode, userCode, dcrCode, dcrDate, dcrStatus, stockiestData);
}
else
{
result = true;
}
if (result)
{
result = _objDCRBL.InsertExpense(companyCode, userCode, dcrCode, expenseData, dcrDate, dcrStatus, dailyAllowance, dcrFlag, _objDateDetails);
}
if (result)
{
// update product. This block is for save and submit button.
if (isSubmit == 1)
{
result = _objDCRBL.UpdateProductAndStatus(companyCode, userCode, _objCurr.GetUserName(), _objCurr.GetRegionCode(), _objCurr.GetRegionName(),
dcrCode, dcrDate, collection["autoApproval"].ToString(), dcrFlag, _objCurr.GetLattitude(), _objCurr.GetLongitude(), _objCurr.GetLocation());
//try
//{
// IQueueService<DCRQueue> dcrHeaderQueue = new QueueService<DCRQueue>(_queueAccountKey, _topicName, _subscriptionName);
// if (dcrHeaderQueue.Initialize())
// {
// DCRQueue dcrQueue = new DCRQueue();
// dcrQueue.CompanyCode = _objCurr.GetCompanyCode();
// dcrQueue.DCRCode = dcrCode;
// dcrQueue.UserCode = _objCurr.GetUserCode();
// dcrQueue.UserName = _objCurr.GetUserName();
// dcrQueue.DCRDate = dcrDate;
// dcrQueue.ActivityFlag = dcrFlag;
// dcrQueue.DCRStatus = Convert.ToInt32(dcrStatus);
// if (commonRemarksMandatory == "NO")
// {
// dcrQueue.Event = "APPLIED";
// }
// else
// {
// dcrQueue.Event = "REAPPLIED";
// }
// DCRQueueTracker dcrQueueTracker = new DCRQueueTracker();
// dcrQueueTracker.CompanyCode = companyCode;
// dcrQueueTracker.UserCode = _objCurr.GetUserCode();
// dcrQueueTracker.DCRCode = dcrCode;
// dcrQueueTracker.Flag = dcrFlag;
// dcrQueueTracker.TopicName = _topicName;
// dcrQueueTracker.SubscriptionName = _subscriptionName;
// dcrQueueTracker.ProcessStatus = 0;
// dcrQueueTracker.EventName = dcrQueue.Event;
// List<DCRQueue> dcrQueueList = new List<DCRQueue>();
// dcrQueueList.Add(dcrQueue);
// dcrQueueTracker.JSONObject = JsonConvert.SerializeObject(dcrQueueList);
// BL_DCRHeader blDCRHeader = new BL_DCRHeader();
// int Id = blDCRHeader.InsertDCRQueueTracker(_objCurr.GetCompanyCode(), dcrQueueTracker);
// dcrQueueList[0].Id = Id;
// dcrQueueTracker.Id = Id;
// if (!dcrHeaderQueue.CreateQueueItem(dcrQueueList))
// {
// dcrQueueTracker.Mesg = "Queue Failed.";
// dcrQueueTracker.StackTrace = "";
// dcrQueueTracker.ProcessStatus = -1;
// blDCRHeader.UpdateDCRQueueTracker(_objCurr.GetCompanyCode(), dcrQueueTracker);
// }
// }
//}
//catch(Exception ex)
//{
// BL_DCRHeader blDCRHeader = new BL_DCRHeader();
// string eventName = commonRemarksMandatory == "NO" ? "Applied" : "ReApplied";
// blDCRHeader.InsertDCRQueueExceptionLogs(_objCurr.GetCompanyCode(), dcrCode, dcrFlag, userCode, dcrDate, ex.Message, ex.StackTrace, eventName);
//}
//delete dcr temp table records
if (result)
{
result = _objDCRBL.DeleteDCRTempTableRecords(companyCode, dcrCode, dcrFlag);
}
}
}
// update common remarks remarks
if (result)
{
if (commonRemarks != "")
{
result = _objDCRBL.UpdateDCRCommonRemarks(companyCode, dcrCode, dcrFlag, dcrStatus, commonRemarks, isSubmit.ToString(), "1");
}
else
{
result = _objDCRBL.UpdateDCRCommonRemarks(companyCode, dcrCode, dcrFlag, dcrStatus, commonRemarks, isSubmit.ToString(), "0");
}
}
if (isSubmit == 1)
{
result = _objDCRBL.UpdatePOBOrderStatus(companyCode, "-1", "1", "0", _objCurr.GetUserCode(), dcrDate);
}
int result_History = _objApproval.InsertDcrHistory(_objCurr.GetCompanyCode(), dcrCode, dcrFlag);
return(result);
}
catch
{
throw;
}
}
