public static List <Quotationitems> FK_withoutJoin(string id, DAL DAL)
{
string q = " SELECT * FROM " + QUOTATIONITEMS.QUOTATIONITEMS_TBL + " \r\n";
q += " WHERE " + QUOTATIONITEMS.QUOTATIONITEMS_TBL + "." + QUOTATION.QUOTATION_ID + " = '" + id + "' \r\n";
q += " ORDER BY " + QUOTATIONITEMS.QUOTATIONITEMS_TBL + "." + QUOTATIONITEMS.QUOTATIONITEMS_ID + ";\r\n";
List <Quotationitems> list = new List <Quotationitems>();
using (IDataReader redr = new DAL().Listreader(q))
{
while (redr.Read() == true)
{
Quotationitems obj = new Quotationitems()
{
Quotationitems_id = redr[QUOTATIONITEMS.QUOTATIONITEMS_ID].ToString(),
Quotation_id = redr[QUOTATIONITEMS.QUOTATION_ID].ToString(),
Product_id = redr[QUOTATIONITEMS.PRODUCT_ID].ToString(),
Sizes_id = redr[QUOTATIONITEMS.SIZES_ID].ToString(),
Qty = redr[QUOTATIONITEMS.QTY].ToString(),
Price = ConvertTO.Decimal(redr[QUOTATIONITEMS.PRICE].ToString()),
Refered_id = redr[QUOTATIONITEMS.REFERED_ID].ToString(),
Locked = redr[QUOTATIONITEMS.LOCKED].ToString(),
};
list.Add(obj);
}
}
return(list);
}
private static List <Quotationitems> EntityList(string q)
{
List <Quotationitems> list = new List <Quotationitems>();
using (IDataReader redr = new DAL().Listreader(q))
{
while (redr.Read() == true)
{
Quotationitems obj = new Quotationitems()
{
Quotationitems_id = redr[QUOTATIONITEMS.QUOTATIONITEMS_ID].ToString(),
Quotation_id = redr[QUOTATIONITEMS.QUOTATION_ID].ToString(),
Product_id = redr[PRODUCT.PRODUCT_NAME].ToString(),
Sizes_id = redr[SIZES.SIZES_NAME].ToString(),
Qty = redr[QUOTATIONITEMS.QTY].ToString(),
Price = ConvertTO.Decimal(redr[QUOTATIONITEMS.PRICE].ToString()),
Refered_id = redr[QUOTATIONITEMS.REFERED_ID].ToString(),
Locked = redr[QUOTATIONITEMS.LOCKED].ToString(),
};
list.Add(obj);
}
}
return(list);
}
private static string AttachParams(string q, Quotationitems v)
{
q = q.Replace("@" + QUOTATIONITEMS.QUOTATION_ID + "@", "" + ConvertTO.SqlString(v.Quotation_id) + "");
q = q.Replace("@" + QUOTATIONITEMS.PRODUCT_ID + "@", "" + ConvertTO.SqlString(v.Product_id) + "");
q = q.Replace("@" + QUOTATIONITEMS.SIZES_ID + "@", "" + ConvertTO.SqlString(v.Sizes_id) + "");
q = q.Replace("@" + QUOTATIONITEMS.QTY + "@", "" + ConvertTO.SqlString(v.Qty) + "");
q = q.Replace("@" + QUOTATIONITEMS.PRICE + "@", "" + ConvertTO.SqlString((v.Price) + ""));
q = q.Replace("@" + QUOTATIONITEMS.REFERED_ID + "@", "" + ConvertTO.SqlString(v.Refered_id) + "");
q = q.Replace("@" + QUOTATIONITEMS.LOCKED + "@", "" + ConvertTO.SqlString(v.Locked) + "");
return(q);
}
public static void Insert(List <Quotationitems> list, DAL dalsession)
{
for (int i = 0; i < list.Count; i++)
{
Quotationitems obj = new Quotationitems()
{
Quotation_id = list[i].Quotation_id,
Product_id = list[i].Product_id,
Sizes_id = list[i].Sizes_id,
Qty = list[i].Qty,
Price = list[i].Price,
Refered_id = list[i].Refered_id,
Locked = list[i].Locked
};
InsertSub(obj, dalsession);
}
}
private List <Quotationitems> Collectitems(string vId)
{
List <Quotationitems> list = new List <Quotationitems>();
for (int r = 0; r < editgrid.RowCount; r++)
{
Quotationitems obj = new Quotationitems();
if (
(editgrid[QUOTATIONITEMS.PRODUCT_ID, r].Value + "") == "" ||
(editgrid[QUOTATIONITEMS.QTY, r].Value + "") == "" ||
(editgrid[QUOTATIONITEMS.PRICE, r].Value + "") == ""
)
{
//==LEAVE IT(the empty row).
}
else
{
obj.Quotationitems_id = "";
obj.Quotation_id = vId;
obj.Product_id = CProduct_exten.GetId_Name(Checks.Escape(editgrid[QUOTATIONITEMS.PRODUCT_ID, r].Value + ""));
obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[QUOTATIONITEMS.SIZES_ID, r].Value + "");
obj.Qty = (editgrid[QUOTATIONITEMS.QTY, r].Value + "");
obj.Price = ConvertTO.Decimal(editgrid[QUOTATIONITEMS.PRICE, r].Value + "");
obj.Refered_id = "";
obj.Locked = Core.Unlocked;
list.Add(obj);
}
}
if (list.Count != 0)
{
return(list);
}
return(null);
}
public static void InsertSub(Quotationitems v, DAL dalsession)
{
string q = " INSERT INTO " + QUOTATIONITEMS.QUOTATIONITEMS_TBL + " ( ";
q += " " + QUOTATIONITEMS.QUOTATION_ID + " \r\n ";
q += "," + QUOTATIONITEMS.PRODUCT_ID + " \r\n ";
q += "," + QUOTATIONITEMS.SIZES_ID + " \r\n ";
q += "," + QUOTATIONITEMS.QTY + " \r\n ";
q += "," + QUOTATIONITEMS.PRICE + " \r\n ";
q += "," + QUOTATIONITEMS.REFERED_ID + " \r\n ";
q += "," + QUOTATIONITEMS.LOCKED + " \r\n ";
q += " ) VALUES ( ";
q += " @" + QUOTATIONITEMS.QUOTATION_ID + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.PRODUCT_ID + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.SIZES_ID + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.QTY + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.PRICE + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.REFERED_ID + "@ \r\n ";
q += ", @" + QUOTATIONITEMS.LOCKED + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}