public EXPAgentCommissionBuyerCI SetToBussinessObject(EXP_AgentCommissionBuyerCI Entity) { EXPAgentCommissionBuyerCI Model = new EXPAgentCommissionBuyerCI(); Model.AgentComCIID = Entity.AgentComCIID; Model.AgentComID = Entity.AgentComID; Model.BuyerAgentID = Entity.BuyerAgentID; Model.BuyerAgentName = Entity.BuyerAgentID == null ? "" : _context.Sys_Buyer.Where(m => m.BuyerID == Entity.BuyerAgentID).FirstOrDefault().BuyerName; Model.AgentType = Entity.AgentType; Model.CIID = Entity.CIID; Model.CINo = Entity.CIID == null ? "" : _context.EXP_CI.Where(m => m.CIID == Model.CIID).FirstOrDefault().CIRefNo; Model.PIID = Entity.RefPIID; Model.PINo = Model.PIID == null ? "" : _context.EXP_LeatherPI.Where(m => m.PIID == Model.PIID).FirstOrDefault().PINo; Model.CommissionPercent = Entity.CommissionPercent; Model.CommissionAmount = Entity.CommissionAmount; Model.AITPercent = Entity.AITPercent; Model.AITAmount = Entity.AITAmount; Model.PayableAmount = Entity.PayableAmount; Model.ExchangeCurrency = Entity.ExchangeCurrency; Model.ExchangeCurrencyName = Model.ExchangeCurrency == null ? "" : _context.Sys_Currency.Where(m => m.CurrencyID == Model.ExchangeCurrency).FirstOrDefault().CurrencyName; Model.ExchangeRate = Entity.ExchangeRate; Model.ExchangeAmount = Entity.ExchangeAmount; Model.LocalCurrency = Entity.LocalCurrency; Model.LocalRate = Entity.LocalRate; Model.LocalAmount = Entity.LocalAmount; Model.RecordStatus = Entity.RecordStatus; return(Model); }
public EXP_AgentCommissionBuyerCI SetToModelObject(EXPAgentCommissionBuyerCI model, int userid) { EXP_AgentCommissionBuyerCI Entity = new EXP_AgentCommissionBuyerCI(); Entity.AgentComCIID = model.AgentComCIID; Entity.AgentComID = model.AgentComID; Entity.BuyerAgentID = model.BuyerAgentID; Entity.AgentType = model.AgentType; Entity.CIID = model.CIID; Entity.RefPIID = model.PIID; Entity.CommissionPercent = model.CommissionPercent; Entity.CommissionAmount = model.CommissionAmount; Entity.AITPercent = model.AITPercent; Entity.AITAmount = model.AITAmount; Entity.PayableAmount = model.PayableAmount; if (string.IsNullOrEmpty(model.ExchangeCurrencyName)) { Entity.ExchangeCurrency = null; } else { Entity.ExchangeCurrency = _context.Sys_Currency.Where(m => m.CurrencyName == model.ExchangeCurrencyName).FirstOrDefault().CurrencyID; } Entity.ExchangeRate = model.ExchangeRate; Entity.ExchangeAmount = model.ExchangeAmount; Entity.LocalCurrency = model.LocalCurrency; Entity.LocalRate = model.LocalRate; Entity.LocalAmount = model.LocalAmount; Entity.RecordStatus = "NCF"; Entity.SetOn = DateTime.Now; Entity.SetBy = userid; Entity.IPAddress = GetIPAddress.LocalIPAddress(); return(Entity); }
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); }