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;
}
