Beispiel #1
0
        private static List <Upvc_invoiceitems> EntityList(string q)
        {
            List <Upvc_invoiceitems> list = new List <Upvc_invoiceitems>();

            using (IDataReader redr = new DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    Upvc_invoiceitems obj = new Upvc_invoiceitems()
                    {
                        Upvc_invoiceitems_id = redr[UPVC_INVOICEITEMS.UPVC_INVOICEITEMS_ID].ToString(),
                        Upvc_invoice_id      = redr[UPVC_INVOICEITEMS.UPVC_INVOICE_ID].ToString(),
                        Product_id           = redr[PRODUCT.PRODUCT_NAME].ToString(),
                        Pcrate       = redr[UPVC_INVOICEITEMS.PCRATE].ToString(),
                        Msm          = redr[UPVC_INVOICEITEMS.MSM].ToString(),
                        Widths       = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.WIDTHS].ToString()),
                        Heights      = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.HEIGHTS].ToString()),
                        TotalAreasq  = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.TOTALAREASQ].ToString()),
                        Qty          = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.QTY].ToString()),
                        Price        = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.PRICE].ToString()),
                        Sgst_percent = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.SGST_PERCENT].ToString()),
                        Cgst_percent = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.CGST_PERCENT].ToString()),
                        Igst_percent = ConvertTO.Decimal(redr[UPVC_INVOICEITEMS.IGST_PERCENT].ToString()),
                        Refered_id   = redr[UPVC_INVOICEITEMS.REFERED_ID].ToString(),
                        Locked       = redr[UPVC_INVOICEITEMS.LOCKED].ToString(),
                    };

                    list.Add(obj);
                }
            }
            return(list);
        }
Beispiel #2
0
        public static Print_QuotationItemsList GetData(string p_id)
        {
            Print_QuotationItemsList list = new Print_QuotationItemsList();
            //
            List <Upvc_Quotationitems> inv_item_list = CUpvc_Quotationitems_exten.FKId(p_id, new DAL());

            for (int r = 0; r <= inv_item_list.Count - 1; r++)
            {
                Print_QuotationitemsRow row = new Print_QuotationitemsRow();
                //
                row.QUOTATION_ITEM_ID = inv_item_list[r].Upvc_Quotationitems_id;
                row.QUOTATION_ID      = inv_item_list[r].Upvc_Quotation_id;
                row.SL_NO             = (r + 1).ToString();
                row.PRODUCT_ID        = inv_item_list[r].Product_id;

                row.HSN_CODE_ID = Ccoreplus.GetHsncode_name(inv_item_list[r].Product_id);

                row.PCRATE  = inv_item_list[r].Pcrate;
                row.MSM     = inv_item_list[r].Msm;
                row.QTY     = ConvertTO.DecimalToS(inv_item_list[r].Qty.ToString());
                row.WIDTHS  = ConvertTO.DecimalToS(inv_item_list[r].Widths.ToString());
                row.HEIGTHS = ConvertTO.DecimalToS(inv_item_list[r].Heights.ToString());
                row.AREASQ  = ConvertTO.DecimalToS(inv_item_list[r].TotalAreasq.ToString());
                row.PRICE   = ConvertTO.DecimalToS(inv_item_list[r].Price.ToString());

                Upvc_invoiceitems obj = new Upvc_invoiceitems()
                {
                    Pcrate       = row.PCRATE,
                    Msm          = row.MSM,
                    Qty          = ConvertTO.Decimal(row.QTY),
                    Widths       = ConvertTO.Decimal(row.WIDTHS),
                    Heights      = ConvertTO.Decimal(row.HEIGTHS),
                    Price        = ConvertTO.Decimal(row.PRICE),
                    Cgst_percent = inv_item_list[r].Cgst_percent,
                    Sgst_percent = inv_item_list[r].Sgst_percent,
                    Igst_percent = inv_item_list[r].Igst_percent
                };

                UpvcCalculation.Calculate(obj);

                row.TAXABLEVALUE = ConvertTO.Decimal2d(obj.Taxable_amount.ToString());

                row.CGST_PERCENT = ConvertTO.DecimalToS(obj.Cgst_percent.ToString());

                row.CGST_AMOUNT = ConvertTO.Decimal2d(obj.Cgst_amount.ToString());

                row.SGST_PERCENT = ConvertTO.DecimalToS(obj.Sgst_percent.ToString());

                row.SGST_AMOUNT = ConvertTO.Decimal2d(obj.Sgst_amount.ToString());

                row.SUB_TOTAL = ConvertTO.Decimal2d((obj.Taxable_amount + obj.Cgst_amount + obj.Sgst_amount + obj.Igst_amount).ToString());

                list.Add(row);
                //
            }
            //
            return(list);
        }
Beispiel #3
0
        private List <Upvc_invoiceitems> Collectitems(string vId)
        {
            List <Upvc_invoiceitems> list = new List <Upvc_invoiceitems>();

            for (int r = 0; r < editgrid.RowCount; r++)
            {
                Upvc_invoiceitems obj = new Upvc_invoiceitems();

                if (
                    (editgrid[UPVC_INVOICEITEMS.PRODUCT_ID, r].Value + "") == "" ||
                    (editgrid[UPVC_INVOICEITEMS.QTY, r].Value + "") == "" ||
                    (editgrid[UPVC_INVOICEITEMS.PRICE, r].Value + "") == ""
                    )
                {
                    //==LEAVE IT(the empty row).
                }
                else
                {
                    obj.Upvc_invoiceitems_id = "";
                    obj.Upvc_invoice_id      = vId;
                    obj.Product_id           = CProduct_exten.GetId_Name(editgrid[UPVC_INVOICEITEMS.PRODUCT_ID, r].Value + "");
                    obj.Pcrate       = (editgrid[UPVC_INVOICEITEMS.PCRATE, r].Value + "");
                    obj.Msm          = (editgrid[UPVC_INVOICEITEMS.MSM, r].Value + "");
                    obj.Widths       = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.WIDTHS, r].Value + "");
                    obj.Heights      = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.HEIGHTS, r].Value + "");
                    obj.TotalAreasq  = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.TOTALAREASQ, r].Value + "");
                    obj.Qty          = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.QTY, r].Value + "");
                    obj.Price        = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.PRICE, r].Value + "");
                    obj.Sgst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.SGST_PERCENT, r].Value + "");
                    obj.Cgst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.CGST_PERCENT, r].Value + "");
                    obj.Igst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.IGST_PERCENT, r].Value + "");
                    obj.Refered_id   = "";
                    obj.Locked       = Core.Unlocked;

                    list.Add(obj);
                }
            }

            if (list.Count != 0)
            {
                return(list);
            }

            return(null);
        }
Beispiel #4
0
 private static string AttachParams(string q, Upvc_invoiceitems v)
 {
     q = q.Replace("@" + UPVC_INVOICEITEMS.UPVC_INVOICE_ID + "@", "" + ConvertTO.SqlString(v.Upvc_invoice_id) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.PRODUCT_ID + "@", "" + ConvertTO.SqlString(v.Product_id) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.PCRATE + "@", "" + ConvertTO.SqlString(v.Pcrate) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.MSM + "@", "" + ConvertTO.SqlString(v.Msm) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.WIDTHS + "@", "" + ConvertTO.SqlString(v.Widths.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.HEIGHTS + "@", "" + ConvertTO.SqlString(v.Heights.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.TOTALAREASQ + "@", "" + ConvertTO.SqlString(v.TotalAreasq.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.QTY + "@", "" + ConvertTO.SqlString(v.Qty.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.PRICE + "@", "" + ConvertTO.SqlString(v.Price.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.SGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Sgst_percent.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.CGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Cgst_percent.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.IGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Igst_percent.ToString()) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.REFERED_ID + "@", "" + ConvertTO.SqlString(v.Refered_id) + "");
     q = q.Replace("@" + UPVC_INVOICEITEMS.LOCKED + "@", "" + ConvertTO.SqlString(v.Locked) + "");
     return q;
 }
        private void CalcRow(int pRowIndex)
        {
            if ((editgrid[UPVC_INVOICEITEMS.PRODUCT_ID, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.PCRATE, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.MSM, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.QTY, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.WIDTHS, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.HEIGHTS, pRowIndex].Value + "") == "" ||
                (editgrid[UPVC_INVOICEITEMS.PRICE, pRowIndex].Value + "") == ""
                )
            {
                //==LEAVE IT(the empty row).
            }
            else
            {
                Upvc_invoiceitems items = new Upvc_invoiceitems
                {
                    Qty          = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.QTY, pRowIndex].Value.ToString()),
                    Widths       = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.WIDTHS, pRowIndex].Value.ToString()),
                    Heights      = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.HEIGHTS, pRowIndex].Value.ToString()),
                    Pcrate       = editgrid[UPVC_INVOICEITEMS.PCRATE, pRowIndex].Value + "",
                    Msm          = editgrid[UPVC_INVOICEITEMS.MSM, pRowIndex].Value + "",
                    Price        = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.PRICE, pRowIndex].Value),
                    Cgst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.CGST_PERCENT, pRowIndex].Value),
                    Sgst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.SGST_PERCENT, pRowIndex].Value),
                    Igst_percent = ConvertTO.Decimal(editgrid[UPVC_INVOICEITEMS.IGST_PERCENT, pRowIndex].Value),
                };

                UpvcCalculation.Calculate(items);

                editgrid[UPVC_INVOICEITEMS.TOTALAREASQ, pRowIndex].Value    = items.TotalAreasq.ToString();
                editgrid[UPVC_INVOICEITEMS.TAXABLE_AMOUNT, pRowIndex].Value = items.Taxable_amount.ToString();
                editgrid[UPVC_INVOICEITEMS.CGST_AMOUNT, pRowIndex].Value    = items.Cgst_amount.ToString();
                editgrid[UPVC_INVOICEITEMS.SGST_AMOUNT, pRowIndex].Value    = items.Sgst_amount.ToString();
                editgrid[UPVC_INVOICEITEMS.IGST_AMOUNT, pRowIndex].Value    = items.Igst_amount.ToString();
            }//if conditoin
        }
Beispiel #6
0
 public static void InsertSub(Upvc_invoiceitems v, DAL dalsession)
 {
     string q = " INSERT INTO " + UPVC_INVOICEITEMS.UPVC_INVOICEITEMS_TBL + " ( ";
     q += " " + UPVC_INVOICEITEMS.UPVC_INVOICE_ID + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.PRODUCT_ID + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.PCRATE + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.MSM + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.WIDTHS + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.HEIGHTS + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.TOTALAREASQ + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.QTY + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.PRICE + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.SGST_PERCENT + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.CGST_PERCENT + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.IGST_PERCENT + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.REFERED_ID + " \r\n ";
     q += "," + UPVC_INVOICEITEMS.LOCKED + " \r\n ";
     q += " ) VALUES ( ";
     q += "  @" + UPVC_INVOICEITEMS.UPVC_INVOICE_ID + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.PRODUCT_ID + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.PCRATE + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.MSM + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.WIDTHS + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.HEIGHTS + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.TOTALAREASQ + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.QTY + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.PRICE + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.SGST_PERCENT + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.CGST_PERCENT + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.IGST_PERCENT + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.REFERED_ID + "@ \r\n ";
     q += ", @" + UPVC_INVOICEITEMS.LOCKED + "@ \r\n ";
     q += " ) \r\n ";
     q = AttachParams(q, v);
     dalsession.Execute(q);
 }
Beispiel #7
0
 public static void Insert(List<Upvc_invoiceitems> list, DAL dalsession)
 {
     for (int i = 0; i < list.Count; i++)
     {
         Upvc_invoiceitems obj = new Upvc_invoiceitems()
         {
             Upvc_invoice_id = list[i].Upvc_invoice_id,
             Product_id = list[i].Product_id,
             Pcrate = list[i].Pcrate,
             Msm = list[i].Msm,
             Widths = list[i].Widths,
             Heights = list[i].Heights,
             TotalAreasq = list[i].TotalAreasq,
             Qty = list[i].Qty,
             Price = list[i].Price,
             Sgst_percent = list[i].Sgst_percent,
             Cgst_percent = list[i].Cgst_percent,
             Igst_percent = list[i].Igst_percent,
             Refered_id = list[i].Refered_id,
             Locked = list[i].Locked
         };
         InsertSub(obj, dalsession);
     }
 }