public bool AddNewInventory(List <Inventory> objList) { string commandText = OleDBHelper.GetQueryText("Inventory_Insert", QueryType.Procedures); int count = objList.Count; OleDbParameter[] parameters; bool result = false; if (count > 0) { foreach (Inventory obj in objList) { parameters = new OleDbParameter[] { new OleDbParameter("@ItemID", obj.ItemID), new OleDbParameter("@UnitID", obj.UnitID), new OleDbParameter("@LastTranID", obj.LastTranID), new OleDbParameter("@QtyIn", obj.QtyIn), new OleDbParameter("@QtyOut", obj.QtyOut), new OleDbParameter("@PrevBalance", obj.PrevBalance), new OleDbParameter("@CurrBalance", obj.CurrBalance), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; result = OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters); if (result == false) { break; } } } return(result); }
public bool AddNewTransactionInDetails(List <BooksTransactionInDetails> objList) { string commandText = OleDBHelper.GetQueryText("BooksTransactionInDetails_Insert", QueryType.Procedures); int count = objList.Count; OleDbParameter[] parameters; bool result = false; if (count > 0) { foreach (BooksTransactionInDetails obj in objList) { parameters = new OleDbParameter[] { new OleDbParameter("@TransactionID", obj.TransactionID), new OleDbParameter("@BookID", obj.BookMaster.BookID), new OleDbParameter("@Unit", obj.Unit) }; result = OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters); if (result == false) { break; } } } return(result); }
public bool AddNewItemMaster(ItemMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@ItemID", obj.ItemID), new OleDbParameter("@ItemName", obj.ItemName), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("ItemMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
// Same can be used for deactive user public bool DeleteTransactionOutDetails(string transactionID) { string commandText = OleDBHelper.GetQueryText("TransactionOutDetails_Delete", QueryType.Procedures); OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TransactionID", transactionID) }; bool result = false; result = OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters); return(result); }
public static bool UpdateUniqueCodeForTable(string tableName) { bool result; OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TableName", tableName) }; string commandText = OleDBHelper.GetQueryText("UniqueCodeMaster_Update", QueryType.Procedures); result = OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters); return(result); }
public bool AddNewAccount(Account account) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@ID", account.ID), new OleDbParameter("@AccountHolderName", account.AccountHolderName), new OleDbParameter("@DOB", account.DateOfBirth), new OleDbParameter("@IsActive", 1), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = DBQuery.GetQueryText("AccountMaster1_Insert"); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public bool UpdateTransactionOutMaster(BooksTransactionOutMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TransactionDate", obj.TransactionDate), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)), new OleDbParameter("@TransactionID", obj.TransactionID) }; string commandText = OleDBHelper.GetQueryText("BooksTransactionOutMaster_Update", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public bool AddNewTransactionInMaster(TransactionInMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TransactionID", obj.TransactionID), new OleDbParameter("@TransactionDate", obj.TransactionDate), new OleDbParameter("@PartyID", obj.PartyID), new OleDbParameter("@Amount", obj.Amount), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("TransactionInMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public bool AddNewPartyMaster(PartyMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@PartyID", obj.PartyID), new OleDbParameter("@PartyName", obj.PartyName), new OleDbParameter("@PersonName", obj.PersonName), new OleDbParameter("@Address", obj.Address), new OleDbParameter("@ContactNo", obj.ContactNo), new OleDbParameter("@Mobile", obj.Mobile), new OleDbParameter("@EamilAddress", obj.EamilAddress), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("PartyMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public bool AddNewBooksMaster(BooksMaster book) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@BookID", book.BookID), new OleDbParameter("@ISBN", book.ISBN), new OleDbParameter("@Title", book.Title), new OleDbParameter("@Title", book.Subject), new OleDbParameter("@Author", book.Author), new OleDbParameter("@Publication", book.Publication), new OleDbParameter("@EditionNo", book.EditionNo), new OleDbParameter("@EditionYear", book.EditionYear), new OleDbParameter("@Price", book.Price), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("BooksMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public bool UpdateInventory(Inventory obj) { string commandText = OleDBHelper.GetQueryText("Inventory_Update", QueryType.Procedures); OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@LastTranID", obj.LastTranID), new OleDbParameter("@QtyIn", obj.QtyIn), new OleDbParameter("@QtyOut", obj.QtyOut), new OleDbParameter("@PrevBalance", obj.PrevBalance), new OleDbParameter("@CurrBalance", obj.CurrBalance), new OleDbParameter("@UpdatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)), new OleDbParameter("@ItemID", obj.ItemID) //new OleDbParameter("@UnitID", obj.UnitID) }; return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }