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 ValidationMsg Delete(SysSupplier objSysSupplier)
{
_vmMsg = new ValidationMsg();
try
{
var supplier = _context.Sys_Supplier.FirstOrDefault(s => s.SupplierID == objSysSupplier.SupplierID);
if (supplier != null)
{
supplier.SupplierCode = objSysSupplier.SupplierCode;
supplier.SupplierName = objSysSupplier.SupplierName;
supplier.SupplierCategory = objSysSupplier.SupplierCategory;
supplier.SupplierType = objSysSupplier.SupplierType;
supplier.IsActive = Convert.ToBoolean(objSysSupplier.IsActive);
supplier.ModifiedOn = DateTime.Now;
supplier.ModifiedBy = 27;
supplier.IsDelete = true;
}
_context.SaveChanges();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Record Deleted Successfully.";
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to delete.";
}
return(_vmMsg);
}
public SysSupplier GetSupplierAddressAndAgentList(string supplierId)
{
SysSupplier sysSupplier = new SysSupplier();
IList <SysSupplierAddress> supplierAddressList = new List <SysSupplierAddress>();
IList <SysSupplierAgent> supplierAgentList = new List <SysSupplierAgent>();
var supplierid = string.IsNullOrEmpty(supplierId) ? 0 : Convert.ToInt32(supplierId);
List <Sys_SupplierAddress> searchList = _context.Sys_SupplierAddress.Where(m => m.SupplierID == supplierid && !m.IsDelete).ToList();
foreach (var supplierAddress in searchList)
{
var supaddlist = SetToBussinessObject(supplierAddress);
supplierAddressList.Add(supaddlist);
}
List <Sys_SupplierAgent> supplierAgentEnList = _context.Sys_SupplierAgent.Where(m => m.SupplierID == supplierid && !m.IsDelete).ToList();
foreach (var supplierAgent in supplierAgentEnList)
{
var supAgnt = SetToBussinessObject(supplierAgent);
supplierAgentList.Add(supAgnt);
}
sysSupplier.SupplierAddressList = supplierAddressList;
sysSupplier.SupplierAgentList = supplierAgentList;
return(sysSupplier);
}
public ActionResult GetSupplierList(string storeId, string supplier)
{
SysSupplier sysSupplier = new SysSupplier();
var supplierList = Dalobject.GetSupplierList(supplier, storeId);
sysSupplier.Count = supplierList.Count > 1 ? 0 : 1;
sysSupplier.SupplierList = supplierList;
return(Json(sysSupplier, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBillPaymentListForSearch(string storeId, string supplier)
{
DalInvLeatherIssueItem dalChallan = new DalInvLeatherIssueItem();
SysSupplier model = new SysSupplier();
int storeid = string.IsNullOrEmpty(storeId) ? 0 : Convert.ToInt16(storeId);
model.SupplierList = dalChallan.GetSupplierList(storeid).Where(m => m.SupplierName.StartsWith(supplier)).ToList();
model.Count = model.SupplierList.Count > 1 ? model.Count = 0 : model.Count = 1;
return(Json(model, JsonRequestBehavior.AllowGet));
}
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 ActionResult SupplierAgent(SysSupplier model)
{
if (model != null && model.SupplierID != 0)
{
_vmMsg = _dalSysSupplier.Update(model, Convert.ToInt32(Session["UserID"]));
}
else
{
_vmMsg = _dalSysSupplier.Save(model, Convert.ToInt32(Session["UserID"]));
}
return(Json(new { SupplierID = _dalSysSupplier.GetSupplierId(), SupplierCode = _dalSysSupplier.GetSupplierCode(), msg = _vmMsg }));
}
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 ActionResult GetAllChemicalSupplierList(string supplier)
{
SysSupplier sysSupplier = new SysSupplier();
var supplierList = objDalSysSupplier.GetAllChemicalSupplierList(supplier);
if (supplierList.Count > 1)
{
sysSupplier.Count = 0;
}
else
{
sysSupplier.Count = 1;
}
sysSupplier.ChemicalSupplierList = supplierList;
return Json(sysSupplier, JsonRequestBehavior.AllowGet);
}
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);
}
public ActionResult GetSupplierAgentSearchList(string supplier)
{
SysSupplier sysSupplier = new SysSupplier();
var supplierList = _dalSysSupplier.GetSupplierAgentSearchList(supplier);
if (supplierList.Count > 1)
{
sysSupplier.Count = 0;
}
else
{
sysSupplier.Count = 1;
}
sysSupplier.SupplierAgentList = supplierList;
return(Json(sysSupplier, JsonRequestBehavior.AllowGet));
}
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);
}
