public EXPAgentCommission SetToBussinessObject(EXP_CI Entity) { EXPAgentCommission model = new EXPAgentCommission(); model.CIID = Entity.CIID; model.CINo = Entity.CIRefNo; model.CIDate = Convert.ToDateTime(Entity.CIDate).ToString("dd/MM/yyyy"); model.InvoiceCurrency = Entity.CICurrency; model.InvoiceCurrencyName = model.InvoiceCurrency == null ? "" : _context.Sys_Currency.Where(m => m.CurrencyID == model.InvoiceCurrency).FirstOrDefault().CurrencyName; model.CIAmount = Entity.CIAmount; //model.CINo = Entity.CIID == null ? "" : _context.EXP_CI.Where(m => m.CIID == Entity.CIID).FirstOrDefault().CINo; if (_context.EXP_CIPI.Where(m => m.CIID == Entity.CIID).FirstOrDefault() != null) { model.PIID = _context.EXP_CIPI.Where(m => m.CIID == Entity.CIID).FirstOrDefault().PIID;// Entity.PIID; model.PINo = model.PIID == null ? "" : _context.EXP_LeatherPI.Where(m => m.PIID == model.PIID).FirstOrDefault().PINo; model.BuyerOrderID = model.PIID == null ? null : _context.EXP_LeatherPI.Where(m => m.PIID == model.PIID).FirstOrDefault().BuyerOrderID; model.BuyerOrderNo = model.BuyerOrderID == null ? "" : _context.SLS_BuyerOrder.Where(m => m.BuyerOrderID == model.BuyerOrderID).FirstOrDefault().BuyerOrderNo; model.BuyerID = model.BuyerOrderID == null ? null : _context.SLS_BuyerOrder.Where(m => m.BuyerOrderID == model.BuyerOrderID).FirstOrDefault().BuyerID; model.BuyerName = model.BuyerID == null ? "" : _context.Sys_Buyer.Where(m => m.BuyerID == model.BuyerID).FirstOrDefault().BuyerName; } //model.BuyerAgentID = Entity.BuyerAgentID; //model.AgentID = model.BuyerAgentID == null ? null : _context.Sys_BuyerAgent.Where(m => m.BuyerAgentID == model.BuyerAgentID).FirstOrDefault().AgentID; //model.BuyerAgentName = Entity.BuyerAgentID == null ? "" : _context.Sys_Buyer.Where(m => m.BuyerID == Entity.BuyerAgentID).FirstOrDefault().BuyerName; model.RecordStatus = Entity.RecordStatus; return(model); }
public EXP_AgentCommission SetToModelObject(EXPAgentCommission model, int userid) { EXP_AgentCommission Entity = new EXP_AgentCommission(); Entity.AgentComID = model.AgentComID; Entity.AgentComNo = model.AgentComNo; Entity.AgentComDate = DalCommon.SetDate(model.AgentComDate); Entity.AgentComRef = model.AgentComRef; Entity.BuyerID = Convert.ToInt32(model.BuyerID); Entity.CIID = model.CIID; Entity.CIAmount = model.CIAmount; Entity.ComOnAmount = model.ComOnAmount; Entity.CIDate = DalCommon.SetDate(model.CIDate); Entity.InvoiceCurrency = model.InvoiceCurrency; //Entity.LocalCurrency = model.LocalCurrency; Entity.LocalCurrency = _context.Sys_Currency.Where(m => m.CurrencyName == "TK").FirstOrDefault().CurrencyID; Entity.RecordStatus = "NCF"; Entity.SetOn = DateTime.Now; Entity.SetBy = userid; Entity.IPAddress = GetIPAddress.LocalIPAddress(); return(Entity); }
public ActionResult GetAllGridList(string AgentComID) { EXPAgentCommission model = new EXPAgentCommission(); if (string.IsNullOrEmpty(AgentComID)) { return(Json(model, JsonRequestBehavior.AllowGet)); } //model.EXPAgentCommissionBuyerList = Dalobject.GetAgentCommissionBuyerList(AgentComID); //if (model.EXPAgentCommissionBuyerList.Count > 0) model.EXPAgentCommissionBuyerCIList = Dalobject.GetAgentCommissionBuyerCIList(AgentComID); return(Json(model, JsonRequestBehavior.AllowGet)); }
public EXPAgentCommission SetToBussinessObject(EXP_AgentCommission Entity) { EXPAgentCommission model = new EXPAgentCommission(); model.AgentComID = Entity.AgentComID; model.AgentComNo = Entity.AgentComNo; model.AgentComDate = Convert.ToDateTime(Entity.AgentComDate).ToString("dd/MM/yyyy"); model.AgentComRef = Entity.AgentComRef; model.BuyerID = Entity.BuyerID; model.BuyerName = model.BuyerID == null ? "" : _context.Sys_Buyer.Where(m => m.BuyerID == model.BuyerID).FirstOrDefault().BuyerName; model.CIID = Convert.ToInt64(Entity.CIID); model.CINo = Entity.CIID == null ? "" : _context.EXP_CI.Where(m => m.CIID == model.CIID).FirstOrDefault().CIRefNo; model.CIDate = Convert.ToDateTime(Entity.CIDate).ToString("dd/MM/yyyy"); model.InvoiceCurrency = Entity.InvoiceCurrency; model.InvoiceCurrencyName = model.InvoiceCurrency == null ? "" : _context.Sys_Currency.Where(m => m.CurrencyID == model.InvoiceCurrency).FirstOrDefault().CurrencyName; model.CIAmount = Entity.CIAmount; model.ComOnAmount = Entity.ComOnAmount; model.LocalCurrency = Entity.LocalCurrency; model.RecordStatus = Entity.RecordStatus; if (Entity.RecordStatus == "NCF") { model.RecordStatusName = "Not Confirmed"; } else if (Entity.RecordStatus == "CNF") { model.RecordStatusName = "Confirmed"; } else if (Entity.RecordStatus == "CHK") { model.RecordStatusName = "Checked"; } else { model.RecordStatusName = ""; } return(model); }
public ValidationMsg CheckedEXPAgentCommission(EXPAgentCommission model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { var originalEntityCI = _context.EXP_AgentCommission.First(m => m.AgentComID == model.AgentComID); originalEntityCI.RecordStatus = "CHK"; originalEntityCI.ModifiedBy = userid; originalEntityCI.ModifiedOn = DateTime.Now; if (model.EXPAgentCommissionBuyerList.Count > 0) { foreach (EXPAgentCommissionBuyer objEXPAgentCommissionBuyer in model.EXPAgentCommissionBuyerList) { var originalEntityCIPIItem = _context.EXP_AgentCommissionBuyer.First(m => m.AgentComID == objEXPAgentCommissionBuyer.AgentComID && m.BuyerID == objEXPAgentCommissionBuyer.BuyerID); originalEntityCIPIItem.RecordStatus = "CHK"; originalEntityCIPIItem.ModifiedBy = userid; originalEntityCIPIItem.ModifiedOn = DateTime.Now; } } _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Checked Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Checked."; } return(_vmMsg); }
public ActionResult CheckedEXPAgentCommission(EXPAgentCommission model) { _vmMsg = Dalobject.CheckedEXPAgentCommission(model, Convert.ToInt32(Session["UserID"])); return(Json(new { msg = _vmMsg })); }
public ActionResult EXPAgentCommission(EXPAgentCommission model) { _vmMsg = model.AgentComID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "EXPAgentCommission/EXPAgentCommission") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"])); return(Json(new { AgentComID = Dalobject.GetAgentComID(), AgentComNo = Dalobject.GetAgentComNo(), msg = _vmMsg })); }
public ValidationMsg Update(EXPAgentCommission model, int userid) { _vmMsg = new ValidationMsg(); try { #region Update using (var tx = new TransactionScope()) { using (_context) { #region AgentCommission EXP_AgentCommission CurrentEntity = SetToModelObject(model, userid); var OriginalEntity = _context.EXP_AgentCommission.First(m => m.AgentComID == model.AgentComID); OriginalEntity.AgentComRef = CurrentEntity.AgentComRef; OriginalEntity.AgentComDate = CurrentEntity.AgentComDate; //OriginalEntity.AgentComCatg = CurrentEntity.AgentComCatg; //OriginalEntity.BuyerAgentID = CurrentEntity.BuyerAgentID; OriginalEntity.ModifiedBy = userid; OriginalEntity.ModifiedOn = DateTime.Now; #endregion #region AgentCommissionBuyerCI if (model.EXPAgentCommissionBuyerCIList != null) { foreach (EXPAgentCommissionBuyerCI objEXPAgentCommissionBuyerCI in model.EXPAgentCommissionBuyerCIList) { if (objEXPAgentCommissionBuyerCI.AgentComCIID == 0) { objEXPAgentCommissionBuyerCI.AgentComID = model.AgentComID; EXP_AgentCommissionBuyerCI tblEXPAgentCommissionBuyerCI = SetToModelObject(objEXPAgentCommissionBuyerCI, userid); _context.EXP_AgentCommissionBuyerCI.Add(tblEXPAgentCommissionBuyerCI); } else { EXP_AgentCommissionBuyerCI CurEntity = SetToModelObject(objEXPAgentCommissionBuyerCI, userid); var OrgEntity = _context.EXP_AgentCommissionBuyerCI.First(m => m.AgentComCIID == objEXPAgentCommissionBuyerCI.AgentComCIID); OrgEntity.BuyerAgentID = CurEntity.BuyerAgentID; OrgEntity.CIID = CurEntity.CIID; OrgEntity.RefPIID = CurEntity.RefPIID; OrgEntity.CommissionPercent = CurEntity.CommissionPercent; OrgEntity.CommissionAmount = CurEntity.CommissionAmount; OrgEntity.ExchangeCurrency = CurEntity.ExchangeCurrency; OrgEntity.ExchangeRate = CurEntity.ExchangeRate; OrgEntity.ExchangeAmount = CurEntity.ExchangeAmount; OrgEntity.LocalCurrency = CurEntity.LocalCurrency; OrgEntity.LocalRate = CurEntity.LocalRate; OrgEntity.LocalAmount = CurEntity.LocalAmount; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } } } #endregion _context.SaveChanges(); tx.Complete(); AgentComID = model.AgentComID; AgentComNo = model.AgentComNo; _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } #endregion } catch (Exception ex) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommission_AgentComNo")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Agent Com. No Already Exist."; } if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommissionBuyerCI_BuyerAgentID_CIID")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Same Agent Already Exist."; } } return(_vmMsg); }
public ValidationMsg Save(EXPAgentCommission model, int userid, string pageUrl) { _vmMsg = new ValidationMsg(); try { #region Save using (var tx = new TransactionScope()) { using (_context) { model.AgentComNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045"); if (model.AgentComNo != null) { #region AgentCommission EXP_AgentCommission tblEXPAgentCommission = SetToModelObject(model, userid); _context.EXP_AgentCommission.Add(tblEXPAgentCommission); _context.SaveChanges(); #endregion #region CIPIItemColor if (model.EXPAgentCommissionBuyerCIList != null) { foreach (EXPAgentCommissionBuyerCI objEXPAgentCommissionBuyerCI in model.EXPAgentCommissionBuyerCIList) { objEXPAgentCommissionBuyerCI.AgentComID = tblEXPAgentCommission.AgentComID; objEXPAgentCommissionBuyerCI.LocalCurrency = model.LocalCurrency; EXP_AgentCommissionBuyerCI tblEXPAgentCommissionBuyerCI = SetToModelObject(objEXPAgentCommissionBuyerCI, userid); _context.EXP_AgentCommissionBuyerCI.Add(tblEXPAgentCommissionBuyerCI); } } #endregion _context.SaveChanges(); tx.Complete(); AgentComID = tblEXPAgentCommission.AgentComID; AgentComNo = model.AgentComNo; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "AgentComNo Predefine Value not Found."; } } } #endregion } catch (Exception ex) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommission_AgentComNo")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Agent Com. No Already Exist."; } if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommissionBuyerCI_BuyerAgentID_CIID")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Same Agent Already Exist."; } } return(_vmMsg); }