public IEnumerable <UsersExpensesDetails_Result> Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.UsersExpensesDetails(Id).ToList()); } }
public IEnumerable <RoutesSalesSummary_Result> Get(Nullable <int> userId, Nullable <int> month, Nullable <int> year) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.RoutesSalesSummary(userId, month, year).ToList()); } }
public IEnumerable <UsersTodayOutelts_Result> Get(int id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.UsersTodayOutelts(id).ToList()); } }
public void Post([FromBody] InsertOrder addorder) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateOrder(addorder.Date, addorder.UserId, addorder.OutletId, addorder.DeliveryDate, addorder.Remarks, addorder.Longitude, addorder.Longitude); entities.SaveChanges(); } using (SalesForceEntities entities = new SalesForceEntities()) { ObjectResult <Nullable <int> > id = entities.GetOrderId(addorder.Date, addorder.UserId, addorder.OutletId); var item = id.First(); int i = Convert.ToInt32(item); //entities.CreatePayment(i, addorder.PaymentType, addorder.Amount); //entities.SaveChanges(); for (int x = 0; x < addorder.abc.Count; x++) { entities.CreateVanOrderProducts(i, addorder.abc[x].ProductId, addorder.abc[x].ProductQuantity); entities.SaveChanges(); //entities.UpdateProductAfterOrder(addorder.abc[x].ProductQuantity, addorder.abc[x].ProductId); //entities.SaveChanges(); } } }
public Nullable <double> Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { try { var x = entities.LatestOutstanding(Id).ToArray(); Nullable <double> y = x.Last(); return(y); } catch (Exception e) { return(0.0); } // if (entities.LatestOutstanding(Id) == null) // { // Nullable<double> a = 0.0; // return a; // } // else // { // var x = entities.LatestOutstanding(Id).ToArray(); // Nullable<double> y = x.Last(); // return y; // } } }
public List <OrderedProducts_Result> Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.OrderedProducts(Id).ToList()); } }
public List <OutstandingDetails_Result> Get() { using (SalesForceEntities entities = new SalesForceEntities()) { List <OutletDetails_Result> l = new List <OutletDetails_Result>(); l = entities.OutletDetails().ToList(); int count = l.Count(); int x = 0; List <OutstandingDetails_Result> list = new List <OutstandingDetails_Result>(); try { while (x < count) { OutstandingDetails_Result result1 = new OutstandingDetails_Result(); result1 = entities.OutstandingDetails(l[x].Id).Last(); list.Add(result1); x++; } } catch (Exception e) { } return(list); } }
public RouteDetails_Result Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.RouteDetails().FirstOrDefault(d => d.Id == Id));; } }
public IEnumerable <OutletsOfTheRoute_Result> Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.OutletsOfTheRoute(Id).ToList()); } }
public List <VanProductDetails_Result> Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.VanProductDetails(Id).ToList()); } }
public IEnumerable <OutletDetails_Result> Get() { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.OutletDetails().ToList()); } }
//public HttpResponseMessage Put(int Id, [FromBody] User user) //{ // try // { // using (SalesForceEntities entities = new SalesForceEntities()) // { // var entity = entities.Users.FirstOrDefault(d => d.Id == Id); // if (entity == null) // { // return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with " + Id.ToString() + " not found"); // } // else // { // entity.FirstName = user.FirstName; // entity.City = user.City; // entity.ContactNo = user.ContactNo; // entity.Email = user.Email; // entity.Gender = user.Gender; // entity.Lane = user.Lane; // entity.LastName = user.LastName; // entity.NIC = user.NIC; // entity.Passwords = user.Passwords; // entity.ResidenceNo = user.ResidenceNo; // entity.Username = user.Username; // entity.UserType = user.UserType; // entities.SaveChanges(); // return Request.CreateResponse(HttpStatusCode.OK, entity); // } // } // } // catch (Exception ex) // { // return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); // } public void Put([FromBody] InsertUser adduser) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateUser(adduser.Id, adduser.NIC, adduser.Username, adduser.Passwords, adduser.FirstName, adduser.LastName, adduser.ResidenceNo, adduser.Lane, adduser.City, adduser.ContactNo, adduser.Email, adduser.UserType, adduser.Gender); entities.SaveChanges(); } }
public void Put([FromBody] InsertProduct adddproduct) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateProduct(adddproduct.Id, adddproduct.Name, adddproduct.Brand, adddproduct.Category, adddproduct.ManufacturePrice, adddproduct.RetailPrice, adddproduct.Quantity, adddproduct.DiscountType); entities.SaveChanges(); } }
public void Post([FromBody] InsertLeave addleave) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.AddLeave(addleave.StartingDate, addleave.EndingDate, addleave.Reason, addleave.UserId); entities.SaveChanges(); } }
public void Put([FromBody] InsertRoute addroute) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateRoute(addroute.Id, addroute.Name, addroute.Description); entities.SaveChanges(); } }
public void Delete(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.DeleteRoute(Id); entities.SaveChanges(); } }
public void Put([FromBody] InsertVan addvan) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateVan(addvan.Id, addvan.VanType, addvan.RegistrationNo); entities.SaveChanges(); } }
public void Put([FromBody] string status, int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateExpenses(Id, status); entities.SaveChanges(); } }
public void Post([FromBody] InsertExpenses addexpense) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.AddExpense(addexpense.UserId, addexpense.Date, addexpense.Description, addexpense.Amount); entities.SaveChanges(); } }
public static bool Login(string username, string password) { using (SalesForceEntities entities = new SalesForceEntities()) { return(entities.Users.Any(User => User.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && User.Passwords == password)); } }
public LoginClass Get(string Username, String password) { using (SalesForceEntities entities = new SalesForceEntities()) { var entity = entities.UserDetails().FirstOrDefault(d => d.Username == Username); if (entity == null) { LoginClass response = new LoginClass(); response.Id = 0; response.FirstName = null; response.LastName = null; response.UserType = null; response.status = "No Username"; response.Image = null; response.Token = null; return(response); } else { if (entity.Passwords == password) { LoginClass response = new LoginClass(); response.Id = entity.Id; response.FirstName = entity.FirstName; response.LastName = entity.LastName; response.Email = entity.Email; response.UserType = entity.UserType; response.status = "Success"; response.Image = entity.Image; string txt = Username + ':' + password; var txtBytes = System.Text.Encoding.UTF8.GetBytes(txt); string token = System.Convert.ToBase64String(txtBytes); response.Token = token; return(response); } else { LoginClass response = new LoginClass(); response.Id = 0; response.FirstName = null; response.LastName = null; response.UserType = null; response.status = "Fail"; response.Image = null; response.Token = null; return(response); } } } }
public IEnumerable <UsersVanProductDetails_Result> Get(int UserId) { using (SalesForceEntities entities = new SalesForceEntities()) { Nullable <int> x = entities.UsersOutlets(UserId).First(); return(entities.UsersVanProductDetails(UserId, x).ToList()); } }
public List <SalesSummary1> Get(int id) { using (SalesForceEntities entities = new SalesForceEntities()) { List <SalesSummary1> summary = new List <SalesSummary1>(); List <OutletsSalesSummary_Result> l1 = new List <OutletsSalesSummary_Result>(); int count = 0; string k = DateTime.Now.Month.ToString(); int x = Convert.ToInt32(k); string l = DateTime.Now.Year.ToString(); int y = Convert.ToInt32(l); while (count < 12) { try { l1 = (entities.OutletsSalesSummary(id, x, y).ToList()); int c = l1.Count(); int d = 0; Nullable <double> amount = 0; while (d < c) { amount = amount + l1[d].Amount; d++; } SalesSummary1 sum = new SalesSummary1(amount, x, y); summary.Add(sum); } catch (Exception e) { } if (x > 1) { x--; } else { x = 12; y--; } count++; } return(summary); } }
public void Post([FromBody] InsertVanOrder addorder) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateVanOrder(addorder.Date, addorder.UserId, addorder.OutletId, addorder.Remarks, addorder.Longitude, addorder.Longitude); entities.SaveChanges(); } using (SalesForceEntities entities = new SalesForceEntities()) { ObjectResult <Nullable <int> > id = entities.GetOrderId(addorder.Date, addorder.UserId, addorder.OutletId); var item = id.First(); int i = Convert.ToInt32(item); entities.CreatePayment(i, addorder.PaymentType, addorder.Amount); entities.SaveChanges(); ObjectResult <Nullable <int> > a = entities.GetVanId(addorder.UserId); var b = a.First(); int j = Convert.ToInt32(b); Nullable <double> TotalCost = 0.0; for (int x = 0; x < addorder.abc.Count; x++) { entities.CreateVanOrderProducts2(i, addorder.abc[x].ProductId, addorder.abc[x].ProductQuantity, addorder.abc[x].OrderType); entities.SaveChanges(); Nullable <double> costperunit = entities.GetProductPrice(addorder.abc[x].ProductId).First(); Nullable <double> cost = costperunit * addorder.abc[x].ProductQuantity; TotalCost = TotalCost + cost; entities.UpdateProductAfterOrder(addorder.abc[x].ProductQuantity, addorder.abc[x].ProductId); entities.SaveChanges(); entities.UpdateVanProductAfterOrder(addorder.abc[x].ProductQuantity, addorder.abc[x].ProductId, j); } var p = entities.LatestOutstanding(addorder.OutletId).ToArray(); double y = (double)p.Last(); double Outstanding = (double)(TotalCost + y - addorder.Amount); entities.CreateOutstanding(addorder.Date, addorder.OutletId, Outstanding); entities.SaveChanges(); } }
public HttpResponseMessage Get(int Id) { using (SalesForceEntities entities = new SalesForceEntities()) { var entity = entities.OutletDetails().FirstOrDefault(d => d.Id == Id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Outlet with id " + Id + " not found")); } } }
public void Post([FromBody] InsertProduct2 adddproduct) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateProduct(adddproduct.Name, adddproduct.Brand, adddproduct.Category, adddproduct.ManufacturePrice, adddproduct.RetailPrice, adddproduct.Quantity, adddproduct.DiscountType); entities.SaveChanges(); List <ProductDetails_Result> l2 = entities.ProductDetails().ToList(); int a = l2.Count; List <VanDetails_Result> l1 = entities.VanDetails().ToList(); int x = l1.Count; int y = 0; while (y < x) { entities.createProductsToVan(l1[y].Id, l2[a - 1].Id, 0); y++; } } }
public void Post(InsertRoutesAndProducts add) { using (SalesForceEntities entities = new SalesForceEntities()) { var x = entities.AddOutletsOfRoutes(add.RouteId).ToArray(); int y = x.Count(); var date = add.Date1.Date; for (int i = 0; i < y; i++) { entities.CreateRouteHasOutlets(date, add.UserId, x[i], add.VanId); } int c = add.l1.Count(); for (int J = 0; J < c; J++) { entities.AddVanProducts(add.VanId, add.l1[J].Id, add.l1[J].Quantity); } } }
public HttpResponseMessage Post([FromBody] InsertOutlets addoutlet) { try { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateOutlet(addoutlet.Name, addoutlet.ContactNo, addoutlet.Barcode, addoutlet.Longitude, addoutlet.Latitude, addoutlet.OwnerName, addoutlet.Email, addoutlet.Status, addoutlet.RouteId); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, addoutlet); // message.Headers.Location = new Uri(Request.RequestUri + Outlet.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] InsertUser addusers) { try { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateUser(addusers.NIC, addusers.Username, addusers.Passwords, addusers.FirstName, addusers.LastName, addusers.ResidenceNo, addusers.Lane, addusers.City, addusers.ContactNo, addusers.Email, addusers.Gender, addusers.UserType); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, addusers); // message.Headers.Location = new Uri(Request.RequestUri + InsertUser.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put([FromBody] InsertOutlets addoutlet) { try { using (SalesForceEntities entities = new SalesForceEntities()) { var entity = entities.Outlets.FirstOrDefault(d => d.Id == addoutlet.Id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Outlet with " + addoutlet.Id.ToString() + " not found")); } else { entities.UpdateOutlets(addoutlet.Id, addoutlet.Name, addoutlet.ContactNo, addoutlet.Longitude, addoutlet.Latitude, addoutlet.OwnerName, addoutlet.Email, addoutlet.Status, addoutlet.RouteId); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }