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 List <EXPAgentCommissionBuyerCI> GetBuyerAgentList(string CIID, string CIAmount) { var agentList = new List <EXPAgentCommissionBuyerCI>(); var query = @"select p.LocalAgent,(select BuyerName from Sys_Buyer where BuyerID = p.LocalAgent)LocalAgentName, p.ForeignAgent,(select BuyerName from Sys_Buyer where BuyerID = p.ForeignAgent)ForeignAgentName, (select BuyerType from Sys_Buyer where BuyerID = p.LocalAgent)LocalAgentType, (select BuyerType from Sys_Buyer where BuyerID = p.ForeignAgent)ForeignAgentType, p.LocalComPercent,p.ForeignComPercent,p.PIID,p.PINo from EXP_CIPI c inner join EXP_LeatherPI p on c.PIID = p.PIID where CIID=" + CIID + ""; var allData = _context.Database.SqlQuery <EXPAgentCommissionBuyerCI>(query).ToList(); foreach (var obj in allData) { var objlocAgent = new EXPAgentCommissionBuyerCI(); if (obj.LocalAgent != null) { objlocAgent.BuyerAgentID = obj.LocalAgent; objlocAgent.BuyerAgentName = obj.LocalAgentName; objlocAgent.CommissionPercent = obj.LocalComPercent; if (obj.LocalAgentType == "Local Agent") { objlocAgent.AgentType = obj.LocalAgentType; if ((obj.LocalComPercent != null) && (!string.IsNullOrEmpty(CIAmount))) { decimal cIAmount = Convert.ToDecimal(CIAmount); objlocAgent.CommissionAmount = (obj.LocalComPercent * cIAmount) / 100; } } objlocAgent.PIID = obj.PIID; objlocAgent.PINo = obj.PINo; objlocAgent.ExchangeCurrencyName = ""; agentList.Add(objlocAgent); } var objForAgent = new EXPAgentCommissionBuyerCI(); if (obj.ForeignAgent != null) { objForAgent.BuyerAgentID = obj.ForeignAgent; objForAgent.BuyerAgentName = obj.ForeignAgentName; objForAgent.CommissionPercent = obj.ForeignComPercent; if (obj.ForeignAgentType == "Foreign Agent") { objForAgent.AgentType = obj.ForeignAgentType; if ((obj.ForeignComPercent != null) && (!string.IsNullOrEmpty(CIAmount))) { decimal cIAmount = Convert.ToDecimal(CIAmount); objForAgent.CommissionAmount = (obj.ForeignComPercent * cIAmount) / 100; } } objForAgent.PIID = obj.PIID; objForAgent.PINo = obj.PINo; objForAgent.ExchangeCurrencyName = ""; agentList.Add(objForAgent); } } return(agentList); }