private List <Paymentitems> Collectitems(string vId)
{
List <Paymentitems> list = new List <Paymentitems>();
for (int r = 0; r < editgrid.RowCount; r++)
{
Paymentitems obj = new Paymentitems();
if (
(editgrid[PAYMENTITEMS.PAYMENT_AMOUNT, r].Value + "") == ""
)
{
//==LEAVE IT(the empty row).
}
else
{
obj.Paymentitems_id = "";
obj.Payment_id = vId;
obj.Payment_by = (editgrid[PAYMENTITEMS.PAYMENT_BY, r].Value + "");
obj.Purchase_no = (editgrid[PAYMENTITEMS.PURCHASE_NO, r].Value + "");
obj.Purchase_amount = (editgrid[PAYMENTITEMS.PURCHASE_AMOUNT, r].Value + "");
obj.Payment_amount = (editgrid[PAYMENTITEMS.PAYMENT_AMOUNT, r].Value + "");
list.Add(obj);
}
}
if (list.Count != 0)
{
return(list);
}
return(null);
}
private static string AttachParams(string q, Paymentitems v)
{
q = q.Replace("@" + PAYMENTITEMS.PAYMENT_ID + "@", "" + ConvertTO.SqlString(v.Payment_id) + "");
q = q.Replace("@" + PAYMENTITEMS.PAYMENT_BY + "@", "" + ConvertTO.SqlString(v.Payment_by) + "");
q = q.Replace("@" + PAYMENTITEMS.PURCHASE_NO + "@", "" + ConvertTO.SqlString(v.Purchase_no) + "");
q = q.Replace("@" + PAYMENTITEMS.PURCHASE_AMOUNT + "@", "" + ConvertTO.SqlString(v.Purchase_amount) + "");
q = q.Replace("@" + PAYMENTITEMS.PAYMENT_AMOUNT + "@", "" + ConvertTO.SqlString(v.Payment_amount) + "");
return(q);
}
public static void Insert(List <Paymentitems> list, DAL dalsession)
{
for (int i = 0; i < list.Count; i++)
{
Paymentitems obj = new Paymentitems()
{
Payment_id = list[i].Payment_id,
Payment_by = list[i].Payment_by,
Purchase_no = list[i].Purchase_no,
Purchase_amount = list[i].Purchase_amount,
Payment_amount = list[i].Payment_amount
};
InsertSub(obj, dalsession);
}
}
public static void InsertSub(Paymentitems v, DAL dalsession)
{
string q = " INSERT INTO " + PAYMENTITEMS.PAYMENTITEMS_TBL + " ( ";
q += " " + PAYMENTITEMS.PAYMENT_ID + " \r\n ";
q += "," + PAYMENTITEMS.PAYMENT_BY + " \r\n ";
q += "," + PAYMENTITEMS.PURCHASE_NO + " \r\n ";
q += "," + PAYMENTITEMS.PURCHASE_AMOUNT + " \r\n ";
q += "," + PAYMENTITEMS.PAYMENT_AMOUNT + " \r\n ";
q += " ) VALUES ( ";
q += " @" + PAYMENTITEMS.PAYMENT_ID + "@ \r\n ";
q += ", @" + PAYMENTITEMS.PAYMENT_BY + "@ \r\n ";
q += ", @" + PAYMENTITEMS.PURCHASE_NO + "@ \r\n ";
q += ", @" + PAYMENTITEMS.PURCHASE_AMOUNT + "@ \r\n ";
q += ", @" + PAYMENTITEMS.PAYMENT_AMOUNT + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
private static List <Paymentitems> EntityList(string q)
{
List <Paymentitems> list = new List <Paymentitems>();
using (IDataReader redr = new DAL().Listreader(q))
{
while (redr.Read() == true)
{
Paymentitems obj = new Paymentitems()
{
Paymentitems_id = redr[PAYMENTITEMS.PAYMENTITEMS_ID].ToString(),
Payment_id = redr[PAYMENTITEMS.PAYMENT_ID].ToString(),
Payment_by = redr[PAYMENTITEMS.PAYMENT_BY].ToString(),
Purchase_no = redr[PAYMENTITEMS.PURCHASE_NO].ToString(),
Purchase_amount = redr[PAYMENTITEMS.PURCHASE_AMOUNT].ToString(),
Payment_amount = redr[PAYMENTITEMS.PAYMENT_AMOUNT].ToString(),
};
list.Add(obj);
}
}
return(list);
}
