//Delete Signature Table public ActionResult DeleteSupplier(FM_Supplier model, int SupplierID) { Supplier tblSupplier = (from e in TOSSDB.Suppliers where e.SupplierID == SupplierID select e).FirstOrDefault(); TOSSDB.Suppliers.Remove(tblSupplier); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
//Tax Table Partial View public ActionResult Get_SupplierTable() { FM_Supplier model = new FM_Supplier(); List <SupplierList> tbl_Supplier = new List <SupplierList>(); var SQLQuery = "SELECT SupplierID,CompanyName,ProductServices,Address,TaxType,DTIRegNo,CDARegistry,FaxNo,TelNo,TIN,MFName,[MFAddress],[MFContactNo],[AccreNumber],[AccreDate],[AccreValidity],[AccreApproveBy],[AccreMOA] FROM [DB_TOSS].[dbo].[Supplier]"; //SQLQuery += " WHERE (IsActive != 0)"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_PositionList]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { tbl_Supplier.Add(new SupplierList() { SupplierID = GlobalFunction.ReturnEmptyInt(dr[0]), CompanyName = GlobalFunction.ReturnEmptyString(dr[1]), ProductServices = GlobalFunction.ReturnEmptyString(dr[2]), Address = GlobalFunction.ReturnEmptyString(dr[3]), TaxType = GlobalFunction.ReturnEmptyString(dr[4]), DTIRegNo = GlobalFunction.ReturnEmptyString(dr[5]), CDARegistry = GlobalFunction.ReturnEmptyString(dr[6]), FaxNo = GlobalFunction.ReturnEmptyString(dr[7]), TelNo = GlobalFunction.ReturnEmptyString(dr[8]), TIN = GlobalFunction.ReturnEmptyString(dr[9]), MFName = GlobalFunction.ReturnEmptyString(dr[10]), MFAddress = GlobalFunction.ReturnEmptyString(dr[11]), MFContactNo = GlobalFunction.ReturnEmptyString(dr[12]), AccreNumber = GlobalFunction.ReturnEmptyString(dr[13]), AccreDate = GlobalFunction.ReturnEmptyString(dr[14]), AccreValidity = GlobalFunction.ReturnEmptyString(dr[15]), AccreApprovedBy = GlobalFunction.ReturnEmptyString(dr[16]), AccreMOA = GlobalFunction.ReturnEmptyString(dr[17]), }); } } Connection.Close(); } model.getSupplierList = tbl_Supplier.ToList(); return(PartialView("_SupplierTable", model.getSupplierList)); }
public ActionResult Get_UpdateSupplier(FM_Supplier model, int SupplierID) { Supplier tblSupplier = (from e in TOSSDB.Suppliers where e.SupplierID == SupplierID select e).FirstOrDefault(); model.getSuppliercolumns.SupplierID = tblSupplier.SupplierID; model.getSuppliercolumns.CompanyName = tblSupplier.CompanyName; model.getSuppliercolumns.ProductServices = tblSupplier.ProductServices; model.getSuppliercolumns.Address = tblSupplier.Address; model.TaxType = tblSupplier.TaxType; model.getSuppliercolumns.FaxNo = tblSupplier.FaxNo; model.getSuppliercolumns.TelNo = tblSupplier.TelNo; model.getSuppliercolumns.TIN = tblSupplier.TIN; model.getSuppliercolumns.MFName = tblSupplier.MFName; model.getSuppliercolumns.MFAddress = tblSupplier.MFAddress; model.getSuppliercolumns.MFContactNo = tblSupplier.MFContactNo; model.getSuppliercolumns.AccreNumber = tblSupplier.AccreNumber; model.getSuppliercolumns.AccreDate = tblSupplier.AccreDate; model.getSuppliercolumns.AccreValidity = tblSupplier.AccreValidity; model.getSuppliercolumns.AccreApproveBy = tblSupplier.AccreApproveBy; model.getSuppliercolumns.AccreMOA = tblSupplier.AccreMOA; return(PartialView("_UpdateSupplier", model)); }
//Add Tax public JsonResult AddSupplier(FM_Supplier model) { Supplier tblSupplier = new Supplier(); tblSupplier.CompanyName = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.CompanyName); tblSupplier.ProductServices = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.ProductServices); tblSupplier.Address = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.Address); tblSupplier.TaxType = GlobalFunction.ReturnEmptyString(model.TaxType); tblSupplier.FaxNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.FaxNo); tblSupplier.TelNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.TelNo); tblSupplier.TIN = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.TIN); tblSupplier.MFName = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFName); tblSupplier.MFAddress = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFAddress); tblSupplier.MFContactNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFContactNo); tblSupplier.AccreNumber = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreNumber); tblSupplier.AccreDate = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreDate); tblSupplier.AccreValidity = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreValidity); tblSupplier.AccreApproveBy = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreApproveBy); tblSupplier.AccreMOA = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreMOA); TOSSDB.Suppliers.Add(tblSupplier); TOSSDB.SaveChanges(); return(Json(tblSupplier)); }
//Update Signature Data public ActionResult UpdateSupplier(FM_Supplier model) { Supplier tblSupplier = (from e in TOSSDB.Suppliers where e.SupplierID == model.getSuppliercolumns.SupplierID select e).FirstOrDefault(); tblSupplier.CompanyName = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.CompanyName); tblSupplier.ProductServices = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.ProductServices); tblSupplier.Address = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.Address); tblSupplier.TaxType = GlobalFunction.ReturnEmptyString(model.TaxType); tblSupplier.FaxNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.FaxNo); tblSupplier.TelNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.TelNo); tblSupplier.TIN = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.TIN); tblSupplier.MFName = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFName); tblSupplier.MFAddress = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFAddress); tblSupplier.MFContactNo = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.MFContactNo); tblSupplier.AccreNumber = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreNumber); tblSupplier.AccreDate = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreDate); tblSupplier.AccreValidity = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreValidity); tblSupplier.AccreApproveBy = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreApproveBy); tblSupplier.AccreMOA = GlobalFunction.ReturnEmptyString(model.getSuppliercolumns.AccreMOA); TOSSDB.Entry(tblSupplier); TOSSDB.SaveChanges(); return(PartialView("_UpdateSupplier", model)); }
//Supplier Add Partial View public ActionResult Get_AddSupplier() { FM_Supplier model = new FM_Supplier(); return(PartialView("_AddSupplier", model)); }