public IEnumerable <ProductMasterModel> GetAllProductList()
{
using (storefeedback_androidEntities context = new storefeedback_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 ResponseStatus SaveCustomerData(CustomerEntryModel model)
{
ResponseStatus respponse = new ResponseStatus();
CategoryModel data = new CategoryModel();
using (storefeedback_androidEntities context = new storefeedback_androidEntities())
{
feedbackcustomermaster c = new feedbackcustomermaster();
c.CustomerName = model.CustomerName;
c.PhoneNumber = model.PhoneNumber;
c.EmailId = model.Email;
c.Address = model.Address;
context.feedbackcustomermasters.Add(c);
var result = context.SaveChanges();
if (result > 0)
{
respponse.isSuccess = true;
respponse.serverResponseTime = System.DateTime.Now;
}
else
{
respponse.isSuccess = false;
respponse.serverResponseTime = System.DateTime.Now;
}
}
return(respponse);
}
public CategoryModel AddNewCategory(CategoryModel model)
{
//ResponseStatus respponse = new ResponseStatus();
CategoryModel data = new CategoryModel();
using (storefeedback_androidEntities context = new storefeedback_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 FeedbackModel GetCustomerFeedback(int customerid)
{
using (storefeedback_androidEntities context = new storefeedback_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 QuestionModel AddQuestion(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (storefeedback_androidEntities context = new storefeedback_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 QuestionModel QuestionUpdate(QuestionModel model)
{
QuestionModel data = new QuestionModel();
using (storefeedback_androidEntities context = new storefeedback_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 MenuModel AddNewMenu(MenuModel model)
{
//ResponseStatus respponse = new ResponseStatus();
MenuModel data = new MenuModel();
using (storefeedback_androidEntities context = new storefeedback_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 ResponseStatus DeleteQuestionByID(int id)
//{
// ResponseStatus response = new ResponseStatus();
// using (storefeedback_androidEntities context = new storefeedback_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 (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <CustomerBookedEventModel> AllBookedEventsOnADate(DateTime df)
{
using (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <CustomerModel> GetAllCustomerList(DateTime df)
{
CustomerModel cust = new CustomerModel();
using (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <MenuSetUpMasterModel> RemoveSetupMenu(int id)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (storefeedback_androidEntities context = new storefeedback_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 void SendSmsOnBad(int customerid)
{
using (storefeedback_androidEntities context = new storefeedback_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, int storeid)
{
CategoryModel cust = new CategoryModel();
using (storefeedback_androidEntities context = new storefeedback_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 && ms.StoreId == storeid
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 && msm.StoreId == storeid
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 FeedbackSummaryModel GetFeedbackSummary()
{
using (storefeedback_androidEntities context = new storefeedback_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 <MenuSetUpMasterModel> GetAllMenuList(int storeid)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (storefeedback_androidEntities context = new storefeedback_androidEntities())
{
if (storeid == 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.StoreId == storeid
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 <AnswerModel> GetAllAnswerList()
{
using (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <ExtraModel> GetAllExtraCharges(int storeid)
{
using (storefeedback_androidEntities context = new storefeedback_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 <SmsReceiverModel> AllSmsReceiverList()
{
IEnumerable <SmsReceiverModel> list;
using (storefeedback_androidEntities context = new storefeedback_androidEntities())
{
return(list = context.smsreceivermasters.Where(a => a.IsActive == "Y").Select(s => new SmsReceiverModel()
{
ReceiverId = s.ReceiverId,
ReceiverName = s.Name,
PhoneNumber = s.PhoneNumber
}).ToList());
}
}
public AdvancePaymentModel GetAdvancePaymentDetails(AdvancePaymentModel model)
{
using (storefeedback_androidEntities context = new storefeedback_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 (storefeedback_androidEntities context = new storefeedback_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 <QuestionModel> GetAllQuestionList()
{
using (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <EventModel> GetAllEventList(int storeid)
{
using (storefeedback_androidEntities context = new storefeedback_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 UserModel UserLogin(string username, string password, int role)
{
UserModel data = new UserModel();
using (storefeedback_androidEntities context = new storefeedback_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 CustomerModel AddCustomer(string phonenumber, int storeid, string customername)
{
CustomerModel cust = new CustomerModel();
using (storefeedback_androidEntities context = new storefeedback_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 FeedbackModel AddFeedback(int customerid, int questionid, int anwserid)
{
FeedbackModel feedback = new FeedbackModel();
using (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <CategoryModel> GetAllCategoryList()
{
using (storefeedback_androidEntities context = new storefeedback_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 (storefeedback_androidEntities context = new storefeedback_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 IEnumerable <MenuSetUpMasterModel> SetupMenu(MenuSetupModel model)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (storefeedback_androidEntities context = new storefeedback_androidEntities())
{
var data = context.menusetupmasters.Where(w => w.menuid == model.MenuId && w.categoryid == model.CategoryId && w.Productid == model.ProductId).FirstOrDefault();
if (data != null)
{
}
else
{
menusetupmaster m = new menusetupmaster();
m.menuid = model.MenuId;
m.categoryid = model.CategoryId;
m.Productid = model.ProductId;
m.StoreId = model.StoreId;
context.menusetupmasters.Add(m);
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 ProductModel AddNewProduct(ProductModel model)
{
ProductModel data = new ProductModel();
using (storefeedback_androidEntities context = new storefeedback_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 <StoreModel> GetAllStoreList()
{
using (storefeedback_androidEntities context = new storefeedback_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);
}
}
