public void deleteTransaction(CtransactionDTO cTransaction)
{
sqlConnection.Open();
String update;
update = " delete from ChalanTransaction where ChalanID =" + cTransaction.CHALANID + " ";
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void updateTraction(CtransactionDTO cTransaction)
{
sqlConnection.Open();
String update;
update = " update ChalanTransaction set Date ='" + cTransaction.DATE + "', ChalanCost= " + cTransaction.CHALANCOST + " ,LaborCost=" + cTransaction.LABORCOST + " ,TotalCaseNo = " + cTransaction.TOTALCASE + " where ChalanID =" + cTransaction.CHALANID + " ";
System.Diagnostics.Debug.WriteLine(update);
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void addChalan(CtransactionDTO chalan)
{
//databaseConnection.databaseOpenConnection();
sqlConnection.Open();
String query = "insert into ChalanTransaction values ('" + chalan.DATE + "'," +
"'" + chalan.CHALANCOST + "'," +
"'" + chalan.LABORCOST + "'," +
"'" + chalan.TOTALCASE + "'," +
"'" + chalan.CHALANID + "')";
sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
