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