public CategoryModel AddNewCategory(CategoryModel model)
{
//ResponseStatus respponse = new ResponseStatus();
CategoryModel data = new CategoryModel();
using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 ResponseStatus DeleteQuestionByID(int id)
//{
// ResponseStatus response = new ResponseStatus();
// using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 AddQuestion(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 ProductModel AddNewProduct(ProductModel model)
{
ProductModel data = new ProductModel();
using (nathusfeedback_androidEntities context = new nathusfeedback_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 QuestionModel RearrangeQuestions(QuestionModel model)
//{
// QuestionModel response = new QuestionModel();
// using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 CustomerModel AddCustomer(string phonenumber, int storeid, string customername)
{
CustomerModel cust = new CustomerModel();
using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 RemarksModel AddRemarks(int customerid, int storeid, string remarks)
{
RemarksModel data = new RemarksModel();
using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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);
}