public int getTopReceiptNum()//שליפת מספר הקבלה האחרון בבסיס הנתונים
{
DAAddReceipt dm = new DAAddReceipt();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.getReceiptNum(Params);
int ReceiptNum = 0;
foreach (DataRow item in ds.Tables[0].Rows)
{
ReceiptNum = BLCtrl.getInt(item, "LastreceiptNum", 0);
}
return(ReceiptNum);
}
public List <Banks> getAllBanks()
{
DAAddReceipt dm = new DAAddReceipt();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.getAllBanks(Params);
Banks b;
List <Banks> l = new List <Banks>();
foreach (DataRow item in ds.Tables[0].Rows)
{
b = new Banks();
b.BankNum = BLCtrl.getInt(item, "BankNum", 0);
b.BankName = BLCtrl.getString(item, "BankName", "");
l.Add(b);
}
return(l);
}
public List <PayBy> getPayBy()
{
DAAddReceipt dm = new DAAddReceipt();
ListDictionary Params = new ListDictionary();
DataSet ds = dm.getPayBay(Params);
PayBy b;
List <PayBy> l = new List <PayBy>();
foreach (DataRow item in ds.Tables[0].Rows)
{
b = new PayBy();
b.Code = BLCtrl.getInt(item, "Code", 0);
b.payBy = BLCtrl.getString(item, "PayBy", "");
l.Add(b);
}
return(l);
}
public int AddCustomerReceipt(DateTime receiptDate, double sum, int payBy,
string chequaNum, int bank, int paymentNum, string runch, string bankAccount,
string cardsKind, string CreditCard, string validity, string Name, int ReceiptNum, string Id)
{
DAAddReceipt dm = new DAAddReceipt();
ListDictionary Params = new ListDictionary();
Params.Add("@ReceiptDate", BLCtrl.sendDateTime(receiptDate, new DateTime()));
Params.Add("@Sum", BLCtrl.sendDouble(sum, 0));
if (payBy != 0)
{
Params.Add("@PayBy", payBy);
}
else
{
Params.Add("@PayBy", DBNull.Value);
}
Params.Add("@chequaNum", BLCtrl.sendString(chequaNum, ""));
if (bank != 0)
{
Params.Add("@Bank", bank);
}
else
{
Params.Add("@Bank", DBNull.Value);
}
Params.Add("@Brunch", BLCtrl.sendString(runch, ""));
Params.Add("@BankAccount", BLCtrl.sendString(bankAccount, ""));
Params.Add("@CardsKind", BLCtrl.sendString(cardsKind, ""));
Params.Add("@CreditCard", BLCtrl.sendString(CreditCard, ""));
Params.Add("@Validity", BLCtrl.sendString(validity, ""));
Params.Add("@Name", BLCtrl.sendString(Name, ""));
Params.Add("@paymentNum", BLCtrl.sendInt(paymentNum, 0));
Params.Add("@ReceiptNum", BLCtrl.sendInt(ReceiptNum, 0));
Params.Add("@Id", BLCtrl.sendString(Id, ""));
int result = dm.addReceipt(Params, "addCustomerReceipt");
return(result);
}
