public SysBuyer GetBuyerAddressAndAgentList(string buyerId)
{
SysBuyer sysBuyer = new SysBuyer();
IList <SysBuyerAddress> buyerAddressList = new List <SysBuyerAddress>();
IList <SysBuyerAgent> buyerAgentList = new List <SysBuyerAgent>();
var buyerid = string.IsNullOrEmpty(buyerId) ? 0 : Convert.ToInt32(buyerId);
List <Sys_BuyerAddress> searchList = _context.Sys_BuyerAddress.Where(m => m.BuyerID == buyerid).ToList();
foreach (var buyerAddress in searchList)
{
var supaddlist = SetToBussinessObject(buyerAddress);
buyerAddressList.Add(supaddlist);
}
List <Sys_BuyerAgent> buyerAgentEnList = _context.Sys_BuyerAgent.Where(m => m.BuyerID == buyerid).ToList();
foreach (var buyerAgent in buyerAgentEnList)
{
var supAgnt = SetToBussinessObject(buyerAgent);
buyerAgentList.Add(supAgnt);
}
sysBuyer.BuyerAddressList = buyerAddressList;
sysBuyer.BuyerAgentList = buyerAgentList;
return(sysBuyer);
}
public ActionResult GetBuyerList(string buyer)
{
var sysBuyer = new SysBuyer();
var buyerList = _dalSlsBuyerOrder.GetBuyerList(buyer);
sysBuyer.Count = buyerList.Count > 1 ? 0 : 1;
sysBuyer.BuyerList = buyerList;
return(Json(sysBuyer, JsonRequestBehavior.AllowGet));
}
public ActionResult BuyerAgent(SysBuyer model)
{
if (model != null && model.BuyerID != 0)
{
_vmMsg = _dalSysBuyer.Update(model, Convert.ToInt32(Session["UserID"]));
}
else
{
_vmMsg = _dalSysBuyer.Save(model, Convert.ToInt32(Session["UserID"]));
}
return(Json(new { BuyerID = _dalSysBuyer.GetBuyerId(), msg = _vmMsg }));
}
public SysBuyer SetToBussinessObjectBuyerForSearch(Sys_Buyer Entity)
{
SysBuyer Model = new SysBuyer();
Model.BuyerID = Entity.BuyerID;
Model.BuyerCode = Entity.BuyerCode;
Model.BuyerName = Entity.BuyerName;
Model.BuyerCategory = Entity.BuyerCategory;
Model.BuyerType = Entity.BuyerType;
Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive";
return(Model);
}
public SysBuyer SetToBussinessObjectBuyer(Sys_Buyer Entity)
{
SysBuyer Model = new SysBuyer();
Model.BuyerID = Entity.BuyerID;
Model.BuyerCode = Entity.BuyerCode;
Model.BuyerName = Entity.BuyerName;
Model.BuyerCategory = Entity.BuyerCategory;
Model.BuyerType = Entity.BuyerType;
Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive";
Model.Address = _context.Sys_BuyerAddress.Where(q => q.BuyerID == Entity.BuyerID && q.IsActive == true).FirstOrDefault() == null ? null : _context.Sys_BuyerAddress.Where(q => q.BuyerID == Entity.BuyerID && q.IsActive == true).FirstOrDefault().Address;
return(Model);
}
private SysBuyer SetToForeignAgentModel(Sys_Buyer entity)
{
var model = new SysBuyer();
model.BuyerID = entity.BuyerID;
model.BuyerName = entity.BuyerName;
model.BuyerCode = entity.BuyerCode;
model.BuyerAddressID =
_context.Sys_BuyerAddress.FirstOrDefault(ob => ob.BuyerID == entity.BuyerID && ob.IsActive == true)
.BuyerAddressID.ToString(CultureInfo.InvariantCulture);
model.Address =
_context.Sys_BuyerAddress.FirstOrDefault(ob => ob.BuyerID == entity.BuyerID && ob.IsActive == true)
.Address;
return(model);
}
public Sys_Buyer SetToModelObject(SysBuyer model)
{
Sys_Buyer Entity = new Sys_Buyer();
Entity.BuyerID = model.BuyerID;
Entity.BuyerCode = model.BuyerCode;
Entity.BuyerName = model.BuyerName;
Entity.BuyerCategory = model.BuyerCategory;
Entity.BuyerType = model.BuyerType;
Entity.IsActive = model.IsActive == "Active";
Entity.SetOn = DateTime.Now;
Entity.SetBy = model.SetBy;
Entity.IPAddress = string.Empty;
return(Entity);
}
public ActionResult GetBuyerList(string buyer)
{
SysBuyer sysBuyer = new SysBuyer();
var buyerList = _dalSysBuyer.GetBuyerList(buyer);
if (buyerList.Count > 1)
{
sysBuyer.Count = 0;
}
else
{
sysBuyer.Count = 1;
}
sysBuyer.BuyerList = buyerList;
return(Json(sysBuyer, JsonRequestBehavior.AllowGet));
}
public ActionResult GetAllBuyer()
{
var buyers = _unit.SysBuyerRepository.Get().Where(ob => ob.IsActive == true).ToList();
var result = new List <SysBuyer>();
foreach (var buyer in buyers)
{
var x = new SysBuyer();
x.BuyerID = buyer.BuyerID;
x.BuyerCode = buyer.BuyerCode;
x.BuyerName = buyer.BuyerName;
x.BuyerType = buyer.BuyerType;
var add = _unit.BuyerAddressRepository.Get().FirstOrDefault(ob => ob.BuyerID == buyer.BuyerID && ob.IsActive == true);
x.Address = add == null ? "" : add.Address;
result.Add(x);
}
return(Json(result.OrderBy(ob => ob.BuyerName), JsonRequestBehavior.AllowGet));
}
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);
}
