public HttpResponseMessage GetOrderGuides()
{
Logger.WriteLine("Getting order Guides...");
var connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
int rowID = login.GetLoggedInUser.m_userRowID;
List <OrderGuides.OrderGuidesList> orderGuideList = new List <OrderGuides.OrderGuidesList>();
try
{
using (connect)
{
SqlCommand cmd = new SqlCommand("SELECT dbo.loginGroups.login_id, dbo.customerGroups.group_id, dbo.customerGroups.custCode, dbo.customerGroups.group_name , dbo.customerGroups.group_description FROM dbo.loginGroups INNER JOIN dbo.customerGroups ON dbo.loginGroups.group_id = dbo.customerGroups.group_id Where login_id = @userID", connect);
cmd.Parameters.AddWithValue("@userID", rowID);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
OrderGuides.OrderGuidesList ogl = new OrderGuides.OrderGuidesList();
ogl.name = row["group_description"].ToString();
ogl.groupID = Convert.ToInt16(row["group_id"]);
orderGuideList.Add(ogl);
}
}
}
var message = Request.CreateResponse(HttpStatusCode.OK, orderGuideList);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Fetching orderguides successful.");
return(message);
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ GetOrderGuides() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage GetDeletedGuides()
{
List <OrderGuides.OrderGuidesList> orderGuides = new List <OrderGuides.OrderGuidesList>();
DataTable dt = new DataTable();
try
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
using (connect)
{
SqlDataAdapter da = new SqlDataAdapter("Select Distinct GroupID,GroupName,GroupDescription From DeletedGuides where loginID = @loginID", connect);
da.SelectCommand.Parameters.AddWithValue("@loginID", login.GetLoggedInUser.m_userRowID);
da.Fill(dt);
}
foreach (DataRow dr in dt.Rows)
{
OrderGuides.OrderGuidesList og = new OrderGuides.OrderGuidesList();
og.groupID = Convert.ToInt32(dr["GroupID"]);
og.name = dr["GroupDescription"].ToString();
orderGuides.Add(og);
}
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ GetDeletedGuides() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
var message = Request.CreateResponse(HttpStatusCode.OK, orderGuides);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Getting Deleted Guides successful.");
return(message);
}
