private static List <Styleitems> EntityList(string q) { List <Styleitems> list = new List <Styleitems>(); using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { Styleitems obj = new Styleitems() { Styleitems_id = redr[STYLEITEMS.STYLEITEMS_ID].ToString(), Style_id = redr[STYLEITEMS.STYLE_ID].ToString(), Style_no = redr[STYLEITEMS.STYLE_NO].ToString(), Article_id = redr[ARTICLE.ARTICLE_NO].ToString(), Product_id = redr[PRODUCT.PRODUCT_NAME].ToString(), Colours_id = redr[COLOURS.COLOURS_NAME].ToString(), Sizes_id = redr[SIZES.SIZES_NAME].ToString(), Qty = redr[STYLEITEMS.QTY].ToString(), Price = ConvertTO.Decimal(redr[STYLEITEMS.PRICE].ToString()), Refered_id = redr[STYLEITEMS.REFERED_ID].ToString(), Locked = redr[STYLEITEMS.LOCKED].ToString(), }; list.Add(obj); } } return(list); }
public static void InsertSub(Styleitems v, DAL dalsession) { string q = " INSERT INTO " + STYLEITEMS.STYLEITEMS_TBL + " ( "; q += " " + STYLEITEMS.STYLE_ID + " \r\n "; q += "," + STYLEITEMS.STYLE_NO + " \r\n "; q += "," + STYLEITEMS.ARTICLE_ID + " \r\n "; q += "," + STYLEITEMS.PRODUCT_ID + " \r\n "; q += "," + STYLEITEMS.COLOURS_ID + " \r\n "; q += "," + STYLEITEMS.SIZES_ID + " \r\n "; q += "," + STYLEITEMS.QTY + " \r\n "; q += "," + STYLEITEMS.PRICE + " \r\n "; q += "," + STYLEITEMS.REFERED_ID + " \r\n "; q += "," + STYLEITEMS.LOCKED + " \r\n "; q += " ) VALUES ( "; q += " @" + STYLEITEMS.STYLE_ID + "@ \r\n "; q += ", @" + STYLEITEMS.STYLE_NO + "@ \r\n "; q += ", @" + STYLEITEMS.ARTICLE_ID + "@ \r\n "; q += ", @" + STYLEITEMS.PRODUCT_ID + "@ \r\n "; q += ", @" + STYLEITEMS.COLOURS_ID + "@ \r\n "; q += ", @" + STYLEITEMS.SIZES_ID + "@ \r\n "; q += ", @" + STYLEITEMS.QTY + "@ \r\n "; q += ", @" + STYLEITEMS.PRICE + "@ \r\n "; q += ", @" + STYLEITEMS.REFERED_ID + "@ \r\n "; q += ", @" + STYLEITEMS.LOCKED + "@ \r\n "; q += " ) \r\n "; q = AttachParams(q, v); dalsession.Execute(q); }
private static string AttachParams(string q, Styleitems v) { q = q.Replace("@" + STYLEITEMS.STYLE_ID + "@", "" + ConvertTO.SqlString(v.Style_id) + ""); q = q.Replace("@" + STYLEITEMS.STYLE_NO + "@", "" + ConvertTO.SqlString(v.Style_no) + ""); q = q.Replace("@" + STYLEITEMS.ARTICLE_ID + "@", "" + ConvertTO.SqlString(v.Article_id) + ""); q = q.Replace("@" + STYLEITEMS.PRODUCT_ID + "@", "" + ConvertTO.SqlString(v.Product_id) + ""); q = q.Replace("@" + STYLEITEMS.COLOURS_ID + "@", "" + ConvertTO.SqlString(v.Colours_id) + ""); q = q.Replace("@" + STYLEITEMS.SIZES_ID + "@", "" + ConvertTO.SqlString(v.Sizes_id) + ""); q = q.Replace("@" + STYLEITEMS.QTY + "@", "" + ConvertTO.SqlString(v.Qty) + ""); q = q.Replace("@" + STYLEITEMS.PRICE + "@", "" + ConvertTO.SqlDecimal(v.Price) + ""); q = q.Replace("@" + STYLEITEMS.REFERED_ID + "@", "" + ConvertTO.SqlString(v.Refered_id) + ""); q = q.Replace("@" + STYLEITEMS.LOCKED + "@", "" + ConvertTO.SqlString(v.Locked) + ""); return(q); }
public static void Insert(List <Styleitems> list, DAL dalsession) { for (int i = 0; i < list.Count; i++) { Styleitems obj = new Styleitems() { Style_id = list[i].Style_id, Style_no = list[i].Style_no, Article_id = list[i].Article_id, Product_id = list[i].Product_id, Colours_id = list[i].Colours_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 <Styleitems> Collectitems(string vId) { List <Styleitems> list = new List <Styleitems>(); for (int r = 0; r < editgrid.RowCount; r++) { Styleitems obj = new Styleitems(); if ( (editgrid[STYLEITEMS.PRODUCT_ID, r].Value + "") == "" || (editgrid[STYLEITEMS.QTY, r].Value + "") == "" || (editgrid[STYLEITEMS.PRICE, r].Value + "") == "" ) { //==LEAVE IT(the empty row). } else { obj.Styleitems_id = ""; obj.Style_id = vId; obj.Style_no = txt_style_no.Text; obj.Article_id = CArticle_exten.GetId_Name(editgrid[STYLEITEMS.ARTICLE_ID, r].Value + ""); obj.Product_id = CProduct_exten.GetId_Name(editgrid[STYLEITEMS.PRODUCT_ID, r].Value + ""); obj.Colours_id = CColours_exten.GetId_Name(editgrid[STYLEITEMS.COLOURS_ID, r].Value + ""); obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[STYLEITEMS.SIZES_ID, r].Value + ""); obj.Qty = (editgrid[STYLEITEMS.QTY, r].Value + ""); obj.Price = ConvertTO.Decimal(editgrid[STYLEITEMS.PRICE, r].Value + ""); obj.Refered_id = ""; obj.Locked = Core.Unlocked; list.Add(obj); } } if (list.Count != 0) { return(list); } return(null); }