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