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