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