public IEnumerable <ProductMasterModel> GetAllProductList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
//string path = "http://103.233.79.234/Data/EverGreen_Android/ProductPictures/";
var result = context.productmasters.OrderBy(p => p.ProductName);
var data = result.Select(p => new ProductMasterModel()
{
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(data);
}
}
public FeedbackModel GetCustomerFeedback(int customerid)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var cust = (from x in context.customermasters
join s in context.feedbackmasters on x.CustomerId equals s.CustomerId
join ccc in context.remarksmasters on x.CustomerId equals ccc.CustomerId into j1
from j2 in j1.DefaultIfEmpty()
where x.CustomerId == customerid
orderby x.CustomerName descending
select new FeedbackModel()
{
CustomerId = x.CustomerId,
CustomerName = x.CustomerName,
CustomerRemarks = j2.Remarks
}).First();
var feedbackdata = (from z in context.customermasters
join r in context.feedbackmasters on z.CustomerId equals r.CustomerId
where r.CustomerId == cust.CustomerId
orderby z.CustomerName descending
select new FeedbackDetailsModel()
{
AnswerId = (int)r.AnswerId,
QuestionId = (int)r.QuestionId
}).ToList();
cust.FeedbackData = feedbackdata;
return(cust);
}
}
public IEnumerable <CustomerBookedEventModel> AllBookedEventsOnADate(DateTime df)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
int year = df.Year;
int month = df.Month;
int day = df.Day;
//DateTime startDate = new DateTime(df.Year, df.Month, df.Day);
//DateTime endDate = new DateTime(df.Year, df.Month, df.Day);
var data = (from o in context.customerordermasters
join e in context.customereventmasters on o.CustomerId equals e.CustomerId into J1
from j2 in J1.DefaultIfEmpty()
join c in context.customermasters on o.CustomerId equals c.CustomerId into j3
from j4 in j3.DefaultIfEmpty()
where j2.EventDate.Value.Year == df.Year &&
j2.EventDate.Value.Month == df.Month &&
j2.EventDate.Value.Day == df.Day
select new CustomerBookedEventModel()
{
EventDate = (DateTime)j2.EventDate,
Time = j2.Time,
OrderId = o.OrderId,
OrderNumber = o.OrderNumber,
CustomerName = j4.CustomerName,
PhoneNumber = j4.PhoneNumber,
StoreId = (int)j2.StoreId,
}).ToList();
return(data);
}
}
//public ResponseStatus DeleteQuestionByID(int id)
//{
// ResponseStatus response = new ResponseStatus();
// using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
// {
// //questionmaster data = new questionmaster();
// var data = context.questionmasters.Find(id);
// if (data != null)
// {
// context.questionmasters.Remove(data);
// context.SaveChanges();
// response.isSuccess = true;
// response.serverResponseTime = System.DateTime.Now;
// }
// else
// {
// response.isSuccess = false;
// response.serverResponseTime = System.DateTime.Now;
// }
// }
// return response;
//}
public QuestionModel QuestionDisableEnable(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
questionmaster data = new questionmaster();
data.id = model.id;
data.StoreId = model.StoreId;
data.IsActive = model.IsActive;
context.questionmasters.Attach(data);
context.Entry(data).Property(x => x.IsActive).IsModified = true;
var result = context.SaveChanges();
int id = data.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).Select(t => new QuestionModel()
{
id = t.id,
QuestionId = (int)t.QuestionId,
Question = t.Question,
StoreId = (int)t.StoreId,
IsActive = t.IsActive
}).FirstOrDefault();
response = resultData;
}
}
return(response);
}
public QuestionModel QuestionUpdate(QuestionModel model)
{
QuestionModel data = new QuestionModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
questionmaster response = new questionmaster();
response.StoreId = model.StoreId;
response.QuestionId = model.QuestionId;
response.id = model.id;
response.Question = model.Question;
response.IsActive = model.IsActive;
context.Entry(response).State = System.Data.Entity.EntityState.Modified;
var result = context.SaveChanges();
int id = response.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).FirstOrDefault();
if (resultData != null)
{
data.id = resultData.id;
data.QuestionId = (int)resultData.QuestionId;
data.Question = resultData.Question;
data.StoreId = (int)resultData.StoreId;
data.IsActive = resultData.IsActive;
}
}
}
return(data);
}
public QuestionModel AddQuestion(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var qestionid = context.questionmasters.OrderByDescending(o => o.CreatedOn).Select(p => p.QuestionId).FirstOrDefault();
questionmaster data = new questionmaster();
data.QuestionId = qestionid + 1;
data.Question = model.Question;
data.StoreId = model.StoreId;
data.IsActive = model.IsActive;
context.questionmasters.Add(data);
var result = context.SaveChanges();
int id = data.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).FirstOrDefault();
response.id = resultData.id;
response.QuestionId = (int)resultData.QuestionId;
response.Question = resultData.Question;
response.StoreId = (int)resultData.StoreId;
response.IsActive = resultData.IsActive;
}
}
return(response);
}
public CategoryModel AddNewCategory(CategoryModel model)
{
//ResponseStatus respponse = new ResponseStatus();
CategoryModel data = new CategoryModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var ca = context.categorymasters.Find(model.CategoryId);
if (ca != null)
{
ca.CategoryName = model.CategoryName;
//ca.CategoryDescription = model.CategoryDescription;
var result = context.SaveChanges();
if (result > 0)
{
data.CategoryId = ca.CategoryId;
}
}
else
{
categorymaster c = new categorymaster();
c.CategoryName = model.CategoryName;
//c.MenuId = model.MenuId;
//c.StoreId = model.StoreId;
//c.CategoryDescription = model.CategoryDescription;
context.categorymasters.Add(c);
var result = context.SaveChanges();
if (result > 0)
{
data.CategoryId = c.CategoryId;
}
}
}
return(data);
}
public MenuModel AddNewMenu(MenuModel model)
{
//ResponseStatus respponse = new ResponseStatus();
MenuModel data = new MenuModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
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 IEnumerable <MenuSetUpMasterModel> RemoveSetupMenu(int id)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
context.menusetupmasters.Remove(context.menusetupmasters.Where(d => d.id == id).First());
var result = context.SaveChanges();
if (result > 0)
{
resultdata = (from ms in context.menusetupmasters
join me in context.menumasters on ms.menuid equals me.MenuId into j1
from j2 in j1.DefaultIfEmpty()
join cat in context.categorymasters on ms.categoryid equals cat.CategoryId into j3
from j4 in j3.DefaultIfEmpty()
join pro in context.productmasters on ms.Productid equals pro.ProductId into j5
from j6 in j5.DefaultIfEmpty()
orderby ms.createdon descending
select new MenuSetUpMasterModel()
{
id = ms.id,
MenuName = j2.MenuName,
CategoryName = j4.CategoryName,
ProductName = j6.ProductName,
CreatedOn = (DateTime)ms.createdon
}).ToList();
}
}
return(resultdata);
}
public IEnumerable <CustomerModel> GetAllCustomerList(DateTime df)
{
CustomerModel cust = new CustomerModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
DateTime startDate = new DateTime(df.Year, df.Month, df.Day, 0, 0, 0);
DateTime endDate = new DateTime(df.Year, df.Month, df.Day, 23, 59, 59);
var result = (from a in context.adminmasters
join c in context.customermasters on a.AdminId equals c.AdminId
where c.CreatedOn >= startDate && c.CreatedOn < endDate
select c).ToList();
var data = result.Select(s => new CustomerModel()
{
CustomerId = s.CustomerId,
CustomerName = s.CustomerName,
PhoneNumber = s.PhoneNumber,
Role = (int)s.Role,
CustomerEmailId = s.CustomerEmailId,
StoreId = (int)s.StoreId,
CreatedOn = (DateTime)s.CreatedOn
}).ToList();
return(data);
}
}
public void SendSmsOnBad(int customerid)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var customer = (from c in context.customermasters
where c.CustomerId == customerid
select new CustomerModel()
{
CustomerId = c.CustomerId,
CustomerName = c.CustomerName,
PhoneNumber = c.PhoneNumber,
}).FirstOrDefault();
var badfeedback = (from c in context.customermasters
join f in context.feedbackmasters on c.CustomerId equals f.CustomerId into j1
from j2 in j1.DefaultIfEmpty()
join q in context.questionmasters on j2.QuestionId equals q.QuestionId into j3
from j4 in j3.DefaultIfEmpty()
join a in context.answermasters on j2.AnswerId equals a.AnswerId into j5
from j6 in j5.DefaultIfEmpty()
where c.CustomerId == customerid && j6.AnswerId == 1
select new CustomerFeedbackMasterModel()
{
QuestionId = (int)j2.QuestionId,
QuestionName = j4.Question,
AnswerId = (int)j2.AnswerId,
AnswerName = j6.Answer
}).ToList();
var feedback = (from c in context.customermasters
join f in context.feedbackmasters on c.CustomerId equals f.CustomerId into j1
from j2 in j1.DefaultIfEmpty()
join q in context.questionmasters on j2.QuestionId equals q.QuestionId into j3
from j4 in j3.DefaultIfEmpty()
join a in context.answermasters on j2.AnswerId equals a.AnswerId into j5
from j6 in j5.DefaultIfEmpty()
where c.CustomerId == customerid && (j6.AnswerId == 2 || j6.AnswerId == 3 || j6.AnswerId == 4)
select new CustomerFeedbackMasterModel()
{
QuestionId = (int)j2.QuestionId,
QuestionName = j4.Question,
AnswerId = (int)j2.AnswerId,
AnswerName = j6.Answer
}).ToList();
if (customer.PhoneNumber != null)
{
if (badfeedback.Count() > 0)
{
SendSMS(customer, badfeedback);
}
if (feedback.Count() > 0)
{
//SendsmsToCustomer(customer);
}
}
}
}
public IEnumerable <CategoryModel> GetAllCategoryList(int menuid)
{
CategoryModel cust = new CategoryModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
//var category = (from g in context.categorymasters
// where g.StoreId == storeid
// orderby g.CategoryId
// select new CategoryModel()
// {
// CategoryId = g.CategoryId,
// CategoryName = g.CategoryName,
// // MenuId =x.MenuId,
// ProductData = (from s in context.categorymasters
// join r in context.productmasters on s.CategoryId equals r.CategoryId
// where s.StoreId == storeid && s.CategoryId == g.CategoryId
// orderby r.ProductId
// select new ProductModel()
// {
// ProductId = r.ProductId,
// ProductName = r.ProductName,
// FoodType = r.FoodType,
// Price = (decimal)r.Price,
// }).ToList(),
// }).ToList();
var category = (from ms in context.menusetupmasters
join c in context.categorymasters on ms.categoryid equals c.CategoryId into j1
from j2 in j1.DefaultIfEmpty()
where ms.menuid == menuid
orderby j2.CategoryName descending
select new CategoryModel()
{
CategoryId = j2.CategoryId,
CategoryName = j2.CategoryName,
ProductData = (from msm in context.menusetupmasters
join p in context.productmasters on msm.Productid equals p.ProductId into j3
from j4 in j3.DefaultIfEmpty()
where msm.menuid == menuid && msm.categoryid == j2.CategoryId
orderby j4.ProductName ascending
select new ProductModel()
{
ProductId = j4.ProductId,
ProductName = j4.ProductName,
FoodType = j4.FoodType,
Price = (decimal)j4.Price,
}).ToList()
}).ToList();
return(category.GroupBy(x => x.CategoryId)
.Select(g => g.First())
.ToList());
}
}
public IEnumerable <MenuSetUpMasterModel> GetAllMenuList(int menuid)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
if (menuid == 0)
{
resultdata = (from ms in context.menusetupmasters
join me in context.menumasters on ms.menuid equals me.MenuId into j1
from j2 in j1.DefaultIfEmpty()
join cat in context.categorymasters on ms.categoryid equals cat.CategoryId into j3
from j4 in j3.DefaultIfEmpty()
join pro in context.productmasters on ms.Productid equals pro.ProductId into j5
from j6 in j5.DefaultIfEmpty()
//where ms.menuid == menuid
orderby ms.createdon descending
select new MenuSetUpMasterModel()
{
id = ms.id,
MenuName = j2.MenuName,
CategoryName = j4.CategoryName,
ProductName = j6.ProductName,
CreatedOn = (DateTime)ms.createdon
}).ToList();
}
else
{
resultdata = (from ms in context.menusetupmasters
join me in context.menumasters on ms.menuid equals me.MenuId into j1
from j2 in j1.DefaultIfEmpty()
join cat in context.categorymasters on ms.categoryid equals cat.CategoryId into j3
from j4 in j3.DefaultIfEmpty()
join pro in context.productmasters on ms.Productid equals pro.ProductId into j5
from j6 in j5.DefaultIfEmpty()
where ms.menuid == menuid
orderby ms.createdon descending
select new MenuSetUpMasterModel()
{
id = ms.id,
MenuName = j2.MenuName,
CategoryName = j4.CategoryName,
ProductName = j6.ProductName,
CreatedOn = (DateTime)ms.createdon
}).ToList();
}
}
return(resultdata);
}
public IEnumerable <ExtraModel> GetAllExtraCharges(int storeid)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.extrachargemasters.Where(x => x.StoreId == storeid).OrderBy(s => s.ExtraId);
var data = result.Select(s => new ExtraModel()
{
ExtraId = s.ExtraId,
ExtraName = s.ExtraName
}).ToList();
return(data);
}
}
public IEnumerable <AnswerModel> GetAllAnswerList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.answermasters.OrderBy(s => s.Answer);
var data = result.Select(s => new AnswerModel()
{
AnswerId = s.AnswerId,
Answer = s.Answer
}).ToList();
return(data);
}
}
public FeedbackSummaryModel GetFeedbackSummary()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var data = (from c in context.customermasters
//where c.StoreId == storeid
select new FeedbackSummaryModel()
{
CustomerName = c.CustomerName,
StoreId = (int)c.StoreId
}).First();
//var questiondata = (from q in context.questionmasters
// orderby q.QuestionId ascending
// select new FeedbackQuestionModel()
// {
// QuestionId = (int)q.QuestionId,
// QuestionName = q.Question,
//AnswerData = (from aa in context.answermasters
// join fff in context.feedbackmasters on aa.AnswerId equals fff.AnswerId into j1
// from j2 in j1.DefaultIfEmpty()
// join cc in context.customermasters on j2.CustomerId equals cc.CustomerId into j3
// from j4 in j3.DefaultIfEmpty()
// where j4.StoreId == storeid
// //&& j2.QuestionId == 1
// group j2 by j2.AnswerId into grouped
// select new FeeddbackAnswerModel() { AnswerId = (int)grouped.Key, Answer = grouped.Count(t => t.AnswerId != null) })
var AnswerData = (from aa in context.answermasters
join fff in context.feedbackmasters on aa.AnswerId equals fff.AnswerId into j1
from j2 in j1.DefaultIfEmpty()
join cc in context.customermasters on j2.CustomerId equals cc.CustomerId into j3
from j4 in j3.DefaultIfEmpty()
join qq in context.questionmasters on j2.QuestionId equals qq.id into j5
from j6 in j5.DefaultIfEmpty()
//where j4.StoreId == storeid
group j2 by new { j2.QuestionId, j2.AnswerId } into g
select new FeeddbackAnswerModel
{
QuestionId = (int)g.Key.QuestionId,
QusetionName = (from q in context.questionmasters where q.QuestionId == (int)g.Key.QuestionId select q.Question).FirstOrDefault(),
AnswerId = (int)g.Key.AnswerId,
Answer = g.Count()
}).OrderBy(s => s.QuestionId).ToList();
// }).ToList();
data.AnswerData = AnswerData;
return(data);
}
}
public IEnumerable <QuestionModel> GetAllQuestionList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.questionmasters.OrderBy(s => s.QuestionId).Where(o => o.IsActive == "Y");
var data = result.Select(s => new QuestionModel()
{
id = s.id,
QuestionId = (int)s.QuestionId,
Question = s.Question
}).ToList();
return(data);
}
}
public AdvancePaymentModel GetAdvancePaymentDetails(AdvancePaymentModel model)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var data = context.advancemasters.Where(a => a.OrderNumber == model.OrderNumber).Select(s => new AdvancePaymentModel()
{
AdvanceId = s.AdvanceId,
StoreId = (int)s.StoreId,
OrderNumber = s.OrderNumber,
AdvancePrice = (decimal)s.AdvancePrice
}).FirstOrDefault();
return(data);
}
}
public UserLoginModel WebsiteLogin(string username, string password)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.website_login.Where(u => u.UserName == username && u.Password == password && u.IsActive == "Y")
.Select(u => new UserLoginModel()
{
UserID = u.UserId,
UserName = u.UserName,
FirstName = u.FisrtName,
LastName = u.LastName
}).FirstOrDefault();
return(result);
}
}
public IEnumerable <EventModel> GetAllEventList(int storeid)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.eventmasters.Where(x => x.StoreId == storeid).OrderBy(s => s.EventName);
var data = result.Select(s => new EventModel()
{
EventId = s.EventId,
EventName = s.EventName,
EventPrice = (decimal)s.EventPrice,
StoreId = (int)s.StoreId
}).ToList();
return(data);
}
}
public FeedbackModel AddFeedback(int customerid, int questionid, int anwserid)
{
FeedbackModel feedback = new FeedbackModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
feedbackmaster u = new feedbackmaster();
u.CustomerId = customerid;
u.QuestionId = questionid;
u.AnswerId = anwserid;
var cust = context.customermasters.Where(x => x.CustomerId == customerid).FirstOrDefault();
if (cust.CustomerId > 0)
{
var data = context.feedbackmasters.Where(x => x.CustomerId == u.CustomerId && x.QuestionId == u.QuestionId).FirstOrDefault();
if (data != null)
{
context.feedbackmasters.Where(x => x.CustomerId == u.CustomerId && x.QuestionId == u.QuestionId).ToList().ForEach(x => x.AnswerId = u.AnswerId);
//context.Entry(u).State = System.Data.Entity.EntityState.Modified;
//context.SaveChanges();
feedback.FeedbackId = data.FeedbackId;
feedback.CustomerId = (int)data.CustomerId;
feedback.QuestionId = (int)data.QuestionId;
feedback.AnswerId = (int)data.AnswerId;
feedback.CreatedOn = (DateTime)data.CreatedOn;
}
else
{
context.feedbackmasters.Add(u);
}
var result = context.SaveChanges();
if (result > 0)
{
var custdata = context.feedbackmasters.Where(x => x.CustomerId == u.CustomerId && x.QuestionId == u.QuestionId && x.AnswerId == anwserid).FirstOrDefault();
if (custdata != null)
{
feedback.FeedbackId = custdata.FeedbackId;
feedback.CustomerId = (int)custdata.CustomerId;
feedback.QuestionId = (int)custdata.QuestionId;
feedback.AnswerId = (int)custdata.AnswerId;
feedback.CreatedOn = (DateTime)custdata.CreatedOn;
}
}
}
return(feedback);
}
}
public CustomerModel AddCustomer(string phonenumber, int storeid, string customername)
{
CustomerModel cust = new CustomerModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
customermaster u = new customermaster();
u.PhoneNumber = phonenumber;
u.CustomerName = customername;
u.StoreId = storeid;
u.AdminId = 1;
u.Role = 1;
//var data = context.customermasters.Where(x => x.PhoneNumber == u.PhoneNumber && x.StoreId == u.StoreId).FirstOrDefault();
//if (data != null)
//{
// //context.customermasters.Where(p => p.PhoneNumber == u.PhoneNumber && p.StoreId == u.StoreId).ToList().ForEach(x => x.PhoneNumber = u.PhoneNumber);
// cust.CustomerId = Convert.ToInt32(data.CustomerId);
// //cust.CustomerName = custdata.CustomerName;
// //cust.PhoneNumber = custdata.PhoneNumber;
// //cust.Role = Convert.ToInt32(custdata.Role);
// //cust.CustomerEmailId = cust.CustomerEmailId;
// //user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + user.LoginID + "ProfilePicture.jpg";
//}
//else
//{
//context.customermasters.Add(u);
//}
context.customermasters.Add(u);
var result = context.SaveChanges();
//int id = u.CustomerId;
if (result > 0)
{
//var custdata = context.customermasters.Where(x => x.CustomerId == u.CustomerId).FirstOrDefault();
//if (custdata != null)
//{
cust.CustomerId = Convert.ToInt32(u.CustomerId);
//cust.CustomerName = custdata.CustomerName;
//cust.PhoneNumber = custdata.PhoneNumber;
//cust.Role = Convert.ToInt32(custdata.Role);
//cust.CustomerEmailId = cust.CustomerEmailId;
//user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + user.LoginID + "ProfilePicture.jpg";
//}
}
}
return(cust);
}
public UserModel UserLogin(string username, string password, int role)
{
UserModel data = new UserModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.usermasters.Where(x => x.UserName == username && x.Password == password && x.Role == role).FirstOrDefault();
if (result.LoginId > 0)
{
data.LoginId = result.LoginId;
data.UserName = result.UserName;
data.EmailId = result.EmailId;
data.Role = (int)result.Role;
}
return(data);
}
}
public IEnumerable <CategoryModel> GetAllCategoryList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
// string path = "http://103.233.79.234/Data/EverGreen_Android/CategoryPictures/";
var result = context.categorymasters.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 = path + c.CategoryId + "CategoryPictures.jpg",
}).ToList();
return(data);
}
}
public void SendSMS(CustomerModel customer, List <CustomerFeedbackMasterModel> badfeedback)
{
string receiverno = "";
if (badfeedback.Count() > 0)
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var smsreceiverlist = context.badfeedbacksmsmasters.OrderBy(x => x.MobileNo).Where(x => x.IsActive == "Y").ToList();
foreach (var i in smsreceiverlist)
{
receiverno += i.MobileNo + ",";
}
}
receiverno = receiverno.Trim(',');
//string receiverno = "8448172988,9811616927,9555740041";
string question = "";
int intno = 0;
foreach (var ques in badfeedback)
{
question += "\n" + ++intno + ". " + ques.QuestionName;
}
string bodymessage = "Customer Name:" + customer.CustomerName +
"\nCustomer PhoneNo: " + customer.PhoneNumber +
"\nBad Feedback Questions are: " + question;
string _user = HttpUtility.UrlEncode("shamsweet"); // API user name to send SMS
string _pass = HttpUtility.UrlEncode("12345"); // API password to send SMS
string _route = HttpUtility.UrlEncode("transactional");
string _senderid = HttpUtility.UrlEncode("WISHHH");
string _recipient = HttpUtility.UrlEncode(receiverno); // who will receive message
string _messageText = HttpUtility.UrlEncode(bodymessage); // text message
// Creating URL to send sms
string _createURL = "http://www.smsnmedia.com/api/push?user="******"&pwd=" + _pass + "&route=" + _route + "&sender=" + _senderid + "&mobileno=91" + _recipient + "&text=" + _messageText;
HttpWebRequest _createRequest = (HttpWebRequest)WebRequest.Create(_createURL);
// getting response of sms
HttpWebResponse myResp = (HttpWebResponse)_createRequest.GetResponse();
StreamReader _responseStreamReader = new StreamReader(myResp.GetResponseStream());
string responseString = _responseStreamReader.ReadToEnd();
_responseStreamReader.Close();
myResp.Close();
}
}
public ProductModel AddNewProduct(ProductModel model)
{
ProductModel data = new ProductModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var pr = context.productmasters.Find(model.ProductId);
if (pr != null)
{
//pr.CategoryId = model.CategoryId;
pr.ProductName = model.ProductName;
pr.Price = model.Price;
pr.FoodType = model.FoodType;
var result = context.SaveChanges();
if (result > 0)
{
data.ProductId = pr.ProductId;
}
}
else
{
productmaster p = new productmaster();
//p.CategoryId = model.CategoryId;
p.ProductName = model.ProductName;
p.Price = model.Price;
//p.GST = model.GST;
//p.Discount = model.Discount;
//p.TaxType = model.TaxType;
p.FoodType = model.FoodType;
//p.UOM = model.UOM;
//p.ProductDetails = model.ProductDetails;
//p.DeliveryCharge = model.DeliveryCharge;
context.productmasters.Add(p);
var result = context.SaveChanges();
if (result > 0)
{
data.ProductId = p.ProductId;
}
}
}
return(data);
}
public IEnumerable <MenuModel> GetAllMenuList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var data = (from z in context.menumasters
//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 z.MenuName descending
select new MenuModel()
{
MenuId = z.MenuId,
MenuName = z.MenuName,
MenuPrice = (decimal)z.MenuPrice,
MenuImageUrl = "http://103.233.79.234/Data/ShamSweetsFeedback_Android/MenuImage/" + z.MenuId + ".jpeg"
}).ToList();
return(data);
}
}
public IEnumerable <StoreModel> GetAllStoreList()
{
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
var result = context.storemasters.OrderBy(s => s.StoreName);
var data = result.Select(s => new StoreModel()
{
StoreId = s.StoreId,
StoreName = s.StoreName,
StoreEmailId = s.StoreEmailId,
StorePhoneNumber = s.StorePhoneNumber,
StoreAddress = s.StoreAddress,
//LocalityId = (int)s.LocalityId,
StorePicturesUrl = path + s.StoreId + "StorePictures.png",
//FavouriteStore = favouriteStore == s.StoreId ? true : false,
}).ToList();
return(data);
}
}
//public QuestionModel RearrangeQuestions(QuestionModel model)
//{
// QuestionModel response = new QuestionModel();
// using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
// {
// questionmaster data = new questionmaster();
// data.QuestionId = model.QuestionId;
// data.Question = model.Question;
// data.StoreId = model.StoreId;
// //data.IsActive = model.IsActive;
// context.questionmasters.Add(data);
// var result = context.SaveChanges();
// int id = data.id;
// if (result > 0)
// {
// var resultData = context.questionmasters.Where(s => s.id == id).FirstOrDefault();
// response.id = resultData.id;
// response.QuestionId = (int)resultData.QuestionId;
// response.Question = resultData.Question;
// response.StoreId = (int)resultData.StoreId;
// response.IsActive = resultData.IsActive;
// }
// }
// return response;
//}
public IEnumerable <QuestionModel> ArrangeQuestion(int questionid, int positionid)
{
IEnumerable <QuestionModel> response = null;
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
if (questionid > 0)
{
var moved = context.questionmasters.Where(q => q.QuestionId == positionid).FirstOrDefault();
if (moved != null)
{
var questions = context.questionmasters.ToList().OrderByDescending(q => q.QuestionId);
foreach (var q in questions)
{
var question = context.questionmasters.FirstOrDefault(s => s.id == q.id && s.QuestionId == q.QuestionId);
q.QuestionId++;
question.QuestionId = q.QuestionId;
context.SaveChanges();
}
}
var arrange = context.questionmasters.Where(q => q.id == questionid).FirstOrDefault();
arrange.QuestionId = positionid;
int result = context.SaveChanges();
if (result > 0)
{
var resultdata = context.questionmasters.ToList().OrderBy(q => q.id).Select(a => new QuestionModel()
{
id = a.id,
QuestionId = (int)a.QuestionId,
Question = a.Question,
IsActive = a.IsActive,
StoreId = (int)a.StoreId
});
response = resultdata;
}
}
}
return(response);
}
public RemarksModel AddRemarks(int customerid, int storeid, string remarks)
{
RemarksModel data = new RemarksModel();
using (shamsweetsfeedback_androidEntities context = new shamsweetsfeedback_androidEntities())
{
remarksmaster u = new remarksmaster();
u.CustomerId = customerid;
u.StoreId = storeid;
u.Remarks = remarks;
var cust = context.customermasters.Where(x => x.CustomerId == customerid).FirstOrDefault();
if (cust.CustomerId > 0)
{
context.remarksmasters.Add(u);
var result = context.SaveChanges();
if (result > 0)
{
data.RemarksId = u.RemarksId;
SendSmsOnBad(customerid);
}
}
}
return(data);
}
