public static void InsertSub(Upvc_Quotationitems v, DAL dalsession)
{
string q = " INSERT INTO " + UPVC_QUOTATIONITEMS.UPVC_QUOTATIONITEMS_TBL + " ( ";
q += " " + UPVC_QUOTATIONITEMS.UPVC_QUOTATION_ID + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.PRODUCT_ID + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.WIDTHS + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.HEIGHTS + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.TOTALAREASQ + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.QTY + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.PRICE + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.SGST_PERCENT + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.CGST_PERCENT + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.IGST_PERCENT + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.REFERED_ID + " \r\n ";
q += "," + UPVC_QUOTATIONITEMS.LOCKED + " \r\n ";
q += " ) VALUES ( ";
q += " @" + UPVC_QUOTATIONITEMS.UPVC_QUOTATION_ID + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.PRODUCT_ID + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.WIDTHS + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.HEIGHTS + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.TOTALAREASQ + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.QTY + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.PRICE + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.SGST_PERCENT + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.CGST_PERCENT + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.IGST_PERCENT + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.REFERED_ID + "@ \r\n ";
q += ", @" + UPVC_QUOTATIONITEMS.LOCKED + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
private static List <Upvc_Quotationitems> EntityList(string q)
{
List <Upvc_Quotationitems> list = new List <Upvc_Quotationitems>();
using (IDataReader redr = new DAL().Listreader(q))
{
while (redr.Read() == true)
{
Upvc_Quotationitems obj = new Upvc_Quotationitems()
{
Upvc_Quotationitems_id = redr[UPVC_QUOTATIONITEMS.UPVC_QUOTATIONITEMS_ID].ToString(),
Upvc_Quotation_id = redr[UPVC_QUOTATIONITEMS.UPVC_QUOTATION_ID].ToString(),
Product_id = redr[PRODUCT.PRODUCT_NAME].ToString(),
Widths = redr[UPVC_QUOTATIONITEMS.WIDTHS].ToString(),
Heights = redr[UPVC_QUOTATIONITEMS.HEIGHTS].ToString(),
TotalAreasq = redr[UPVC_QUOTATIONITEMS.TOTALAREASQ].ToString(),
Qty = redr[UPVC_QUOTATIONITEMS.QTY].ToString(),
Price = ConvertTO.Decimal(redr[UPVC_QUOTATIONITEMS.PRICE].ToString()),
Sgst_percent = ConvertTO.Decimal(redr[UPVC_QUOTATIONITEMS.SGST_PERCENT].ToString()),
Cgst_percent = ConvertTO.Decimal(redr[UPVC_QUOTATIONITEMS.CGST_PERCENT].ToString()),
Igst_percent = ConvertTO.Decimal(redr[UPVC_QUOTATIONITEMS.IGST_PERCENT].ToString()),
Refered_id = redr[UPVC_QUOTATIONITEMS.REFERED_ID].ToString(),
Locked = redr[UPVC_QUOTATIONITEMS.LOCKED].ToString(),
};
list.Add(obj);
}
}
return(list);
}
private static string AttachParams(string q, Upvc_Quotationitems v)
{
q = q.Replace("@" + UPVC_QUOTATIONITEMS.UPVC_QUOTATION_ID + "@", "" + ConvertTO.SqlString(v.Upvc_Quotation_id) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.PRODUCT_ID + "@", "" + ConvertTO.SqlString(v.Product_id) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.WIDTHS + "@", "" + ConvertTO.SqlString(v.Widths) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.HEIGHTS + "@", "" + ConvertTO.SqlString(v.Heights) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.TOTALAREASQ + "@", "" + ConvertTO.SqlString(v.TotalAreasq) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.QTY + "@", "" + ConvertTO.SqlString(v.Qty) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.PRICE + "@", "" + ConvertTO.SqlString(v.Price.ToString()) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.SGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Sgst_percent.ToString()) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.CGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Cgst_percent.ToString()) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.IGST_PERCENT + "@", "" + ConvertTO.SqlString(v.Igst_percent.ToString()) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.REFERED_ID + "@", "" + ConvertTO.SqlString(v.Refered_id) + "");
q = q.Replace("@" + UPVC_QUOTATIONITEMS.LOCKED + "@", "" + ConvertTO.SqlString(v.Locked) + "");
return(q);
}
private List <Upvc_Quotationitems> Collectitems(string vId)
{
List <Upvc_Quotationitems> list = new List <Upvc_Quotationitems>();
for (int r = 0; r < editgrid.RowCount; r++)
{
Upvc_Quotationitems obj = new Upvc_Quotationitems();
if (
(editgrid[UPVC_QUOTATIONITEMS.PRODUCT_ID, r].Value + "") == "" ||
(editgrid[UPVC_QUOTATIONITEMS.QTY, r].Value + "") == "" ||
(editgrid[UPVC_QUOTATIONITEMS.PRICE, r].Value + "") == ""
)
{
//==LEAVE IT(the empty row).
}
else
{
obj.Upvc_Quotationitems_id = "";
obj.Upvc_Quotation_id = vId;
obj.Product_id = CProduct_exten.GetId_Name(editgrid[UPVC_QUOTATIONITEMS.PRODUCT_ID, r].Value + "");
obj.Widths = (editgrid[UPVC_QUOTATIONITEMS.WIDTHS, r].Value + "");
obj.Heights = (editgrid[UPVC_QUOTATIONITEMS.HEIGHTS, r].Value + "");
obj.TotalAreasq = (editgrid[UPVC_QUOTATIONITEMS.TOTALAREASQ, r].Value + "");
obj.Qty = (editgrid[UPVC_QUOTATIONITEMS.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);
}
public static void Insert(List <Upvc_Quotationitems> list, DAL dalsession)
{
for (int i = 0; i < list.Count; i++)
{
Upvc_Quotationitems obj = new Upvc_Quotationitems()
{
Upvc_Quotation_id = list[i].Upvc_Quotation_id,
Product_id = list[i].Product_id,
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);
}
}
