public static List<Supplier> GetAll(Supplier srchSupplier, string executedBy) { List<Supplier> cusList = null; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Supplier_GetAll); db.AddInParameter(cmd, "IsActive", DbType.Boolean, srchSupplier.IsActive); db.AddInParameter(cmd, "SupplierName", DbType.String, srchSupplier.SupplierName); db.AddInParameter(cmd, "AddresssLine1", DbType.String, srchSupplier.AddresssLine1); DataSet ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { cusList = Utility.DataTableToCollection<Supplier>(ds.Tables[0]); } } catch (Exception ex) { cusList = null; } return cusList; }
// // GET: /Supplier/ public ActionResult Index() { Supplier srchSupplier = new Supplier() { SupplierName = "", AddresssLine1 = "", IsActive = true }; List<Supplier> supList = SupplierManager.GetAllSupplier(srchSupplier, "nirshan"); List<SupplierModel> supplierList = Utility.ConvetrToList<SupplierModel, Supplier>(supList); return View(supplierList); }
public ActionResult Index(string SupplierName = "", string AddresssLine1 = "") { //get the non property checkbox value , find a more suitable way later bool bIsActive = Request.Form.GetValues("active") != null && Request.Form.GetValues("active")[0] != null ? true : false; Supplier srchSupplier = new Supplier() { SupplierName = SupplierName, AddresssLine1 = AddresssLine1, IsActive = bIsActive }; List<Supplier> supList = SupplierManager.GetAllSupplier(srchSupplier, "nirshan"); List<SupplierModel> supplierList = Utility.ConvetrToList<SupplierModel, Supplier>(supList); return View(supplierList); }
public static bool UpdateSupplier(Supplier supplier, string executedBy) { return SupplierDAO.Update(supplier, executedBy); }
public static List<Supplier> GetAllSupplier(Supplier srchSupplier, string executedBy) { return SupplierDAO.GetAll(srchSupplier, executedBy); }
public static bool AddSupplier(Supplier supplier, string executedBy) { return SupplierDAO.Insert(supplier, executedBy); }
public static bool Update(Supplier supplier, string executedBy) { bool rslt = false; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Supplier_Update); db.AddInParameter(cmd, "SupplierID", DbType.String, supplier.SupplierID); db.AddInParameter(cmd, "SupplierName", DbType.String, supplier.SupplierName); db.AddInParameter(cmd, "AddresssLine1", DbType.String, supplier.AddresssLine1); db.AddInParameter(cmd, "AddresssLine2", DbType.String, supplier.AddresssLine2); db.AddInParameter(cmd, "AddresssLine3", DbType.String, supplier.AddresssLine3); db.AddInParameter(cmd, "Telephone", DbType.String, supplier.Telephone); db.AddInParameter(cmd, "Email", DbType.String, supplier.Email); db.AddInParameter(cmd, "IsActive", DbType.Boolean, supplier.IsActive); db.AddInParameter(cmd, "UpdatedBY", DbType.Int32, supplier.UpdatedBY); db.ExecuteNonQuery(cmd); rslt = true; } catch (Exception ex) { rslt = false; } return rslt; }
public static bool Insert(Supplier supplier, string executedBy) { bool rslt = false; try { Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection); DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Supplier_Insert); db.AddInParameter(cmd, "SupplierName", DbType.String, supplier.SupplierName); db.AddInParameter(cmd, "AddresssLine1", DbType.String, supplier.AddresssLine1); db.AddInParameter(cmd, "AddresssLine2", DbType.String, supplier.AddresssLine2); db.AddInParameter(cmd, "AddresssLine3", DbType.String, supplier.AddresssLine3); db.AddInParameter(cmd, "Telephone", DbType.String, supplier.Telephone); db.AddInParameter(cmd, "Email", DbType.String, supplier.Email); db.AddInParameter(cmd, "IsActive", DbType.Boolean, supplier.IsActive); db.AddInParameter(cmd, "CreatedBy", DbType.Int32, 1); db.AddOutParameter(cmd, "NewID", DbType.Int32, 4); db.ExecuteNonQuery(cmd); int newID = 0; int.TryParse(db.GetParameterValue(cmd, "NewID").ToString(), out newID); if (newID > 0) rslt = true; } catch (Exception ex) { rslt = false; } return rslt; }