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 DataSet LoadProductCode() { DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery_SP("GetLastProductCode"); return(ds); }
public DataSet SelectUsers() { DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery_SP("SelectUser"); return(ds); }
public void Setisactiveornot() { object Id = 0; object[,] Parameters = new object[, ] { { "@InvTransactionMasterID", InvTransactionMasterID } }; DBActions db = new General.DBActions(); db.ExecuteScalar("Setisactiveornot", Parameters); }
public DataSet StockLedgerReport() { object[,] Parameters = new object[, ] { { "@date", AsonDate }, { "@ProductID", ProductID } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelecStockLedgerReport", Parameters); return(ds); }
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 DataSet ItemWiserReport() { object[,] Parameters = new object[, ] { { "@fromdate", fromdate }, { "@todate", todate }, { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("ItemWiseStockReport", Parameters); return(ds); }
public DataSet LoadVoucherNo() { object[,] Parameters = new object[, ] { { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("GetMaxofLastVoucherNo", Parameters); return(ds); }
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 DataSet LoadProductList() { object[,] Parameters = new object[, ] { { "@ProductName", ProductName } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("LoadProducListonGridView", Parameters); return(ds); }
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 DataSet SelecInvdetails() { object Id = 0; object[,] Parameters = new object[, ] { { "@ProductCode", pcode } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectProductDetails", Parameters); return(ds); }
public int RefreshStock() { DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery_SP("RefreshStock"); int result = 0; if (ds.Tables[0].Rows.Count > 0) { result = 1; } return(result); }
public DataSet SelectTransRegisterReport() { object[,] Parameters = new object[, ] { { "@fromdate", fromdate }, { "@todate", todate }, { "@TransactionType", TransactionType }, { "@ProductGroupID", ProductGroupID }, { "@ProductID", ProductID } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectTransRegisterReport", Parameters); return(ds); }
public DataSet LoadEditDetails() { object Id = 0; object[,] Parameters = new object[, ] { { "@VoucherNumber", VoucherNumber }, { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("LoadEditDetails", Parameters); return(ds); }
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 ValidateUsers() { object[,] Parameters = new object[, ] { { "@UserName", UserName }, { "@Password", Passwd } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectUserByUserNameAndPassword", Parameters); int result = 0; if (ds.Tables[0].Rows.Count > 0) { result = 1; } return(result); }
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[, ] { { "@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)); }
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)); }