private static List <Purchase_Gst> PurchaseEntityList(string q) { List <Purchase_Gst> list = new List <Purchase_Gst>(); using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { Purchase_Gst obj = new Purchase_Gst() { Company_name = "", Acy_name = "", Purchase_Month = "", Gstin = redr[PURCHASE_GST.GSTIN].ToString(), Party_name = redr[PURCHASE_GST.PARTY_NAME].ToString(), Bill_no = redr[PURCHASE_GST.BILL_NO].ToString(), Bill_date = ConvertTO.Date2S(redr[PURCHASE_GST.BILL_DATE].ToString()), Bill_amount = ConvertTO.Decimal(redr[SALES_GST.BILL_AMOUNT].ToString()), Taxable_value = ConvertTO.Decimal(redr[SALES_GST.TAXABLE_VALUE].ToString()), Sgst_percent = redr[SALES_GST.SGST_PERCENT].ToString(), Sgst_amount = ConvertTO.Decimal(redr[SALES_GST.SGST_AMOUNT].ToString()), Cgst_percent = redr[SALES_GST.CGST_PERCENT].ToString(), Cgst_amount = ConvertTO.Decimal(redr[SALES_GST.CGST_AMOUNT].ToString()), Igst_percent = redr[SALES_GST.IGST_PERCENT].ToString(), Igst_amount = ConvertTO.Decimal(redr[SALES_GST.IGST_AMOUNT].ToString()), Gst_total = ConvertTO.Decimal(redr[SALES_GST.GST_TOTAL].ToString()) }; list.Add(obj); } } return(list); }
private List <Purchase_Gst> CollectPurchase() { List <Purchase_Gst> list = new List <Purchase_Gst>(); for (int k = 0; k < Listgrid_1.RowCount; k++) { Purchase_Gst obj = new Purchase_Gst() { Company_name = Current.Company_Name, Acy_name = Current.Acy_Name, Purchase_Month = Txt_month.Text.ToString(), Gstin = Listgrid_1[PURCHASE_GST.GSTIN, k].Value + "", Party_name = Listgrid_1[PURCHASE_GST.PARTY_NAME, k].Value + "", Bill_no = Listgrid_1[PURCHASE_GST.BILL_NO, k].Value + "", Bill_date = Listgrid_1[PURCHASE_GST.BILL_DATE, k].Value + "", Bill_amount = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.BILL_AMOUNT, k].Value), Taxable_value = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.TAXABLE_VALUE, k].Value), Sgst_percent = Listgrid_1[PURCHASE_GST.SGST_PERCENT, k].Value + "", Sgst_amount = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.SGST_AMOUNT, k].Value), Cgst_percent = Listgrid_1[PURCHASE_GST.CGST_PERCENT, k].Value + "", Cgst_amount = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.CGST_AMOUNT, k].Value), Igst_percent = Listgrid_1[PURCHASE_GST.IGST_PERCENT, k].Value + "", Igst_amount = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.IGST_AMOUNT, k].Value), Gst_total = ConvertTO.Decimal("0" + Listgrid_1[PURCHASE_GST.GST_TOTAL, k].Value) }; list.Add(obj); } return(list); }