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