public HttpResponseMessage SelectCategory(HttpRequestMessage req, RP_SelectCategory rpSelectCategory) { if (rpSelectCategory != null) { RM_SelectCategory rmSelectCategory = new RM_SelectCategory(); List<RPR_SelectCategory> rprSelectCategory = rmSelectCategory.SelectCategory(rpSelectCategory); if (rmSelectCategory._IsSuccess) return req.CreateResponse<List<RPR_SelectCategory>>(HttpStatusCode.Created, rprSelectCategory); return req.CreateErrorResponse(HttpStatusCode.InternalServerError, "ServerError"); } return req.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request"); }
public List<RPR_SelectCategory> SelectCategory(RP_SelectCategory rpSelectCategory) { this.SpName = "DigitalMenu_SelectCategory"; //Sp Name _IsSuccess = true; try { SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@CategoryName", rpSelectCategory.CategoryName); param[1] = new SqlParameter("@key", rpSelectCategory.key); param[2] = new SqlParameter("@RestId", int.Parse(rpSelectCategory.RestId)); param[3] = new SqlParameter("@CusId", int.Parse(rpSelectCategory.CusId)); string catName = rpSelectCategory.CategoryName; ds = db.GetDataSet(this.SpName, param); if (ds != null && ds.Tables.Count > 0) { // used data set and data table DataTable Tables = new DataTable("items"); Tables.Columns.Add("ItemId"); Tables.Columns.Add("ItemName"); Tables.Columns.Add("ItemImage"); Tables.Columns.Add("CategoryId"); Tables.Columns.Add("ItemDesc"); Tables.Columns.Add("ItemPrice"); // loop through category foreach (DataRow dr in ds.Tables[0].Rows) { string ItemId = "" + dr["ItemId"].ToString(); string ItemName = "" + dr["ItemName"].ToString(); string CategoryId = "" + dr["CategoryId"].ToString(); string ItemDesc = "" + dr["ItemDesc"].ToString(); string ItemPrice = "" + dr["ItemPrice"].ToString(); string ItemImage = ""; if (catName != "") //chk catName { string absolutePath = @"F:\www\Pabulum\img\items\"; //string absolutePath = @"C:\inetpub\PabulumLatest\img\items\"; absolutePath += catName + "\\"; absolutePath += ItemName + ".txt"; // Path Used For Happy Hour Only if (File.Exists(absolutePath)) { ItemImage = File.ReadAllText(absolutePath); } else { // for Happy Hour Category string HappyHourCatPath = @"F:\www\Pabulum\img\category\"; HappyHourCatPath += catName + ".txt"; if (File.Exists(HappyHourCatPath)) { ItemImage = File.ReadAllText(HappyHourCatPath); } else { ItemImage = ""; } } Tables.Rows.Add(ItemId, ItemName, ItemImage, CategoryId, ItemDesc, ItemPrice); } else { Tables.Rows.Add(ItemId, ItemName, "", CategoryId, ItemDesc, ItemPrice); } } // foreach end DataSet dsNew = new DataSet("dataset"); dsNew.Tables.Add(Tables); rprSelectCategory = SerializeData.SerializeMultiValue<RPR_SelectCategory>(dsNew.Tables[0]); } } catch (Exception ex) { _IsSuccess = false; Logger.WriteLog(LogLevelL4N.ERROR, " Select Category | Exception : " + ex.Message); } return rprSelectCategory; }