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