public SysBuyerAddress SetToBussinessObject(Sys_BuyerAddress Entity)
{
SysBuyerAddress Model = new SysBuyerAddress();
Model.BuyerAddressID = Entity.BuyerAddressID;
Model.BuyerID = Entity.BuyerID;
Model.Address = Entity.Address;
Model.ContactPerson = Entity.ContactPerson;
Model.ContactNumber = Entity.ContactNumber;
Model.EmailAddress = Entity.EmailAddress;
Model.FaxNo = Entity.FaxNo;
Model.PhoneNo = Entity.PhoneNo;
Model.SkypeID = Entity.SkypeID;
Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive";
return(Model);
}
public Sys_BuyerAddress SetToModelObject(SysBuyerAddress model)
{
Sys_BuyerAddress Entity = new Sys_BuyerAddress();
Entity.BuyerAddressID = model.BuyerAddressID;
Entity.BuyerID = model.BuyerID;
Entity.Address = model.Address;
Entity.ContactPerson = model.ContactPerson;
Entity.ContactNumber = model.ContactNumber;
Entity.EmailAddress = model.EmailAddress;
Entity.FaxNo = model.FaxNo;
Entity.PhoneNo = model.PhoneNo;
Entity.SkypeID = model.SkypeID;
Entity.IsActive = model.IsActive == "Active";
Entity.SetOn = DateTime.Now;
Entity.SetBy = model.SetBy;
Entity.IPAddress = string.Empty;
return(Entity);
}
public ValidationMsg Save(SysBuyer model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
var exitBuyerCode = _context.Sys_Buyer.Where(m => m.BuyerCode == model.BuyerCode).ToList();
if (exitBuyerCode.Count > 0)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Buyer Code Already Exit.";
}
else
{
#region Buyer
model.SetBy = userid;
Sys_Buyer tblSysBuyer = SetToModelObject(model);
_context.Sys_Buyer.Add(tblSysBuyer);
_context.SaveChanges();
BuyerID = tblSysBuyer.BuyerID;
#endregion
#region Save Buyer Address
if (model.BuyerAddressList != null)
{
if (model.BuyerAddressList.Count > 1)
{
buyeraddress = 1;
}
else
{
foreach (SysBuyerAddress objSysBuyerAddress in model.BuyerAddressList)
{
objSysBuyerAddress.BuyerID = BuyerID;
objSysBuyerAddress.SetBy = userid;
objSysBuyerAddress.IsActive = string.IsNullOrEmpty(objSysBuyerAddress.IsActive) ? "Active" : objSysBuyerAddress.IsActive;
Sys_BuyerAddress tblBuyerAddress = SetToModelObject(objSysBuyerAddress);
_context.Sys_BuyerAddress.Add(tblBuyerAddress);
}
#region Save Buyer Agent
if (model.BuyerAgentList != null)
{
foreach (SysBuyerAgent objBuyerAgent in model.BuyerAgentList)
{
if (objBuyerAgent.BuyerID != 0)
{
if (objBuyerAgent.AgentType == "Local Agent")
{
++localAgent;
}
else if (objBuyerAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
}
if (localAgent == 1 || foreignAgent == 1)
{
objBuyerAgent.BuyerAgentID = BuyerID;
objBuyerAgent.BuyerID = BuyerID;
objBuyerAgent.SetBy = userid;
objBuyerAgent.IsActive = string.IsNullOrEmpty(objBuyerAgent.IsActive) ? "Active" : objBuyerAgent.IsActive;
Sys_BuyerAgent tblSysBuyerAgent = SetToModelObject(objBuyerAgent);
_context.Sys_BuyerAgent.Add(tblSysBuyerAgent);
}
}
}
}
#endregion
#region Transaction
if (buyeraddress == 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter only one Active Buyer Address.";
}
if (localAgent > 1 || foreignAgent > 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Same Agent Type Only Once.";
}
if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
#endregion
}
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Buyer Address.";
}
#endregion
}
}
}
}
catch
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public ValidationMsg Update(SysBuyer model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
Sys_Buyer CurrentEntity = SetToModelObject(model);
var OriginalEntity = _context.Sys_Buyer.First(m => m.BuyerID == model.BuyerID);
OriginalEntity.BuyerID = CurrentEntity.BuyerID;
OriginalEntity.BuyerCode = CurrentEntity.BuyerCode;
OriginalEntity.BuyerName = CurrentEntity.BuyerName;
OriginalEntity.BuyerCategory = CurrentEntity.BuyerCategory;
OriginalEntity.BuyerType = CurrentEntity.BuyerType;
OriginalEntity.IsActive = CurrentEntity.IsActive;
OriginalEntity.ModifiedBy = userid;
OriginalEntity.ModifiedOn = DateTime.Now;
//#region Save Buyer Address
//if (model.BuyerAddressList != null)
//{
// foreach (SysBuyerAddress objbuyerAddress in model.BuyerAddressList)
// {
// if (objbuyerAddress.BuyerAddressID == 0)
// {
// var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList();
// if (exitData.Count > 0)
// {
// buyeraddress = 1;
// }
// else
// {
// objbuyerAddress.BuyerID = model.BuyerID;
// objbuyerAddress.SetBy = userid;
// objbuyerAddress.IsActive = string.IsNullOrEmpty(objbuyerAddress.IsActive) ? "Active" : objbuyerAddress.IsActive;
// Sys_BuyerAddress tblPurchaseYearPeriod =
// SetToModelObject(objbuyerAddress);
// _context.Sys_BuyerAddress.Add(tblPurchaseYearPeriod);
// _context.SaveChanges();
// }
// }
// else
// {
// if (objbuyerAddress.IsActive == "Inactive")
// {
// Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress);
// var OrgEntity =
// _context.Sys_BuyerAddress.First(
// m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID);
// OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID;
// OrgEntity.BuyerID = CurEntity.BuyerID;
// OrgEntity.Address = CurEntity.Address;
// OrgEntity.ContactPerson = CurEntity.ContactPerson;
// OrgEntity.ContactNumber = CurEntity.ContactNumber;
// OrgEntity.EmailAddress = CurEntity.EmailAddress;
// OrgEntity.FaxNo = CurEntity.FaxNo;
// OrgEntity.PhoneNo = CurEntity.PhoneNo;
// OrgEntity.SkypeID = CurEntity.SkypeID;
// OrgEntity.IsActive = CurEntity.IsActive;
// OrgEntity.ModifiedBy = userid;
// OrgEntity.ModifiedOn = DateTime.Now;
// }
// else
// {
// var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList();
// if (exitData.Count > 0)
// {
// buyeraddress = 1;
// }
// else
// {
// Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress);
// var OrgEntity =
// _context.Sys_BuyerAddress.First(
// m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID);
// OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID;
// OrgEntity.BuyerID = CurEntity.BuyerID;
// OrgEntity.Address = CurEntity.Address;
// OrgEntity.ContactPerson = CurEntity.ContactPerson;
// OrgEntity.ContactNumber = CurEntity.ContactNumber;
// OrgEntity.EmailAddress = CurEntity.EmailAddress;
// OrgEntity.FaxNo = CurEntity.FaxNo;
// OrgEntity.PhoneNo = CurEntity.PhoneNo;
// OrgEntity.SkypeID = CurEntity.SkypeID;
// OrgEntity.IsActive = CurEntity.IsActive;
// OrgEntity.ModifiedBy = userid;
// OrgEntity.ModifiedOn = DateTime.Now;
// }
// }
// }
// }
//}
//#endregion
#region Save Buyer Address
if (model.BuyerAddressList != null)
{
foreach (SysBuyerAddress objbuyerAddress in model.BuyerAddressList)
{
if (objbuyerAddress.BuyerAddressID == 0)
{
var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList();
if (exitData.Count > 0)
{
buyeraddress = 1;
}
else
{
objbuyerAddress.BuyerID = model.BuyerID;
objbuyerAddress.SetBy = userid;
objbuyerAddress.IsActive = string.IsNullOrEmpty(objbuyerAddress.IsActive) ? "Active" : objbuyerAddress.IsActive;
Sys_BuyerAddress tblPurchaseYearPeriod = SetToModelObject(objbuyerAddress);
_context.Sys_BuyerAddress.Add(tblPurchaseYearPeriod);
_context.SaveChanges();
}
}
else
{
if (objbuyerAddress.IsActive == "Inactive")
{
Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress);
var OrgEntity = _context.Sys_BuyerAddress.First(m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID);
OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID;
OrgEntity.BuyerID = CurEntity.BuyerID;
OrgEntity.Address = CurEntity.Address;
OrgEntity.ContactPerson = CurEntity.ContactPerson;
OrgEntity.ContactNumber = CurEntity.ContactNumber;
OrgEntity.EmailAddress = CurEntity.EmailAddress;
OrgEntity.FaxNo = CurEntity.FaxNo;
OrgEntity.PhoneNo = CurEntity.PhoneNo;
OrgEntity.SkypeID = CurEntity.SkypeID;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
else
{
var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList();
if ((exitData.Count > 0) && (model.BuyerAddressList.Count > 1))
//if (exitData.Count > 0)
{
buyeraddress = 1;
}
else
{
Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress);
var OrgEntity = _context.Sys_BuyerAddress.First(m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID);
OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID;
OrgEntity.BuyerID = CurEntity.BuyerID;
OrgEntity.Address = CurEntity.Address;
OrgEntity.ContactPerson = CurEntity.ContactPerson;
OrgEntity.ContactNumber = CurEntity.ContactNumber;
OrgEntity.EmailAddress = CurEntity.EmailAddress;
OrgEntity.FaxNo = CurEntity.FaxNo;
OrgEntity.PhoneNo = CurEntity.PhoneNo;
OrgEntity.SkypeID = CurEntity.SkypeID;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
}
}
}
}
#endregion
#region Save Buyer Agent
if (model.BuyerAgentList != null)
{
foreach (SysBuyerAgent objBuyerAgent in model.BuyerAgentList)
{
if (objBuyerAgent.BuyerAgentID == 0)
{
if (objBuyerAgent.BuyerID != 0)
{
if (objBuyerAgent.AgentType == "Local Agent")
{
++localAgent;
var exitData = _context.Sys_BuyerAgent.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true && m.AgentType == "Local Agent").ToList();
if (exitData.Count > 0)
{
++localAgent;
}
}
else if (objBuyerAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
var exitData = _context.Sys_BuyerAgent.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true && m.AgentType == "Foreign Agent").ToList();
if (exitData.Count > 0)
{
++foreignAgent;
}
}
if (localAgent == 1 || foreignAgent == 1)
{
objBuyerAgent.BuyerID = model.BuyerID;
objBuyerAgent.SetBy = userid;
objBuyerAgent.IsActive = string.IsNullOrEmpty(objBuyerAgent.IsActive) ? "Active" : objBuyerAgent.IsActive;
Sys_BuyerAgent tblSysBuyerAgent = SetToModelObject(objBuyerAgent);
_context.Sys_BuyerAgent.Add(tblSysBuyerAgent);
}
}
}
else
{
if (objBuyerAgent.AgentType == "Local Agent")
{
++localAgent;
}
else if (objBuyerAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
}
if (localAgent == 1 || foreignAgent == 1)
{
Sys_BuyerAgent CurEntity = SetToModelObject(objBuyerAgent);
var OrgEntity =
_context.Sys_BuyerAgent.First(
m => m.BuyerAgentID == objBuyerAgent.BuyerAgentID);
OrgEntity.BuyerAgentID = CurEntity.BuyerAgentID;
OrgEntity.AgentID = CurEntity.AgentID;
OrgEntity.BuyerID = CurEntity.BuyerID;
OrgEntity.AgentType = CurEntity.AgentType;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
}
}
}
#endregion
if (buyeraddress == 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter only one Active Buyer Address.";
}
if (localAgent > 1 || foreignAgent > 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Same Agent Type Only Once.";
}
if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
}
}
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Buyer Code Already Exit..";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Update.";
}
}
return(_vmMsg);
}
