public SysSupplier SetToBussinessObjectSupplier(Sys_Supplier Entity)
{
SysSupplier Model = new SysSupplier();
Model.SupplierID = Entity.SupplierID;
Model.SupplierCode = Entity.SupplierCode;
Model.SupplierName = Entity.SupplierName;
Model.SupplierCategory = Entity.SupplierCategory;
Model.SupplierType = Entity.SupplierType;
Model.CountryID = Entity.CountryID;
Model.CountryName = Entity.CountryID == null
? ""
: _context.Sys_Country.Where(m => m.CountryID == Entity.CountryID).FirstOrDefault().CountryName;
Model.IsActive = Entity.IsActive ? "Active" : "Inactive";
var abc =
_context.Sys_SupplierAddress.Where(
q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false))
.FirstOrDefault();
if (abc != null)
{
Model.SupplierAddressID = _context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault().SupplierAddressID;
Model.Address = _context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault().Address;
}
return(Model);
}
public SysSupplier SetToBussinessObject(Sys_Supplier Entity)
{
SysSupplier Model = new SysSupplier();
Model.SupplierID = Entity.SupplierID;
Model.SupplierCode = Entity.SupplierCode;
Model.SupplierName = Entity.SupplierName;
return(Model);
}
public SysSupplierAgent SetToBussinessObject(Sys_Supplier Entity)
{
SysSupplierAgent Model = new SysSupplierAgent();
Model.SupplierID = Entity.SupplierID;
Model.SupplierName = Entity.SupplierName;
Model.SupplierCode = Entity.SupplierCode;
Model.AgentType = Entity.SupplierType;
Model.IsActive = Entity.IsActive ? "Active" : "Inactive";
return(Model);
}
public SysSupplier SetToBussinessObjectSupplierForSearch(Sys_Supplier Entity)
{
SysSupplier Model = new SysSupplier();
//Model.SupplierID = Entity.SupplierID;
//Model.SupplierCode = Entity.SupplierCode;
Model.SupplierName = Entity.SupplierName;
//Model.SupplierCategory = Entity.SupplierCategory;
//Model.SupplierType = Entity.SupplierType;
//Model.IsActive = Entity.IsActive ? "Active" : "Inactive";
return(Model);
}
public SupplierDetails SetToBussinessObject(Sys_Supplier Entity)
{
SupplierDetails Model = new SupplierDetails();
Model.SupplierID = Entity.SupplierID;
Model.SupplierCode = Entity.SupplierCode;
if (_context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault() != null)
{
Model.SupplierAddressID = _context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault().SupplierAddressID.ToString();
Model.Address = _context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault().Address;
}
Model.SupplierName = Entity.SupplierName;
return(Model);
}
public Sys_Supplier SetToModelObject(SysSupplier model)
{
Sys_Supplier Entity = new Sys_Supplier();
Entity.SupplierID = model.SupplierID;
Entity.SupplierCode = model.SupplierCode;
Entity.SupplierName = model.SupplierName;
Entity.SupplierCategory = model.SupplierCategory;
Entity.SupplierType = model.SupplierType;
Entity.CountryID = model.CountryID;
Entity.IsActive = model.IsActive == "Active";
Entity.IsDelete = false;
Entity.SetOn = DateTime.Now;
Entity.SetBy = model.SetBy;
Entity.IPAddress = string.Empty;
return(Entity);
}
private SupplierDetails SetToSupplierModel(Sys_Supplier entity)
{
var model = new SupplierDetails();
model.SupplierID = entity.SupplierID;
model.SupplierCode = entity.SupplierCode;
model.SupplierName = entity.SupplierName;
var address = _context.Sys_SupplierAddress.FirstOrDefault(
ob => ob.SupplierID == entity.SupplierID && ob.IsActive && ob.IsDelete == false);
if (address != null)
{
model.SupplierAddressID = address.SupplierAddressID.ToString();
model.Address = address.Address;
model.ContactPerson = address.ContactPerson;
model.ContactNumber = model.ContactNumber;
}
return(model);
}
public String GetSupplierBySupplierId(int id)
{
Sys_Supplier data = (from temp in _context.Sys_Supplier where temp.SupplierID == id select temp).FirstOrDefault();
return(data.SupplierName);
}
public ValidationMsg Save(SysSupplier model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
//var exitSupplierCode = _context.Sys_Supplier.Where(m => m.SupplierCode == model.SupplierCode).ToList();
//if (exitSupplierCode.Count > 0)
//{
// _vmMsg.Type = Enums.MessageType.Error;
// _vmMsg.Msg = "Supplier Code Already Exit.";
//}
//else
//{
#region Supplier
model.SupplierCode = DalCommon.GetPreDefineNextCodeByUrl("Supplier/Supplier");//DalCommon.GetPreDefineValue("1", "00045");
model.SetBy = userid;
Sys_Supplier tblSysSupplier = SetToModelObject(model);
_context.Sys_Supplier.Add(tblSysSupplier);
_context.SaveChanges();
SupplierID = tblSysSupplier.SupplierID;
#endregion
#region Save Supplier Address
if (model.SupplierAddressList != null)
{
if (model.SupplierAddressList.Count > 1)
{
supplieraddress = 1;
}
else
{
foreach (SysSupplierAddress objSysSupplierAddress in model.SupplierAddressList)
{
objSysSupplierAddress.SupplierID = SupplierID;
objSysSupplierAddress.SetBy = userid;
objSysSupplierAddress.IsActive = string.IsNullOrEmpty(objSysSupplierAddress.IsActive) ? "Active" : objSysSupplierAddress.IsActive;
Sys_SupplierAddress tblSupplierAddress = SetToModelObject(objSysSupplierAddress);
_context.Sys_SupplierAddress.Add(tblSupplierAddress);
}
#region Save Supplier Agent
if (model.SupplierAgentList != null)
{
foreach (SysSupplierAgent objSupplierAgent in model.SupplierAgentList)
{
if (objSupplierAgent.SupplierID != 0)
{
if (objSupplierAgent.AgentType == "Local Agent")
{
++localAgent;
}
else if (objSupplierAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
}
if (localAgent == 1 || foreignAgent == 1)
{
objSupplierAgent.SupplierAgentID = SupplierID;
objSupplierAgent.SupplierID = SupplierID;
objSupplierAgent.SetBy = userid;
objSupplierAgent.IsActive = string.IsNullOrEmpty(objSupplierAgent.IsActive) ? "Active" : objSupplierAgent.IsActive;
Sys_SupplierAgent tblSysSupplierAgent = SetToModelObject(objSupplierAgent);
_context.Sys_SupplierAgent.Add(tblSysSupplierAgent);
}
}
}
}
#endregion
#region Transaction
if (supplieraddress == 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter only one Active Supplier Address.";
}
if (localAgent > 1 || foreignAgent > 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Same Agent Type Only Once.";
}
if (supplieraddress == 0 && localAgent == 1 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
SupplierCode = model.SupplierCode;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (supplieraddress == 0 && localAgent == 0 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
SupplierCode = model.SupplierCode;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (supplieraddress == 0 && localAgent == 1 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
SupplierCode = model.SupplierCode;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
if (supplieraddress == 0 && localAgent == 0 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
SupplierCode = model.SupplierCode;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
#endregion
}
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Supplier Address.";
}
#endregion
//}
}
}
}
catch
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public ValidationMsg Update(SysSupplier model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
Sys_Supplier CurrentEntity = SetToModelObject(model);
var OriginalEntity = _context.Sys_Supplier.First(m => m.SupplierID == model.SupplierID);
OriginalEntity.SupplierID = CurrentEntity.SupplierID;
OriginalEntity.SupplierCode = CurrentEntity.SupplierCode;
OriginalEntity.SupplierName = CurrentEntity.SupplierName;
OriginalEntity.SupplierCategory = CurrentEntity.SupplierCategory;
OriginalEntity.SupplierType = CurrentEntity.SupplierType;
OriginalEntity.IsActive = CurrentEntity.IsActive;
OriginalEntity.ModifiedBy = userid;
OriginalEntity.ModifiedOn = DateTime.Now;
#region Save Supplier Address
if (model.SupplierAddressList != null)
{
foreach (SysSupplierAddress objsupplierAddress in model.SupplierAddressList)
{
if (objsupplierAddress.SupplierAddressID == 0)
{
var exitData = _context.Sys_SupplierAddress.Where(m => m.SupplierID == model.SupplierID && !m.IsDelete && m.IsActive).ToList();
if (exitData.Count > 0)
{
supplieraddress = 1;
}
else
{
objsupplierAddress.SupplierID = model.SupplierID;
objsupplierAddress.SetBy = userid;
objsupplierAddress.IsActive = string.IsNullOrEmpty(objsupplierAddress.IsActive) ? "Active" : objsupplierAddress.IsActive;
Sys_SupplierAddress tblPurchaseYearPeriod =
SetToModelObject(objsupplierAddress);
_context.Sys_SupplierAddress.Add(tblPurchaseYearPeriod);
_context.SaveChanges();
}
}
else
{
if (objsupplierAddress.IsActive == "Inactive")
{
Sys_SupplierAddress CurEntity = SetToModelObject(objsupplierAddress);
var OrgEntity = _context.Sys_SupplierAddress.First(m => m.SupplierAddressID == objsupplierAddress.SupplierAddressID);
OrgEntity.SupplierAddressID = CurEntity.SupplierAddressID;
OrgEntity.SupplierID = CurEntity.SupplierID;
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.Website = CurEntity.Website;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
else
{
var exitData = _context.Sys_SupplierAddress.Where(m => m.SupplierID == model.SupplierID && !m.IsDelete && m.IsActive).ToList();
if ((exitData.Count > 0) && (model.SupplierAddressList.Count > 1))
{
supplieraddress = 1;
}
else
{
Sys_SupplierAddress CurEntity = SetToModelObject(objsupplierAddress);
var OrgEntity =
_context.Sys_SupplierAddress.First(
m => m.SupplierAddressID == objsupplierAddress.SupplierAddressID);
OrgEntity.SupplierAddressID = CurEntity.SupplierAddressID;
OrgEntity.SupplierID = CurEntity.SupplierID;
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.Website = CurEntity.Website;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
}
}
}
}
#endregion
#region Save Supplier Agent
if (model.SupplierAgentList != null)
{
foreach (SysSupplierAgent objSupplierAgent in model.SupplierAgentList)
{
if (objSupplierAgent.SupplierAgentID == 0)
{
if (objSupplierAgent.SupplierID != 0)
{
if (objSupplierAgent.AgentType == "Local Agent")
{
++localAgent;
var exitData = _context.Sys_SupplierAgent.Where(m => m.SupplierID == model.SupplierID && !m.IsDelete && m.IsActive && m.AgentType == "Local Agent").ToList();
if (exitData.Count > 0)
{
++localAgent;
}
}
else if (objSupplierAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
var exitData = _context.Sys_SupplierAgent.Where(m => m.SupplierID == model.SupplierID && !m.IsDelete && m.IsActive && m.AgentType == "Foreign Agent").ToList();
if (exitData.Count > 0)
{
++foreignAgent;
}
}
if (localAgent == 1 || foreignAgent == 1)
{
objSupplierAgent.SupplierID = model.SupplierID;
objSupplierAgent.SetBy = userid;
objSupplierAgent.IsActive = string.IsNullOrEmpty(objSupplierAgent.IsActive) ? "Active" : objSupplierAgent.IsActive;
Sys_SupplierAgent tblSysSupplierAgent = SetToModelObject(objSupplierAgent);
_context.Sys_SupplierAgent.Add(tblSysSupplierAgent);
}
}
}
else
{
if (objSupplierAgent.AgentType == "Local Agent")
{
++localAgent;
}
else if (objSupplierAgent.AgentType == "Foreign Agent")
{
++foreignAgent;
}
if (localAgent == 1 || foreignAgent == 1)
{
Sys_SupplierAgent CurEntity = SetToModelObject(objSupplierAgent);
var OrgEntity =
_context.Sys_SupplierAgent.First(
m => m.SupplierAgentID == objSupplierAgent.SupplierAgentID);
OrgEntity.SupplierAgentID = CurEntity.SupplierAgentID;
OrgEntity.AgentID = CurEntity.AgentID;
OrgEntity.SupplierID = CurEntity.SupplierID;
OrgEntity.AgentType = CurEntity.AgentType;
OrgEntity.IsActive = CurEntity.IsActive;
OrgEntity.ModifiedBy = userid;
OrgEntity.ModifiedOn = DateTime.Now;
}
}
}
}
#endregion
if (supplieraddress == 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter only one Active Supplier Address.";
}
if (localAgent > 1 || foreignAgent > 1)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Please Enter Same Agent Type Only Once.";
}
if (supplieraddress == 0 && localAgent == 1 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (supplieraddress == 0 && localAgent == 0 && foreignAgent == 1)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (supplieraddress == 0 && localAgent == 1 && foreignAgent == 0)
{
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
if (supplieraddress == 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 = "HSCode Already Exit..";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Update.";
}
}
return(_vmMsg);
}
