public bool Update(AccountingR i)
{
try
{
string query = "UPDATE Banking SET Date = '" + i.Date + "', Ammount=" + i.Money + "WHERE Date= '" + i.Date + "' ";
DatabaseConnection dc = new DatabaseConnection();
dc.ConnectWithDB();
int x = dc.ExecuteSQL(query);
dc.CloseConnection();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Insert(AccountingR i)
{
try
{
string query = " INSERT into Banking VALUES ('" + i.Date + "', " + i.Money + " ," + i.CurrentAmmount + ") ";
DatabaseConnection dc = new DatabaseConnection();
dc.ConnectWithDB();
int x = dc.ExecuteSQL(query);
dc.CloseConnection();
return(true);
}
catch (Exception)
{
return(false);
}
}
//search
public List <AccountingR> searchTransiction(string text)
{
string query = "SELECT * from Banking WHERE Date like '%" + text + "%' ";
List <AccountingR> iList = new List <AccountingR>();
DatabaseConnection dc = new DatabaseConnection();
dc.ConnectWithDB();
SqlDataReader sdr = dc.GetData(query);
while (sdr.Read())
{
AccountingR i = new AccountingR();
i.Date = sdr["Date"].ToString();
i.Money = Convert.ToDouble(sdr["Ammount"]);
iList.Add(i);
}
dc.CloseConnection();
return(iList);
}
//
//getProduct
/* public DealsR GetDealerCompany(string CompanyId)
* {
* string query = "SELECT * from deal WHERE CompanyId = '" + CompanyId + "'";
* DealsR i = null;
* DatabaseConnection dc = new DatabaseConnection();
* dc.ConnectWithDB();
* SqlDataReader sdr = dc.GetData(query);
*
* if (sdr.Read())
* {
* //(CompanyId,ContactId,DealersName,DealersAddress,DealersPhone,DealersEmail,ParentCompany,IndustryType,AnnualRevenue,CurrencyId,PaymentTerms)
* i = new DealsR();
* i.CompanyId = sdr["CompanyId"].ToString();
* i.ContactId = sdr["ContactId"].ToString();
* i.DealersName = sdr["DealersName"].ToString();
* i.DealersAddress = sdr["DealersAddress "].ToString();
* i.DealersPhone = sdr["DealersPhone "].ToString();
* i.DealersEmail = sdr["DealersEmail"].ToString();
* i.ParentCompany = sdr["ParentCompany"].ToString();
* i.IndustryType = sdr["IndustryType"].ToString();
* i.AnnualRevenue = sdr["AnnualRevenue"].ToString();
* i.CurrencyId = sdr["CurrencyId"].ToString();
* i.PaymentTerms = sdr["PaymentTerms"].ToString();
*
* }
* dc.CloseConnection();
* return i;
* }
* //allget*/
public List <AccountingR> GetAllTransiction()
{
string query = "SELECT * from Banking";
List <AccountingR> iList = new List <AccountingR>();
DatabaseConnection dc = new DatabaseConnection();
dc.ConnectWithDB();
SqlDataReader sdr = dc.GetData(query);
while (sdr.Read())
{
AccountingR i = new AccountingR();
i.Date = sdr["Date"].ToString();
i.Money = Convert.ToDouble(sdr["Ammount"]);
i.CurrentAmmount = Convert.ToDouble(sdr["CurrentAmount"]);
iList.Add(i);
}
dc.CloseConnection();
return(iList);
}