public static int GetUser(string username)
{
using (ShottDB_BWEntities ent = new ShottDB_BWEntities())
{
return(5);//ent.aspnet_Users.Any(e => e.UserName.Equals(username));
}
}
public static bool login(string username, string password)
{
using (ShottDB_BWEntities ent = new ShottDB_BWEntities())
{
return(ent.aspnet_Users.Any(e => e.UserName.Equals(username, StringComparison.OrdinalIgnoreCase) && e.LoweredUserName == password));
}
}
//public HttpResponseMessage Get(int id)//AdvBook Get(int id)
//{
// using (ShottDB_BWEntities bw = new ShottDB_BWEntities())
// {
// var re= bw.AdvBooks.FirstOrDefault(n => n.SrNo == id);
// if (re != null)
// {
// return Request.CreateResponse(HttpStatusCode.OK, bw.AdvBooks.FirstOrDefault(n => n.SrNo == id));
// }
// else {
// HttpError er = new HttpError();
// er.ExceptionMessage = "Record not found";
// return Request.CreateResponse(HttpStatusCode.Created, er.ExceptionMessage);
// }
// }
// // return strings[id];
//}
public HttpResponseMessage Post([FromBody] AdvBook values)
{
try
{
using (ShottDB_BWEntities pst = new ShottDB_BWEntities())
{
values.QDate = DateTime.Now;
pst.AdvBooks.Add(values);
pst.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, values);
message.Headers.Location = new Uri(Request.RequestUri + values.SrNo.ToString());
return(message);
}
}
catch (Exception exe)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exe));
}
}
public HttpResponseMessage Get()
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (ShottDB_BWEntities entities = new ShottDB_BWEntities())
{
switch (username.ToLower())
{
case "admin":
return(Request.CreateResponse(HttpStatusCode.OK, entities.AdvBooks.Where(e => e.OrgId == "SRT").ToList()));
case "ankit":
return(Request.CreateResponse(HttpStatusCode.OK, entities.AdvBooks.Where(e => e.OrgId == "SBR").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
// return entities.AdvBooks.ToList();
}
}
