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 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 IEnumerable <CustomerModel> GetAllCustomerList(DateTime df) { CustomerModel cust = new CustomerModel(); using (nathusfeedback_androidEntities context = new nathusfeedback_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 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 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 IEnumerable <CustomerBookedEventModel> AllBookedEventsOnADate(DateTime df) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 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<ProductMasterModel> GetAllProductList() { using (nathusfeedback_androidEntities context = new nathusfeedback_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 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 FeedbackModel GetCustomerFeedback(int customerid) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 void SendSmsOnBad(int customerid) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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() { using (nathusfeedback_androidEntities context = new nathusfeedback_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 <ExtraModel> GetAllExtraCharges(int storeid) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 <MenuSetUpMasterModel> GetAllMenuList(int menuid) { ResponseStatus response = new ResponseStatus(); List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>(); using (nathusfeedback_androidEntities context = new nathusfeedback_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 <AnswerModel> GetAllAnswerList() { using (nathusfeedback_androidEntities context = new nathusfeedback_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 UserLoginModel WebsiteLogin(string username, string password) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 IEnumerable <EventModel> GetAllEventList(int storeid) { using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 (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 IEnumerable <CategoryModel> GetAllCategoryList() { using (nathusfeedback_androidEntities context = new nathusfeedback_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 (nathusfeedback_androidEntities context = new nathusfeedback_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 (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 IEnumerable <StoreModel> GetAllStoreList() { using (nathusfeedback_androidEntities context = new nathusfeedback_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 IEnumerable <MenuModel> GetAllMenuList() { using (nathusfeedback_androidEntities context = new nathusfeedback_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/NathusFeedback_Android/MenuImage/" + z.MenuId + ".jpeg" }).ToList(); 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 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); }