public ActionResult ConfirmDeleteSupplier(int PrimaryID)
{
Tbl_FMSupplier supplier = (from a in BOSSDB.Tbl_FMSupplier where a.SupplierID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMSupplier.Remove(supplier);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteSupplier(int PrimaryID)
{
Tbl_FMSupplier supplier = (from a in BOSSDB.Tbl_FMSupplier where a.SupplierID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (supplier != null)
{
confirmDelete = "false";
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveSupplier(SupplierModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var SupplierID = model.SupplierList.SupplierID;
var CompanyName = model.SupplierList.CompanyName;
var ProductServices = model.SupplierList.ProductServices;
var Address = model.SupplierList.Address;
var TaxType = model.SupplierList.TaxType;
//var DTIRegNo = model.SupplierList.DTIRegNo;
//var CDARegistry = model.SupplierList.CDARegistry;
var FaxNo = model.SupplierList.FaxNo;
var TelNo = model.SupplierList.TelNo;
var TIN = model.SupplierList.TIN;
var MFName = model.SupplierList.MFName;
var MFAddress = model.SupplierList.MFAddress;
var MFContactNo = model.SupplierList.MFContactNo;
var AccreNumber = model.SupplierList.AccreNumber;
var AccreDate = model.SupplierList.AccreDate;
var AccreValidity = model.SupplierList.AccreValidUntil;
var AccreApproveBy = model.SupplierList.AccreApproveBy;
var AccreMOA = model.SupplierList.AccreMOA;
CompanyName = GlobalFunction.RemoveSpaces(CompanyName);
Address = GlobalFunction.AutoCaps_RemoveSpaces(Address);
ProductServices = GlobalFunction.RemoveSpaces(ProductServices);
TelNo = GlobalFunction.RemoveSpaces(TelNo);
FaxNo = GlobalFunction.RemoveSpaces(FaxNo);
TIN = GlobalFunction.RemoveSpaces(TIN);
AccreNumber = GlobalFunction.RemoveSpaces(AccreNumber);
AccreApproveBy = GlobalFunction.AutoCaps_RemoveSpaces(AccreApproveBy);
AccreMOA = GlobalFunction.RemoveSpaces(AccreMOA);
MFName = GlobalFunction.AutoCaps_RemoveSpaces(MFName);
MFContactNo = GlobalFunction.RemoveSpaces(MFContactNo);
MFAddress = GlobalFunction.AutoCaps_RemoveSpaces(MFAddress);
List <Tbl_FMSupplier> supplierList = (from a in BOSSDB.Tbl_FMSupplier where (a.AccreNumber == AccreNumber) select a).ToList();
Tbl_FMSupplier supplierRecord = (from a in BOSSDB.Tbl_FMSupplier where a.SupplierID == SupplierID select a).FirstOrDefault();
var save = false;
if (supplierList.Count > 0)
{
foreach (var item in supplierList)
{
if (supplierRecord != null)
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.CompanyName) == GlobalFunction.AutoCaps_RemoveSpaces(CompanyName) && item.SupplierID == supplierRecord.SupplierID) // walang binago
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.CompanyName) != GlobalFunction.AutoCaps_RemoveSpaces(CompanyName) || item.SupplierID == supplierRecord.SupplierID) // may binago pero walang kaparehas
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.CompanyName) == GlobalFunction.AutoCaps_RemoveSpaces(CompanyName)) // may binago pero may kaparehas
{
save = false;
break;
}
}
else
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.CompanyName) != GlobalFunction.AutoCaps_RemoveSpaces(CompanyName)) // for adding
{
save = true;
}
else
{
save = false;
break;
}
}
}
}
else
{
save = true;
}
switch (save)
{
case true:
switch (model.ActionID)
{
case 1:
Tbl_FMSupplier suppliedAdd = new Tbl_FMSupplier();
suppliedAdd.CompanyName = CompanyName;
suppliedAdd.ProductServices = ProductServices;
suppliedAdd.Address = Address;
suppliedAdd.TaxType = TaxType;
//suppliedAdd.DTIRegNo = DTIRegNo;
//suppliedAdd.CDARegistry = CDARegistry;
suppliedAdd.FaxNo = FaxNo;
suppliedAdd.TelNo = TelNo;
suppliedAdd.TIN = TIN;
suppliedAdd.MFName = MFName;
suppliedAdd.MFAddress = MFAddress;
suppliedAdd.MFContactNo = MFContactNo;
suppliedAdd.AccreNumber = AccreNumber;
suppliedAdd.AccreDate = AccreDate;
suppliedAdd.AccreValidUntil = AccreValidity;
suppliedAdd.AccreApproveBy = AccreApproveBy;
suppliedAdd.AccreMOA = AccreMOA;
BOSSDB.Tbl_FMSupplier.Add(suppliedAdd);
BOSSDB.SaveChanges();
isExist = "false";
break;
case 2:
supplierRecord.CompanyName = CompanyName;
supplierRecord.ProductServices = ProductServices;
supplierRecord.Address = Address;
supplierRecord.TaxType = TaxType;
//supplierRecord.DTIRegNo = DTIRegNo;
//supplierRecord.CDARegistry = CDARegistry;
supplierRecord.FaxNo = FaxNo;
supplierRecord.TelNo = TelNo;
supplierRecord.TIN = TIN;
supplierRecord.MFName = MFName;
supplierRecord.MFAddress = MFAddress;
supplierRecord.MFContactNo = MFContactNo;
supplierRecord.AccreNumber = AccreNumber;
supplierRecord.AccreDate = AccreDate;
supplierRecord.AccreValidUntil = AccreValidity;
supplierRecord.AccreApproveBy = AccreApproveBy;
supplierRecord.AccreMOA = AccreMOA;
BOSSDB.Entry(supplierRecord);
BOSSDB.SaveChanges();
isExist = "justUpdate";
break;
}
break;
default:
isExist = "true";
break;
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
