public int SAVEFOREDIT() { object Id = 0; object[,] Parameters = new object[, ] { { "@TransactionDate ", TransactionDate }, { "@VoucherNumber", VoucherNumber }, { "@TransactionType", TransactionType }, { "@PartyName ", PartyName }, { "@Mob", Mob }, { "@Address1", Address1 }, { "@TotalGross ", TotalGross }, { "@TotalDiscount", TotalDiscount }, { "@GrandTotal", GrandTotal }, { "@PaidAmount", PaidAmount } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("SaveMasterDetailsForEdit", Parameters); return(Convert.ToInt32(Id)); }
public void Setisactiveornot() { object Id = 0; object[,] Parameters = new object[, ] { { "@InvTransactionMasterID", InvTransactionMasterID } }; DBActions db = new General.DBActions(); db.ExecuteScalar("Setisactiveornot", Parameters); }
public int Delete() { object Id = 0; object[,] Parameters = new object[, ] { { "@ID", UserID } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("DeleteUsersByID", Parameters); return((int)Id); }
public int Save() { object Id = 0; object[,] Parameters = new object[, ] { { "@GroupName", GroupName } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("InsertProductGroup", Parameters); return(Convert.ToInt32(Id)); }
public int Delete() { object Id = 0; object[,] Parameters = new object[, ] { { "@ID", ProductGroupID } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("DeleteProductGroup", Parameters); return(Convert.ToInt32(Id)); }
public int Edit() { object Id = 0; object[,] Parameters = new object[, ] { { "@ID", UserID }, { "@UserName", UserName }, { "@Passwd", Passwd }, { "@UserType", UserType } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("UpdateUsers", Parameters); return(( int)Id); }
public int Save() { object Id = 0; // Do save function object[,] Parameters = new object[, ] { { "@UserName", UserName }, { "@Passwd", Passwd }, { "@UserType", UserType } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("InsertUser", Parameters); return((int)Id); }
public int UpdateStockInProduts() { object Id = 0; object[,] Parameters = new object[, ] { { "@ID", ProductID }, { "@Stockin", StockIn }, { "@StockOut", StockOut } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("UpdateStockInProducts", Parameters); return(Convert.ToInt32(Id)); }
public int Edit() { object Id = 0; object[,] Parameters = new object[, ] { { "@ID", ProductID }, { "@ProductCode", ProductCode }, { "@ProductName", ProductName }, { "@ManualBarcode", ManualBarcode }, { "@ProductGroupID", ProductGroupID }, { "@PurchasePrice", PurchasePrice }, { "@SalePrice", SalePrice }, { "@Stock", Stock } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("UpdateProducts", Parameters); return(Convert.ToInt32(Id)); }
public int Save() { object Id = 0; object[,] Parameters = new object[, ] { { "@TransactionDate ", TransactionDate }, { "@TransactionType", TransactionType }, { "@PartyName ", PartyName }, { "@Mob", Mob }, { "@Address1", Address1 }, { "@TotalGross ", TotalGross }, { "@TotalDiscount", TotalDiscount }, { "@GrandTotal", GrandTotal }, { "@PaidAmount", PaidAmount } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("InserItnvTransactionMaster", Parameters); return(Convert.ToInt32(Id)); }
public int Save() { object Id = 0; object[,] Parameters = new object[, ] { { "@InvTransactionMasterID", InvTransactionMasterID }, { "@ProductID ", ProductID }, { "@TotalQTY", TotalQTY }, { "@Price ", Price }, { "@TotalGross", TotalGross }, { "@TotalDiscount", TotalDiscount }, { "@NetTotal", NetTotal }, { "@StockIn", StockIn }, { "@StockOut", StockOut } }; DBActions db = new General.DBActions(); Id = db.ExecuteScalar("InserItnvTransactionDetails", Parameters); return(Convert.ToInt32(Id)); }