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