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;
}
}
