public HttpResponseMessage Login([FromBody] LoginBindingModel loginModel)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
tbUser tbUserModel = entities.tbUsers.Where(user => user.vcUserName == loginModel.UserName && user.vcPassword == loginModel.Password).FirstOrDefault();
if (tbUserModel != null)
{
string baseToken = loginModel.UserName + ':' + loginModel.Password;
string encodedToken = Convert.ToBase64String(Encoding.UTF8.GetBytes(baseToken));
UserBindingModel userModel = new UserBindingModel
{
Token = encodedToken,
UserKey = tbUserModel.kUser.ToString(),
UserName = tbUserModel.vcUserName.ToString(),
ClientKey = tbUserModel.kLookClient.ToString()
};
return(Request.CreateResponse(HttpStatusCode.OK, userModel));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Invalid username or password"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public static bool Login(string username, string password)
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
return(entities.tbUsers.Any(user => user.vcUserName == username && user.vcPassword == password));
}
}
public HttpResponseMessage Get()
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.tbInStoreLocations.ToList()));
}
}
public HttpResponseMessage Get(string serialNumber)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
var entity = entities.tbFrames.FirstOrDefault(row => row.vcSerialNumber == serialNumber);
if (entity != null)
{
FrameBindingModel frameModel = new FrameBindingModel
{
Frame = entity
};
if (entity.vcInstalled.ToString() != "Uninstalled")
{
frameModel.Fabrics = entities.tbFabrics.Where(row => row.kFrame == entity.kFrame).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, frameModel));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found with SerialNumber " + serialNumber));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage RemoveFabric(int id)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
var entity = entities.tbFabrics.FirstOrDefault(row => row.kFabric == id);
if (entity != null)
{
entities.tbFabrics.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found with key " + id.ToString()));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(int id, [FromBody] tbLookClient client)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
var entity = entities.tbLookClients.FirstOrDefault(row => row.kLookClient == id);
if (entity != null)
{
entity.vcClientName = client.vcClientName;
entity.kLookClient = client.kLookClient;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Artwork not found with key " + id.ToString()));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get()
{
//string username = Thread.CurrentPrincipal.Identity.Name;
using (TLC_DBEntities entities = new TLC_DBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.tbLookClients.ToList()));
}
}
public HttpResponseMessage GetByClientKey(int id = -1)
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
if (id > -1)
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.tbLookClientCustomers.Where(row => row.kLookClient == id).ToList()));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.tbLookClientCustomers.ToList()));
}
}
}
public HttpResponseMessage Get(int id)
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
var entity = entities.tbLookClientCustomers.FirstOrDefault(row => row.kLookClientCustomer == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found with key " + id.ToString()));
}
}
}
public HttpResponseMessage Post([FromBody] tbLookClient client)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
entities.tbLookClients.Add(client);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, client);
message.Headers.Location = new Uri(Request.RequestUri + client.kLookClient.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get(string filter = "All")
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (TLC_DBEntities entities = new TLC_DBEntities())
{
switch (filter.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.tbLookClients.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.tbLookClients.Where(row => row.vcClientName.ToLower() == "male").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Value for " + filter));
}
}
}
public HttpResponseMessage AddFabric([FromBody] FabricBindingModel fabricModel)
{
try
{
using (TLC_DBEntities entities = new TLC_DBEntities())
{
int maxKey = entities.tbFabrics.Max(row => row.kFabric);
var client = entities.tbLookClients.FirstOrDefault(row => row.kLookClient == fabricModel.ClientKey);
var frame = entities.tbFrames.FirstOrDefault(row => row.kFrame == fabricModel.FrameKey);
tbFabric fabric = new tbFabric
{
kFabric = maxKey + 1,
kLookClient = fabricModel.ClientKey,
kLookClientCustomer = fabricModel.ClientLocationKey,
kFrame = fabricModel.FrameKey,
vcSerialNumber = frame.vcSerialNumber,
vcExtrusion = fabricModel.Extrusion,
vcFileName = fabricModel.FileName,
intHeight = fabricModel.Height,
intWidth = fabricModel.Width,
vcClientID = client.vcClientID,
vcClientName = client.vcClientName
};
frame.vcInstalled = "Installed";
entities.tbFabrics.Add(fabric);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, fabric));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
