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