public IEnumerable <CustomerModel> GetAllCustomerList(int storeid, DateTime df)
{
CustomerModel cust = new CustomerModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 a.StoreId == storeid && (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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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 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.id 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();
if (customer.PhoneNumber != null)
{
SendSMS(customer, feedback);
}
}
}
public IEnumerable <CustomerBookedEventModel> AllBookedEventsOnADate(DateTime df)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 FeedbackModel GetCustomerFeedback(int customerid, int storeid)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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.StoreId == storeid && 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 QuestionDisableEnable(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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,
PositionId = (int)t.PositionId,
Question = t.Question,
StoreId = (int)t.StoreId,
IsActive = t.IsActive
}).FirstOrDefault();
response = resultData;
}
}
return(response);
}
public IEnumerable <MenuSetUpMasterModel> RemoveSetupMenu(int id)
{
ResponseStatus response = new ResponseStatus();
List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 QuestionModel QuestionUpdate(QuestionModel model)
{
QuestionModel data = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
questionmaster response = new questionmaster();
response.StoreId = model.StoreId;
response.PositionId = model.PositionId;
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.PositionId = (int)resultData.PositionId;
data.Question = resultData.Question;
data.StoreId = (int)resultData.StoreId;
data.IsActive = resultData.IsActive;
}
}
}
return(data);
}
public IEnumerable <ProductMasterModel> GetAllProductList()
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 QuestionModel AddQuestion(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
var qestionid = context.questionmasters.OrderByDescending(o => o.CreatedOn).Select(p => p.PositionId).FirstOrDefault();
questionmaster data = new questionmaster();
data.PositionId = 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.PositionId = (int)resultData.PositionId;
response.Question = resultData.Question;
response.StoreId = (int)resultData.StoreId;
response.IsActive = resultData.IsActive;
}
}
return(response);
}
public ResponseStatus DeleteQuestionByID(int id)
{
ResponseStatus response = new ResponseStatus();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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;
//}
if (id > 0)
{
var deleteques = context.questionmasters.Where(q => q.id == id).FirstOrDefault();
if (deleteques != null)
{
var questions = context.questionmasters.ToList().OrderBy(q => q.PositionId);
foreach (var q in questions)
{
if (deleteques.PositionId > q.PositionId)
{
q.PositionId = deleteques.PositionId--;
}
else
{
q.PositionId = deleteques.PositionId++;
}
}
context.SaveChanges();
}
var delete = context.questionmasters.Find(id);
//context.questionmasters.Remove(delete);
delete.IsActive = "N";
int 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 IEnumerable <CategoryModel> GetAllCategoryList(int menuid)
{
CategoryModel cust = new CategoryModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 FeedbackSummaryModel GetFeedbackSummary(int storeid)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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.PositionId ascending
// select new FeedbackQuestionModel()
// {
// PositionId = (int)q.PositionId,
// 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.PositionId == 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.PositionId == (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 <ExtraModel> GetAllExtraCharges(int storeid)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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 AdvancePaymentModel GetAdvancePaymentDetails(AdvancePaymentModel model)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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 (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
var result = context.questionmasters.OrderBy(s => s.PositionId);
var data = result.Select(s => new QuestionModel()
{
id = s.id,
PositionId = (int)s.PositionId,
Question = s.Question,
IsActive = s.IsActive
}).ToList();
return(data);
}
}
public IEnumerable <EventModel> GetAllEventList(int storeid)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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, int storeid)
{
UserModel data = new UserModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
var result = context.usermasters.Where(x => x.UserName == username && x.Password == password && x.Role == role && x.StoreId == storeid).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 (evergreenfeedback_androidEntities context = new evergreenfeedback_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> feedback)
{
string receiverno = "";
if (feedback.Count() > 0)
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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(',');
// receiverno = "8448172988,9811616927,9555740041";
string question = "";
int intno = 0;
foreach (var ques in feedback)
{
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 QuestionModel RearrangeQuestions(QuestionModel model)
//{
// QuestionModel response = new QuestionModel();
// using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
// {
// questionmaster data = new questionmaster();
// data.PositionId = model.PositionId;
// 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.PositionId = (int)resultData.PositionId;
// 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 (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
if (questionid > 0)
{
var moved = context.questionmasters.Where(q => q.PositionId == positionid).FirstOrDefault();
if (moved != null)
{
var destansation = context.questionmasters.Where(q => q.id == questionid).FirstOrDefault();
moved.PositionId = destansation.PositionId;
context.SaveChanges();
//int seqno = 0;
//var questions = context.questionmasters.ToList().OrderBy(q => q.PositionId);
//foreach (var q in questions)
//{
// var question = context.questionmasters.FirstOrDefault(s => s.id == q.id && s.PositionId == q.PositionId);
// // ++seqno;
// question.PositionId = seqno;
// context.SaveChanges();
// seqno++;
//}
}
var arrange = context.questionmasters.Where(q => q.id == questionid).FirstOrDefault();
arrange.PositionId = positionid;
int result = context.SaveChanges();
if (result > 0)
{
var resultdata = context.questionmasters.ToList().OrderBy(q => q.id).Select(a => new QuestionModel()
{
id = a.id,
PositionId = (int)a.PositionId,
Question = a.Question,
IsActive = a.IsActive,
StoreId = (int)a.StoreId
});
response = resultdata;
}
}
}
return(response);
}
public IEnumerable <StoreModel> GetAllStoreList()
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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.jpg",
//FavouriteStore = favouriteStore == s.StoreId ? true : false,
}).ToList();
return(data);
}
}
public IEnumerable <MenuModel> GetAllMenuList()
{
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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/StoreFeedback_Android/MenuImage/" + z.MenuId + ".jpeg"
}).ToList();
return(data);
}
}
public RemarksModel AddRemarks(int customerid, int storeid, string remarks)
{
RemarksModel data = new RemarksModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_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);
}
public CustomerEventModel AddEventCustomer(CustomerEventModel model)
{
CustomerEventModel eventdata = new CustomerEventModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
int customerid;
customereventmaster u = new customereventmaster();
u.Gathering = model.Gathering;
u.Time = model.Time;
u.Comment = model.Comment;
u.StoreId = model.StoreId;
u.EventDate = model.EventDate;
//u.CustomerId = model.CustomerId;
customermaster c = new customermaster();
c.CustomerName = model.Name;
c.CustomerEmailId = model.Email;
c.PhoneNumber = model.Phone;
c.StoreId = model.StoreId;
//var cust = context.customermasters.Where(x=> x.PhoneNumber == model.Phone && x.StoreId == model.StoreId).FirstOrDefault();
//if (cust != null)
//{
// u.CustomerId = cust.CustomerId;
// eventdata.CustomerId = cust.CustomerId;
// eventdata.Name = cust.CustomerName;
// eventdata.Phone = cust.PhoneNumber;
// eventdata.Email = cust.CustomerEmailId;
// var eventresult = context.customereventmasters.Where(x => x.StoreId == cust.StoreId && x.CustomerId == cust.CustomerId).FirstOrDefault();
// if (eventresult != null)
// {
// context.Entry(eventresult).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
// eventdata.CustomerId = (int)eventresult.CustomerId;
// eventdata.StoreId = (int)eventresult.StoreId;
// eventdata.Gathering = (int)eventresult.Gathering;
// eventdata.Comment = eventresult.Comment;
// eventdata.EventDate = (DateTime)eventresult.EventDate;
// eventdata.Time = eventresult.Time;
// }
// else
// {
// context.customereventmasters.Add(u);
// }
// var result = context.SaveChanges();
// if (result > 0)
// {
// var data = context.customereventmasters.Where(x => x.StoreId == u.StoreId && x.CustomerId == cust.CustomerId).FirstOrDefault();
// eventdata.CustomerId = (int)data.CustomerId;
// eventdata.StoreId = (int)data.StoreId;
// eventdata.Gathering =(int) data.Gathering;
// eventdata.Comment = data.Comment;
// eventdata.EventDate = (DateTime)data.EventDate;
// eventdata.Time = data.Time;
// }
//}
//else
//{
context.customermasters.Add(c);
//}
var resultcust = context.SaveChanges();
var id = c.CustomerId;
if (resultcust > 0)
{
var cus = context.customermasters.Where(cs => cs.CustomerId == id).SingleOrDefault();
eventdata.CustomerId = cus.CustomerId;
eventdata.Name = cus.CustomerName;
eventdata.Phone = cus.PhoneNumber;
eventdata.Email = cus.CustomerEmailId;
eventdata.StoreId = (int)cus.StoreId;
//var eventresult = context.customereventmasters.Where(x => x.StoreId == model.StoreId && x.CustomerId == model.CustomerId).FirstOrDefault();
//if (eventresult != null)
//{
// context.Entry(eventresult).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
// eventdata.Gathering = (int)eventresult.Gathering;
// eventdata.Comment = eventresult.Comment;
// eventdata.StoreId = (int)eventresult.StoreId;
// eventdata.EventDate = (DateTime)eventresult.EventDate;
// eventdata.Time = eventresult.Time;
//}
//else
//{
u.CustomerId = cus.CustomerId;
context.customereventmasters.Add(u);
//}
var result = context.SaveChanges();
if (result > 0)
{
var data = context.customereventmasters.Where(x => x.StoreId == model.StoreId && x.CustomerId == cus.CustomerId).FirstOrDefault();
eventdata.Gathering = (int)data.Gathering;
eventdata.StoreId = (int)data.StoreId;
eventdata.Comment = data.Comment;
eventdata.EventDate = (DateTime)data.EventDate;
eventdata.Time = data.Time;
}
}
}
return(eventdata);
}
