private void InsertClientDeal(ClientDealDetails ClientDealDetails) { byte x = 1; switch (ClientDealDetails.TheUnit) { case TheUnito.Gram: x = 0; break; case TheUnito.Kilo: x = 1; break; case TheUnito.Piece: x = 2; break; } OleDbCommand cmd = new OleDbCommand(string.Format(@"INSERT INTO ClientDeals (ClientId,TypeId,Amount,Price,PaidMoney,Details,AddedDate,TheUnit,BusinessPrice,ClientName,TypeName)VALUES ( {0},{1},{2},{3},{4},'{5}','{6}',{7},{8},'{9}','{10}')" , ClientDealDetails.ClientId.ToString(), ClientDealDetails.TypeId.ToString(), ClientDealDetails.Amount.ToString(), ClientDealDetails.Price.ToString(), ClientDealDetails.PaidMoney.ToString(), ClientDealDetails.Details.ToString(), ClientDealDetails.AddedDate.ToStringToinsert(), x, ClientDealDetails.BusinessPrice.ToString(), ClientDealDetails.ClientName, ClientDealDetails.TypeName), cn); cmd.CommandType = CommandType.Text; ExuteNonQuery(cmd); }
public abstract int InsertSalesReturns(ClientDealDetails ClientDealDetails);
public abstract int InsertClientDeal(ClientDealDetails ClientDealDetails, bool opencon);
public abstract int InsertClientDeal(ClientDealDetails ClientDealDetails);
public abstract bool UpdateClientDealy(ClientDealDetails ClientDealDetails);
public abstract bool UpdateSalesReturns(ClientDealDetails ClientDealDetails);