// // GET: /Organogram/Create public ActionResult Create() { ViewBag.Cur_Region_Code = _objcurrentInfo.GetRegionCode(); ViewBag.Cur_User_Code = _objcurrentInfo.GetUserCode(); ViewBag.Lat = _objcurrentInfo.GetLattitude(); ViewBag.Long = _objcurrentInfo.GetLongitude(); return(View()); }
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; } }