public ProductModel GetProductById(int id)
{
//ResponseStatus respponse = new ResponseStatus();
ProductModel data = new ProductModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
data = (from p in context.productmasters
join c in context.categorymasters on p.CategoryId equals c.CategoryId into j1
from j2 in j1.DefaultIfEmpty()
orderby p.CreatedOn
where p.ProductId == id
select new ProductModel()
{
ProductId = p.ProductId,
ProductName = p.ProductName,
CategoryId = (int)p.CategoryId,
CategoryName = j2.CategoryName,
UnitPrice = (decimal)p.UnitPrice,
GST = (decimal)p.GST,
Discount = (decimal)p.Discount,
TaxType = p.TaxType,
UOM = p.UOM,
HSN = p.HSN,
SweetsReset = p.SweetsReset,
ProductDetails = p.ProductDetails,
DeliveryCharge = (decimal)p.DeliveryCharge,
Lock = p.Lock == "Y" ? true : false,
ProductPicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProductPictures/" + p.ProductId + ".jpg",
}).FirstOrDefault();
}
return(data);
}
public IEnumerable <StoreModel> RemoveStore(int id)
{
//ResponseStatus response = new ResponseStatus();
List <StoreModel> data = new List <StoreModel>();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
context.storemasters.Remove(context.storemasters.Where(d => d.StoreId == id).First());
var result = context.SaveChanges();
if (result > 0)
{
data = (from s in context.storemasters
orderby s.StoreName
select new StoreModel()
{
StoreId = s.StoreId,
StoreName = s.StoreName,
StoreEmailId = s.StoreEmailId,
StorePhoneNumber = s.StorePhoneNumber,
StoreAddress = s.StoreAddress,
OpeningTime = (DateTime)s.OpeningTime,
ClosingTime = (DateTime)s.ClosingTime,
StoreStatus = s.StoreStatus == "Y" ? true : false,
StorePicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/StorePictures/" + s.StoreId + ".jpg",
}).ToList();
}
}
return(data);
}
public IEnumerable <LocalitiesModel> GetAllLocalitiesWithOutPagging()
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var data = (from lo in context.localitymasters
join st in context.storemasters on lo.StoreId1 equals st.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join st1 in context.storemasters on lo.StoreId2 equals st1.StoreId into j3
from j4 in j3.DefaultIfEmpty()
join st2 in context.storemasters on lo.StoreId3 equals st2.StoreId into j5
from j6 in j5.DefaultIfEmpty()
orderby lo.CreatedOn descending
//where lo.LocalityId == l.LocalityId
select new LocalitiesModel()
{
LocalityId = lo.LocalityId,
LocalityName = lo.LocalityName,
StoreName = j2.StoreName,
StoreName1 = j4.StoreName,
StoreName2 = j6.StoreName,
ImageUrl = "http://103.233.79.234/Data/ShamSweets_Android/LocalityPictures/" + lo.LocalityId + ".jpg",
}).ToList();
return(data);
}
}
public LocalitiesModel GetLocalityById(int id)
{
//ResponseStatus respponse = new ResponseStatus();
LocalitiesModel data = new LocalitiesModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
data = (from lo in context.localitymasters
join st in context.storemasters on lo.StoreId1 equals st.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join st1 in context.storemasters on lo.StoreId2 equals st1.StoreId into j3
from j4 in j3.DefaultIfEmpty()
join st2 in context.storemasters on lo.StoreId3 equals st2.StoreId into j5
from j6 in j5.DefaultIfEmpty()
orderby lo.CreatedOn descending
where lo.LocalityId == id
select new LocalitiesModel()
{
LocalityId = lo.LocalityId,
LocalityName = lo.LocalityName,
StoreName = j2.StoreName,
StoreName1 = j4.StoreName,
StoreName2 = j6.StoreName
}).FirstOrDefault();
}
return(data);
}
public StoreModel StoreClose(int id)
{
//ResponseStatus respponse = new ResponseStatus();
StoreModel data = new StoreModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var result = context.storemasters.Where(w => w.StoreId == id);
foreach (var item in result)
{
item.StoreStatus = "N";
}
context.SaveChanges();
data = (from s in context.storemasters
orderby s.StoreName
where s.StoreId == id
select new StoreModel()
{
StoreId = s.StoreId,
StoreName = s.StoreName,
StoreEmailId = s.StoreEmailId,
StorePhoneNumber = s.StorePhoneNumber,
StoreAddress = s.StoreAddress,
OpeningTime = (DateTime)s.OpeningTime,
ClosingTime = (DateTime)s.ClosingTime,
StoreStatus = s.StoreStatus == "Y" ? true : false,
StorePicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/StorePictures/" + s.StoreId + ".jpg",
}).FirstOrDefault();
}
return(data);
}
public IEnumerable <StoreModel> GetAllStoreList()
{
IEnumerable <StoreModel> data;
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var stores = (from s in context.storemasters
orderby s.StoreName
select new StoreModel()
{
StoreId = s.StoreId,
StoreName = s.StoreName,
StoreEmailId = s.StoreEmailId,
StorePhoneNumber = s.StorePhoneNumber,
StoreAddress = s.StoreAddress,
OpeningTime = (DateTime)s.OpeningTime,
ClosingTime = (DateTime)s.ClosingTime,
StoreStatus = s.StoreStatus == "Y" ? true : false,
StorePicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/StorePictures/" + s.StoreId + ".jpg",
//StorePicturesUrl = "http://localhost/Data/ShamSweets_Android/StorePictures/" + s.StoreId + ".jpg",
}).ToList();
data = stores;
}
return(data);
}
public IEnumerable <LocalitiesModel> RemoveLocality(int id)
{
ResponseStatus response = new ResponseStatus();
List <LocalitiesModel> data = new List <LocalitiesModel>();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
context.localitymasters.Remove(context.localitymasters.Where(d => d.LocalityId == id).First());
var result = context.SaveChanges();
if (result > 0)
{
data = (from lo in context.localitymasters
join st in context.storemasters on lo.StoreId1 equals st.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join st1 in context.storemasters on lo.StoreId2 equals st1.StoreId into j3
from j4 in j3.DefaultIfEmpty()
join st2 in context.storemasters on lo.StoreId3 equals st2.StoreId into j5
from j6 in j5.DefaultIfEmpty()
orderby lo.CreatedOn descending
//where lo.LocalityId == l.LocalityId
select new LocalitiesModel()
{
LocalityId = lo.LocalityId,
LocalityName = lo.LocalityName,
StoreName = j2.StoreName,
StoreName1 = j4.StoreName,
StoreName2 = j6.StoreName
}).ToList();
}
}
return(data);
}
public IEnumerable <MenuMasterModel> RemoveMenu(int id)
{
//ResponseStatus response = new ResponseStatus();
List <MenuMasterModel> data = new List <MenuMasterModel>();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
context.menumasters.Remove(context.menumasters.Where(d => d.MenuId == id).First());
var result = context.SaveChanges();
if (result > 0)
{
data = (from m in context.menumasters
join s in context.storemasters on m.StoreId equals s.StoreId into j1
from j2 in j1.DefaultIfEmpty()
orderby m.CreatedOn descending
select new MenuMasterModel()
{
MenuId = m.MenuId,
MenuName = m.MenuName,
MenuPrice = (decimal)m.MenuPrice,
StoreName = j2.StoreName
}).ToList();
}
}
return(data);
}
public ResponseStatus Login(string phoneNumber, int loginId)
{
ResponseStatus response = new ResponseStatus();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
registrationmaster u = new registrationmaster();
u.PhoneNumber = phoneNumber;
u.LoginID = loginId;
u.OTP = Convert.ToString(SendOTP(u.PhoneNumber));
var data = context.registrationmasters.Where(x => x.LoginID == u.LoginID && x.PhoneNumber == u.PhoneNumber).FirstOrDefault();
if (data != null)
{
context.registrationmasters.Where(p => p.LoginID == u.LoginID && p.PhoneNumber == u.PhoneNumber).ToList().ForEach(x => x.OTP = u.OTP);
}
var result = context.SaveChanges();
if (result > 0)
{
response.isSuccess = true;
response.serverResponseTime = System.DateTime.Now;
}
else
{
response.isSuccess = false;
response.serverResponseTime = System.DateTime.Now;
}
}
return(response);
}
public MenuMasterModel AddNewMenu(MenuMasterModel model)
{
//ResponseStatus respponse = new ResponseStatus();
MenuMasterModel data = new MenuMasterModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var me = context.menumasters.Find(model.MenuId);
if (me != null)
{
me.MenuName = model.MenuName;
me.MenuPrice = model.MenuPrice;
me.StoreId = model.StoreId;
var result = context.SaveChanges();
if (result > 0)
{
data.MenuId = me.MenuId;
}
}
else
{
menumaster m = new menumaster();
m.MenuName = model.MenuName;
m.MenuPrice = model.MenuPrice;
m.StoreId = model.StoreId;
context.menumasters.Add(m);
var result = context.SaveChanges();
if (result > 0)
{
data.MenuId = m.MenuId;
}
}
}
return(data);
}
public UserModel UpdateProfile(UserModel user)
{
UserModel resultdata = new UserModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
registrationmaster u = new registrationmaster();
u.LoginID = user.LoginID;
u.PhoneNumber = user.PhoneNumber;
u.Name = user.Name;
u.EmailID = user.EmailID;
//u.Role = user.Role;
context.Entry(u).State = System.Data.Entity.EntityState.Modified;
var result = context.SaveChanges();
if (result > 0)
{
var data = context.registrationmasters.Where(x => x.LoginID == user.LoginID).First();
if (data != null)
{
UserModel users = new UserModel();
users.LoginID = Convert.ToInt32(data.LoginID);
users.Name = data.Name;
users.PhoneNumber = data.PhoneNumber;
users.Otp = Convert.ToInt32(data.OTP);
users.Role = Convert.ToInt32(data.Role);
users.EmailID = data.EmailID;
users.ProfilePictureUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProfilePicture/" + user.LoginID + ".jpeg";
resultdata = users;
}
}
}
return(resultdata);
}
public AddressModel AddNewAddress(AddressModel model)
{
AddressModel data = new AddressModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
addressmaster a = new addressmaster();
a.CompleteAddress = model.CompleteAddress;
a.ZipCode = model.ZipCode;
a.LandMark = model.LandMark;
a.LoginID = model.LoginID;
a.PhoneNumber = model.PhoneNumber;
a.LocalityId = model.LocalityId;
context.addressmasters.Add(a);
var result = context.SaveChanges();
if (result > 0)
{
var addressdata = context.addressmasters.Where(z => z.LoginID == model.LoginID).OrderByDescending(x => x.AddressId).FirstOrDefault();
if (addressdata != null)
{
data.AddressId = addressdata.AddressId;
data.CompleteAddress = addressdata.CompleteAddress;
data.ZipCode = addressdata.ZipCode;
data.LandMark = addressdata.LandMark;
data.LoginID = (int)addressdata.LoginID;
data.PhoneNumber = addressdata.PhoneNumber;
data.LocalityId = (int)addressdata.LocalityId;
}
}
}
return(data);
}
public AddressModel UpdateAddress(AddressModel model)
{
AddressModel data = new AddressModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
addressmaster a = new addressmaster();
a.AddressId = model.AddressId;
a.CompleteAddress = model.CompleteAddress;
a.ZipCode = model.ZipCode;
a.LandMark = model.LandMark;
a.LoginID = model.LoginID;
a.PhoneNumber = model.PhoneNumber;
a.LocalityId = model.LocalityId;
context.Entry(a).State = System.Data.Entity.EntityState.Modified;
var result = context.SaveChanges();
if (result > 0)
{
var addressdata = context.addressmasters.Where(x => x.AddressId == model.AddressId).FirstOrDefault();
if (addressdata != null)
{
data.AddressId = addressdata.AddressId;
data.CompleteAddress = addressdata.CompleteAddress;
data.ZipCode = addressdata.ZipCode;
data.LandMark = addressdata.LandMark;
data.LoginID = (int)addressdata.LoginID;
data.PhoneNumber = addressdata.PhoneNumber;
data.LocalityId = (int)addressdata.LocalityId;
}
}
}
return(data);
}
public IEnumerable <ProductModel> GetAllProductList(int StoreId)
{
List <ProductModel> data = new List <ProductModel>();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
if (StoreId == 0)
{
data = (from p in context.productmasters
join c in context.categorymasters on p.CategoryId equals c.CategoryId into j1
from j2 in j1.DefaultIfEmpty()
where p.Lock == "N"
orderby p.CreatedOn
select new ProductModel()
{
ProductId = p.ProductId,
ProductName = p.ProductName,
CategoryId = (int)p.CategoryId,
CategoryName = j2.CategoryName,
UnitPrice = (decimal)p.UnitPrice,
GST = (decimal)p.GST,
Discount = (decimal)p.Discount,
TaxType = p.TaxType,
UOM = p.UOM,
HSN = p.HSN,
SweetsReset = p.SweetsReset,
ProductDetails = p.ProductDetails,
Lock = p.Lock == "Y" ? true : false,
ProductPicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProductPictures/" + p.ProductId + ".jpg",
}).ToList();
}
else
{
data = (from p in context.productmasters
join c in context.categorymasters on p.CategoryId equals c.CategoryId into j1
from j2 in j1.DefaultIfEmpty()
where j2.StoreId == StoreId && p.Lock == "N"
orderby p.CreatedOn
select new ProductModel()
{
ProductId = p.ProductId,
ProductName = p.ProductName,
CategoryId = (int)p.CategoryId,
CategoryName = j2.CategoryName,
UnitPrice = (decimal)p.UnitPrice,
GST = (decimal)p.GST,
Discount = (decimal)p.Discount,
TaxType = p.TaxType,
UOM = p.UOM,
HSN = p.HSN,
SweetsReset = p.SweetsReset,
ProductDetails = p.ProductDetails,
Lock = p.Lock == "Y" ? true : false,
ProductPicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProductPictures/" + p.ProductId + ".jpg",
}).ToList();
}
return(data);
}
}
public ResponseStatus RemoveFavouriteStoreByUser(int loginid)
{
ResponseStatus response = new ResponseStatus();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
if (loginid > 0)
{
var data = context.registrationmasters.FirstOrDefault(w => w.LoginID == loginid);
if (data != null)
{
data.FavouriteStoreId = 0;
context.SaveChanges();
response.isSuccess = true;
response.serverResponseTime = System.DateTime.Now;
}
else
{
response.isSuccess = false;
response.serverResponseTime = System.DateTime.Now;
}
}
}
return(response);
}
public PaymentModel PaymentConfirmforCOD(PaymentModel model)
{
PaymentModel data = new PaymentModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
transactionmaster t = new transactionmaster();
t.OrderNumber = model.OrderNumber;
t.LoginId = model.LoginId;
t.StoreId = model.StoreId;
t.PaymentMode = model.PaymentMode;
context.transactionmasters.Add(t);
var result = context.SaveChanges();
if (result > 0)
{
var payment = (from o in context.ordermasters
join tr in context.transactionmasters on o.OrderNumber equals tr.OrderNumber into j1
from j2 in j1.DefaultIfEmpty()
where o.OrderNumber == model.OrderNumber
select new PaymentModel()
{
Id = j2.Id,
OrderNumber = j2.OrderNumber,
TotalAmount = (decimal)o.TotalPrice,
PaymentMode = j2.PaymentMode
}).FirstOrDefault();
data = payment;
}
if (data.Id > 0)
{
SendSmsAndEmail(model.OrderNumber);
}
return(data);
}
}
public StoreModel AddNewStore(StoreModel model)
{
StoreModel data = new StoreModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var st = context.storemasters.Find(model.StoreId);
if (st != null)
{
st.LocalityId = model.LocalityId;
st.StoreName = model.StoreName;
st.StorePhoneNumber = model.StorePhoneNumber;
st.StoreEmailId = model.StoreEmailId;
st.StoreAddress = model.StoreAddress;
st.OpeningTime = model.OpeningTime;
st.ClosingTime = model.ClosingTime;
//s.StoreStatus = model.StoreStatus;
//if (model.StoreStatus)
//{
//st.StoreStatus = "Y";
//}
//else
//{
// st.StoreStatus = "N";
//}
var result = context.SaveChanges();
if (result > 0)
{
data.StoreId = st.StoreId;
}
}
else
{
storemaster s = new storemaster();
s.LocalityId = model.LocalityId;
s.StoreName = model.StoreName;
s.StorePhoneNumber = model.StorePhoneNumber;
s.StoreEmailId = model.StoreEmailId;
s.StoreAddress = model.StoreAddress;
s.OpeningTime = model.OpeningTime;
s.ClosingTime = model.ClosingTime;
//s.StoreStatus = model.StoreStatus;
//if (model.StoreStatus)
//{
s.StoreStatus = "Y";
//}
//else
//{
// s.StoreStatus = "N";
//}
context.storemasters.Add(s);
var result = context.SaveChanges();
if (result > 0)
{
data.StoreId = s.StoreId;
}
}
}
return(data);
}
public StoreModel GetFavouriteStoreByUser(int loginid)
{
StoreModel store = new StoreModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
store = (from u in context.registrationmasters
join s in context.storemasters on u.FavouriteStoreId equals s.StoreId
where u.LoginID == (long)loginid
select new StoreModel()
{
StoreId = s.StoreId,
StoreName = s.StoreName,
StoreEmailId = s.StoreEmailId,
StorePhoneNumber = s.StorePhoneNumber,
StoreAddress = s.StoreAddress,
OpeningTime = (DateTime)s.OpeningTime,
ClosingTime = (DateTime)s.ClosingTime,
StoreStatus = s.StoreStatus == "Y" ? true : false,
StorePicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/StorePictures/" + s.StoreId + ".jpg",
//FavouriteStore = s.StoreId == favouriteStore ? true : false,
Latitude = s.Latitude,
Longitude = s.Longitude,
}).FirstOrDefault();
}
return(store);
}
public IEnumerable <OrderModel> MyAllOrderList(int loginid)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var order = (from x in context.ordermasters
join s in context.orderstatusmasters on x.OrderStatusId equals s.OrderStatusId
join r in context.orderdetails on x.OrderNumber equals r.OrderNumber
join a in context.storemasters on x.StoreId equals a.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join p in context.promocodemasters on x.LoginId equals p.LoginId into j3
from j4 in j3.DefaultIfEmpty()
join t in context.transactionmasters on x.OrderNumber equals t.OrderNumber into j5
from j6 in j5.DefaultIfEmpty()
where x.LoginId == loginid && (j6.PaymentMode == "ONLINE" || j6.PaymentMode == "COD") && s.OrderStatusId == 3
orderby x.OrderId descending
select new OrderModel()
{
OrderId = x.OrderId,
OrderNumber = x.OrderNumber,
StoreId = (int)x.StoreId,
StoreName = j2.StoreName,
AddressId = (int)x.AddressId,
LoginId = (int)x.LoginId,
PromoCode = j4.PromoCode,
TotalPrice = (decimal)x.TotalPrice,
GrandTotal = (decimal)x.GrandTotal,
SpecialDiscount = (decimal)x.SpecialDiscount,
PromoDiscount = (decimal)x.Discount,
NetPrice = (decimal)x.NetAmount,
SubTotal = (decimal)x.SubTotal,
TotalGST = (decimal)x.TotalGST,
DeliveryCharge = (decimal)x.TotalDeliveryCharge,
OrderTime = (DateTime)x.CreatedOn,
OrderStatus = s.OrderStatus,
OrderDetails = (from z in context.ordermasters
join r in context.orderdetails on z.OrderNumber equals r.OrderNumber
join p in context.productmasters on r.ProductId equals p.ProductId into productDetails
from tempc in productDetails.DefaultIfEmpty()
where z.LoginId == loginid
orderby r.OrderDetailsId descending
select new OrderDetailsModel()
{
ProductName = tempc.ProductName,
UnitPrice = (decimal)tempc.UnitPrice,
ProductId = (int)r.ProductId,
Quantity = (decimal)r.Quantity,
UOM = tempc.UOM,
ProductPicturesUrl = path + r.ProductId + "ProductPictures.jpg"
}).ToList(),
}).ToList();
return(order.GroupBy(x => x.OrderId)
.Select(g => g.First())
.ToList());
}
}
public OrderModel GetOrderByOrderNumber(string ordernumber)
{
//OrderModel data = new OrderModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var order = (from x in context.ordermasters
join s in context.orderstatusmasters on x.OrderStatusId equals s.OrderStatusId
join p in context.promocodemasters on x.LoginId equals p.LoginId into j1
from j2 in j1.DefaultIfEmpty()
join st in context.storemasters on x.StoreId equals st.StoreId into j3
from j4 in j3.DefaultIfEmpty()
where x.OrderNumber == ordernumber
orderby x.OrderId descending
select new OrderModel()
{
OrderId = x.OrderId,
OrderNumber = x.OrderNumber,
StoreId = (int)x.StoreId,
StoreName = j4.StoreName,
AddressId = (int)x.AddressId,
LoginId = (int)x.LoginId,
PromoCode = j2.PromoCode,
TotalPrice = (decimal)x.TotalPrice,
GrandTotal = (decimal)x.GrandTotal,
SpecialDiscount = (decimal)x.SpecialDiscount,
PromoDiscount = (decimal)x.Discount,
NetPrice = (decimal)x.NetAmount,
SubTotal = (decimal)x.SubTotal,
TotalGST = (decimal)x.TotalGST,
OrderTime = (DateTime)x.CreatedOn,
OrderStatus = s.OrderStatus,
DeliveryCharge = (decimal)x.TotalDeliveryCharge,
}).First();
var orderdetails = (from z in context.ordermasters
join r in context.orderdetails on z.OrderNumber equals r.OrderNumber
join p in context.productmasters on r.ProductId equals p.ProductId
where r.OrderNumber == order.OrderNumber
orderby r.OrderDetailsId descending
select new OrderDetailsModel()
{
ProductName = p.ProductName,
UnitPrice = (decimal)p.UnitPrice,
ProductId = (int)r.ProductId,
Quantity = (decimal)r.Quantity,
UOM = p.UOM,
ProductPicturesUrl = path + r.ProductId + "ProductPictures.jpg"
}).ToList();
order.OrderDetails = orderdetails;
return(order);
}
}
public IEnumerable <CitiesModel> GetCitiesByState(int stateId)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var result = context.citymasters.Where(c => c.StateId == stateId).OrderBy(c => c.CityName);
var data = result.Select(c => new CitiesModel()
{
CityId = c.CityId,
CityName = c.CityName
}).ToList();
return(data);
}
}
public IEnumerable <StatesModel> GetAllStates()
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var result = context.statemasters.OrderBy(s => s.StateName);
var data = result.Select(s => new StatesModel()
{
StateId = s.StateId,
StateName = s.StateName
}).ToList();
return(data);
}
}
public IEnumerable <ProductModel> GetAllProductByCategory(int categoryid, int storeid)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
//string path = "http://103.233.79.234/Data/ShamSweets_Android/ProductPictures/";
var result = (from p in context.productmasters
join c in context.categorymasters on p.CategoryId equals c.CategoryId into j1
from j2 in j1.DefaultIfEmpty()
join s in context.storemasters on j2.StoreId equals s.StoreId into j3
from j4 in j3.DefaultIfEmpty()
where p.CategoryId == categoryid && j4.StoreId == storeid
orderby p.ProductName
select new ProductModel()
{
ProductId = p.ProductId,
ProductName = p.ProductName,
CategoryId = (int)p.CategoryId,
UnitPrice = (decimal)p.UnitPrice,
GST = (decimal)p.GST,
Discount = (decimal)p.Discount,
TaxType = p.TaxType,
UOM = p.UOM,
HSN = p.HSN,
SweetsReset = p.SweetsReset,
ProductDetails = p.ProductDetails,
Lock = p.Lock == "Y" ? true : false,
StoreId = j4.StoreId,
ProductPicturesUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProductPictures/" + p.ProductId + ".jpg",
}).ToList();
// var data = result.Select(p => new ProductModel()
// {
// ProductId = p.ProductId,
// ProductName = p.ProductName,
// CategoryId = (int)p.CategoryId,
// UnitPrice = (decimal)p.UnitPrice,
// GST = (decimal)p.GST,
// Discount = (decimal)p.Discount,
// TaxType = p.TaxType,
// UOM = p.UOM,
// HSN = p.HSN,
// SweetsReset = p.SweetsReset,
// ProductDetails = p.ProductDetails,
// Lock = p.Lock,
// //ProductPicturesUrl = path + p.ProductId + "ProductPictures.jpg",
//}).ToList();
return(result);
}
}
public UserModel Login(string phonenumber, string deviceid)
{
//ResponseStatus response = new ResponseStatus();
UserModel user = new UserModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
registrationmaster u = new registrationmaster();
var data = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber).FirstOrDefault();
if (data == null)
{
u.PhoneNumber = phonenumber;
u.OTP = Convert.ToString(SendOTP(u.PhoneNumber));
u.DeviceId = deviceid;
context.registrationmasters.Add(u);
//foreach (var item in data)
//{
// item.OTP = u.OTP;
// item.DeviceId = u.DeviceId;
//}
//context.registrationmasters.Where(p => p.PhoneNumber == u.PhoneNumber).ToList()
// .ForEach(x => x.OTP = u.OTP);
}
else
{
var userdata = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber);
foreach (var item in userdata)
{
item.OTP = Convert.ToString(SendOTP(phonenumber));
item.DeviceId = deviceid;
}
}
var result = context.SaveChanges();
if (result > 0)
{
var userdata = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber).FirstOrDefault();
if (userdata != null)
{
user.LoginID = Convert.ToInt32(userdata.LoginID);
user.Name = userdata.Name;
user.PhoneNumber = userdata.PhoneNumber;
user.Otp = Convert.ToInt32(userdata.OTP);
user.Role = Convert.ToInt32(userdata.Role);
user.EmailID = userdata.EmailID;
user.ProfilePictureUrl = "http://103.233.79.234/Data/ShamSweets_Android/ProfilePicture/" + userdata.LoginID + ".jpeg";
}
}
}
return(user);
}
public IEnumerable <LocalitiesModel> GetAllLocalitiesByCity(int cityid)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var result = context.localitymasters.OrderBy(l => l.LocalityName);
var data = result.Select(l => new LocalitiesModel()
{
LocalityId = l.LocalityId,
LocalityName = l.LocalityName,
ImageUrl = "http://103.233.79.234/Data/ShamSweets_Android/LocalityPictures/" + l.LocalityId + ".jpg",
}).ToList();
return(data);
}
}
public IEnumerable <CategoryModel> GetAllCategoryList(int StoreId)
{
List <CategoryModel> data = new List <CategoryModel>();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
if (StoreId == 0)
{
data = (from c in context.categorymasters
join s in context.storemasters on c.StoreId equals s.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join m in context.menumasters on c.MenuId equals m.MenuId into j3
from j4 in j3.DefaultIfEmpty()
orderby c.CreatedOn descending
select new CategoryModel()
{
CategoryId = c.CategoryId,
CategoryName = c.CategoryName,
CategoryDescription = c.CategoryDescription,
CategoryPictures = "http://103.233.79.234/Data/ShamSweets_Android/CategoryPictures/" + c.CategoryId + ".jpg",
StoreName = j2.StoreName,
MenuName = j4.MenuName
}).ToList();
}
else
{
data = (from c in context.categorymasters
join s in context.storemasters on c.StoreId equals s.StoreId into j1
from j2 in j1.DefaultIfEmpty()
join m in context.menumasters on c.MenuId equals m.MenuId into j3
from j4 in j3.DefaultIfEmpty()
where c.StoreId == StoreId
orderby c.CreatedOn descending
select new CategoryModel()
{
CategoryId = c.CategoryId,
CategoryName = c.CategoryName,
CategoryDescription = c.CategoryDescription,
CategoryPictures = "http://103.233.79.234/Data/ShamSweets_Android/CategoryPictures/" + c.CategoryId + ".jpg",
StoreName = j2.StoreName,
MenuName = j4.MenuName
}).ToList();
}
return(data);
}
}
public IEnumerable <CitiesModel> GetAllCities(int PageSize, int PageNumber)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
PageNumber = PageNumber > 0 ? PageNumber - 1 : 0;
PageSize = PageSize > 0 ? PageSize : 0;
var result = context.citymasters.OrderBy(c => c.CityId).Skip(PageNumber * PageSize).Take(PageSize);
var data = result.Select(c => new CitiesModel()
{
CityId = c.CityId,
CityName = c.CityName
}).ToList();
return(data);
}
}
public PromoCodeModel ApplyPromoCode(int loginid, string promocode)
{
PromoCodeModel data = new PromoCodeModel();
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
var result = context.promocodemasters.Where(x => x.LoginId == loginid && x.PromoCode == promocode).FirstOrDefault();
if (result.PromoCodeId > 0)
{
data.PromoCodeId = result.PromoCodeId;
data.PromoCode = result.PromoCode;
data.Discount = (decimal)result.Discount;
data.LoginId = (int)result.LoginId;
}
return(data);
}
}
public IEnumerable <CategoryModel> GetAllCategoryByStoreId(int storeid)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
//string path = "http://103.233.79.234/Data/ShamSweets_Android/CategoryPictures/";
var result = context.categorymasters.Where(c => c.StoreId == storeid).OrderBy(c => c.CategoryName);
var data = result.Select(c => new CategoryModel()
{
CategoryId = c.CategoryId,
CategoryName = c.CategoryName,
CategoryDescription = c.CategoryDescription,
StoreId = (int)c.StoreId,
CategoryPictures = "http://103.233.79.234/Data/ShamSweets_Android/CategoryPictures/" + c.CategoryId + ".jpg",
}).ToList();
return(data);
}
}
public IEnumerable <LocalitiesModel> GetAllLocalities(int PageSize, int PageNumber)
{
using (shamsweets_mobileappEntities context = new shamsweets_mobileappEntities())
{
PageNumber = PageNumber > 0 ? PageNumber - 1 : 0;
PageSize = PageSize > 0 ? PageSize : 0;
var result = context.localitymasters.OrderBy(l => l.LocalityId).Skip(PageNumber * PageSize).Take(PageSize);
var data = result.Select(l => new LocalitiesModel()
{
LocalityId = l.LocalityId,
LocalityName = l.LocalityName,
ImageUrl = "http://103.233.79.234/Data/ShamSweets_Android/LocalityPictures/" + l.LocalityId + ".jpg",
}).ToList();
return(data);
}
}
