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));
}
