public MenuMasterModel AddNewMenu(MenuMasterModel model) { //ResponseStatus respponse = new ResponseStatus(); MenuMasterModel data = new MenuMasterModel(); using (evergreen_androidEntities context = new evergreen_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 StoreModel AddNewStore(StoreModel model) { StoreModel data = new StoreModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var st = context.storemasters.Find(model.StoreId); if (st != null) { st.LocalityId = model.LocalityId; st.StoreName = model.StoreName; st.StorePhoneNumber = model.StorePhoneNumber; st.StoreEmailId = model.StoreEmailId; st.StoreAddress = model.StoreAddress; st.OpeningTime = model.OpeningTime; st.ClosingTime = model.ClosingTime; //s.StoreStatus = model.StoreStatus; //if (model.StoreStatus) //{ //st.StoreStatus = "Y"; //} //else //{ // st.StoreStatus = "N"; //} var result = context.SaveChanges(); if (result > 0) { data.StoreId = st.StoreId; } } else { storemaster s = new storemaster(); s.LocalityId = model.LocalityId; s.StoreName = model.StoreName; s.StorePhoneNumber = model.StorePhoneNumber; s.StoreEmailId = model.StoreEmailId; s.StoreAddress = model.StoreAddress; s.OpeningTime = model.OpeningTime; s.ClosingTime = model.ClosingTime; //s.StoreStatus = model.StoreStatus; //if (model.StoreStatus) //{ s.StoreStatus = "Y"; //} //else //{ // s.StoreStatus = "N"; //} context.storemasters.Add(s); var result = context.SaveChanges(); if (result > 0) { data.StoreId = s.StoreId; } } } return(data); }
public IEnumerable <StoreModel> RemoveStore(int id) { //ResponseStatus response = new ResponseStatus(); List <StoreModel> data = new List <StoreModel>(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { context.storemasters.Remove(context.storemasters.Where(d => d.StoreId == id).First()); var result = context.SaveChanges(); if (result > 0) { data = (from s in context.storemasters orderby s.StoreName select new StoreModel() { StoreId = s.StoreId, StoreName = s.StoreName, StoreEmailId = s.StoreEmailId, StorePhoneNumber = s.StorePhoneNumber, StoreAddress = s.StoreAddress, OpeningTime = (DateTime)s.OpeningTime, ClosingTime = (DateTime)s.ClosingTime, StoreStatus = s.StoreStatus == "Y" ? true : false, StorePicturesUrl = "http://103.233.79.234/Data/EverGreen_Android/StorePictures/" + s.StoreId + ".jpg", }).ToList(); } } return(data); }
public ResponseStatus Login(string phoneNumber, int loginId) { ResponseStatus response = new ResponseStatus(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { registrationmaster u = new registrationmaster(); u.PhoneNumber = phoneNumber; u.LoginID = loginId; u.OTP = Convert.ToString(SendOTP(u.PhoneNumber)); var data = context.registrationmasters.Where(x => x.LoginID == u.LoginID && x.PhoneNumber == u.PhoneNumber).FirstOrDefault(); if (data != null) { context.registrationmasters.Where(p => p.LoginID == u.LoginID && p.PhoneNumber == u.PhoneNumber).ToList().ForEach(x => x.OTP = u.OTP); } var 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 StoreModel StoreClose(int id) { //ResponseStatus respponse = new ResponseStatus(); StoreModel data = new StoreModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var result = context.storemasters.Where(w => w.StoreId == id); foreach (var item in result) { item.StoreStatus = "N"; } context.SaveChanges(); data = (from s in context.storemasters orderby s.StoreName where s.StoreId == id select new StoreModel() { StoreId = s.StoreId, StoreName = s.StoreName, StoreEmailId = s.StoreEmailId, StorePhoneNumber = s.StorePhoneNumber, StoreAddress = s.StoreAddress, OpeningTime = (DateTime)s.OpeningTime, ClosingTime = (DateTime)s.ClosingTime, StoreStatus = s.StoreStatus == "Y" ? true : false, StorePicturesUrl = "http://103.233.79.234/Data/EverGreen_Android/StorePictures/" + s.StoreId + ".jpg", }).FirstOrDefault(); } return(data); }
public AddressModel UpdateAddress(AddressModel model) { AddressModel data = new AddressModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { addressmaster a = new addressmaster(); a.AddressId = model.AddressId; a.CompleteAddress = model.CompleteAddress; a.ZipCode = model.ZipCode; a.LandMark = model.LandMark; a.LoginID = model.LoginID; a.PhoneNumber = model.PhoneNumber; a.LocalityId = model.LocalityId; context.Entry(a).State = System.Data.Entity.EntityState.Modified; var result = context.SaveChanges(); if (result > 0) { var addressdata = context.addressmasters.Where(x => x.AddressId == model.AddressId).FirstOrDefault(); if (addressdata != null) { data.AddressId = addressdata.AddressId; data.CompleteAddress = addressdata.CompleteAddress; data.ZipCode = addressdata.ZipCode; data.LandMark = addressdata.LandMark; data.LoginID = (int)addressdata.LoginID; data.PhoneNumber = addressdata.PhoneNumber; data.LocalityId = (int)addressdata.LocalityId; } } } return(data); }
public AddressModel AddNewAddress(AddressModel model) { AddressModel data = new AddressModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { addressmaster a = new addressmaster(); a.CompleteAddress = model.CompleteAddress; a.ZipCode = model.ZipCode; a.LandMark = model.LandMark; a.LoginID = model.LoginID; a.PhoneNumber = model.PhoneNumber; a.LocalityId = model.LocalityId; context.addressmasters.Add(a); var result = context.SaveChanges(); if (result > 0) { var addressdata = context.addressmasters.Where(z => z.LoginID == model.LoginID).OrderByDescending(x => x.AddressId).FirstOrDefault(); if (addressdata != null) { data.AddressId = addressdata.AddressId; data.CompleteAddress = addressdata.CompleteAddress; data.ZipCode = addressdata.ZipCode; data.LandMark = addressdata.LandMark; data.LoginID = (int)addressdata.LoginID; data.PhoneNumber = addressdata.PhoneNumber; data.LocalityId = (int)addressdata.LocalityId; } } } return(data); }
public UserModel UpdateProfile(UserModel user) { UserModel resultdata = new UserModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { registrationmaster u = new registrationmaster(); u.LoginID = user.LoginID; u.PhoneNumber = user.PhoneNumber; u.Name = user.Name; u.EmailID = user.EmailID; u.Role = user.Role; context.Entry(u).State = System.Data.Entity.EntityState.Modified; var result = context.SaveChanges(); if (result > 0) { var data = context.registrationmasters.Where(x => x.LoginID == user.LoginID).First(); if (data != null) { UserModel users = new UserModel(); users.LoginID = Convert.ToInt32(data.LoginID); users.Name = data.Name; users.PhoneNumber = data.PhoneNumber; users.Otp = Convert.ToInt32(data.OTP); users.Role = Convert.ToInt32(data.Role); users.EmailID = data.EmailID; users.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + user.LoginID + ".jpeg"; resultdata = users; } } } return(resultdata); }
public IEnumerable <LocalitiesModel> RemoveLocality(int id) { ResponseStatus response = new ResponseStatus(); List <LocalitiesModel> data = new List <LocalitiesModel>(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { context.localitymasters.Remove(context.localitymasters.Where(d => d.LocalityId == id).First()); var result = context.SaveChanges(); if (result > 0) { data = (from lo in context.localitymasters join st in context.storemasters on lo.StoreId1 equals st.StoreId into j1 from j2 in j1.DefaultIfEmpty() join st1 in context.storemasters on lo.StoreId2 equals st1.StoreId into j3 from j4 in j3.DefaultIfEmpty() join st2 in context.storemasters on lo.StoreId3 equals st2.StoreId into j5 from j6 in j5.DefaultIfEmpty() orderby lo.CreatedOn descending //where lo.LocalityId == l.LocalityId select new LocalitiesModel() { LocalityId = lo.LocalityId, LocalityName = lo.LocalityName, StoreName = j2.StoreName, StoreName1 = j4.StoreName, StoreName2 = j6.StoreName }).ToList(); } } return(data); }
public PaymentModel PaymentConfirmforCOD(PaymentModel model) { PaymentModel data = new PaymentModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { transactionmaster t = new transactionmaster(); t.OrderNumber = model.OrderNumber; t.LoginId = model.LoginId; t.StoreId = model.StoreId; t.PaymentMode = model.PaymentMode; context.transactionmasters.Add(t); var result = context.SaveChanges(); if (result > 0) { var payment = (from o in context.ordermasters join tr in context.transactionmasters on o.OrderNumber equals tr.OrderNumber into j1 from j2 in j1.DefaultIfEmpty() where o.OrderNumber == model.OrderNumber select new PaymentModel() { Id = j2.Id, OrderNumber = j2.OrderNumber, TotalAmount = (decimal)o.TotalPrice, PaymentMode = j2.PaymentMode }).FirstOrDefault(); data = payment; } if (data.Id > 0) { SendSmsAndEmail(model.OrderNumber); } return(data); } }
public ResponseStatus RemoveFavouriteStoreByUser(int loginid) { ResponseStatus response = new ResponseStatus(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { if (loginid > 0) { var data = context.registrationmasters.FirstOrDefault(w => w.LoginID == loginid); if (data != null) { data.FavouriteStoreId = 0; context.SaveChanges(); response.isSuccess = true; response.serverResponseTime = System.DateTime.Now; } else { response.isSuccess = false; response.serverResponseTime = System.DateTime.Now; } } } return(response); }
public IEnumerable <MenuMasterModel> RemoveMenu(int id) { //ResponseStatus response = new ResponseStatus(); List <MenuMasterModel> data = new List <MenuMasterModel>(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { context.menumasters.Remove(context.menumasters.Where(d => d.MenuId == id).First()); var result = context.SaveChanges(); if (result > 0) { data = (from m in context.menumasters join s in context.storemasters on m.StoreId equals s.StoreId into j1 from j2 in j1.DefaultIfEmpty() orderby m.CreatedOn descending select new MenuMasterModel() { MenuId = m.MenuId, MenuName = m.MenuName, MenuPrice = (decimal)m.MenuPrice, StoreName = j2.StoreName }).ToList(); } } return(data); }
public LocalitiesModel AddNewLocalityName(LocalitiesModel model) { //ResponseStatus respponse = new ResponseStatus(); LocalitiesModel data = new LocalitiesModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var lc = context.localitymasters.Find(model.LocalityId); if (lc != null) { lc.LocalityName = model.LocalityName; lc.StoreId1 = model.StoreId; lc.StoreId2 = model.StoreId1; lc.StoreId3 = model.StoreId2; var result = context.SaveChanges(); if (result > 0) { data.LocalityId = lc.LocalityId; data.LocalityName = lc.LocalityName; } } else { localitymaster l = new localitymaster(); l.LocalityName = model.LocalityName; l.StoreId1 = model.StoreId; l.StoreId2 = model.StoreId1; l.StoreId3 = model.StoreId2; context.localitymasters.Add(l); var result = context.SaveChanges(); if (result > 0) { data.LocalityId = l.LocalityId; data.LocalityName = l.LocalityName; } } } return(data); }
public UserModel Login(string phonenumber, string deviceid) { //ResponseStatus response = new ResponseStatus(); UserModel user = new UserModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { registrationmaster u = new registrationmaster(); var data = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber).FirstOrDefault(); if (data == null) { u.PhoneNumber = phonenumber; u.OTP = Convert.ToString(SendOTP(u.PhoneNumber)); u.DeviceId = deviceid; context.registrationmasters.Add(u); //foreach (var item in data) //{ // item.OTP = u.OTP; // item.DeviceId = u.DeviceId; //} //context.registrationmasters.Where(p => p.PhoneNumber == u.PhoneNumber).ToList() // .ForEach(x => x.OTP = u.OTP); } else { var userdata = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber); foreach (var item in userdata) { item.OTP = Convert.ToString(SendOTP(phonenumber)); item.DeviceId = deviceid; } } var result = context.SaveChanges(); if (result > 0) { var userdata = context.registrationmasters.Where(x => x.PhoneNumber == phonenumber).FirstOrDefault(); if (userdata != null) { user.LoginID = Convert.ToInt32(userdata.LoginID); user.Name = userdata.Name; user.PhoneNumber = userdata.PhoneNumber; user.Otp = Convert.ToInt32(userdata.OTP); user.Role = Convert.ToInt32(userdata.Role); user.EmailID = userdata.EmailID; user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + userdata.LoginID + ".jpeg"; } } } return(user); }
public CategoryModel AddNewCategory(CategoryModel model) { //ResponseStatus respponse = new ResponseStatus(); CategoryModel data = new CategoryModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var ca = context.categorymasters.Find(model.CategoryId); if (ca != null) { ca.CategoryName = model.CategoryName; ca.MenuId = model.MenuId; ca.StoreId = model.StoreId; 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 IEnumerable <MenuSetUpMasterModel> SetupMenu(MenuSetupModel model) { ResponseStatus response = new ResponseStatus(); List <MenuSetUpMasterModel> resultdata = new List <MenuSetUpMasterModel>(); using (evergreen_androidEntities context = new evergreen_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; 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 IEnumerable <ProductModel> ProductLockOff(int id) { ResponseStatus response = new ResponseStatus(); List <ProductModel> resultdata = new List <ProductModel>(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var result = context.productmasters.Where(w => w.ProductId == id); foreach (var item in result) { item.Lock = "N"; } var saved = context.SaveChanges(); if (saved > 0) { var data = (from p in context.productmasters join c in context.categorymasters on p.CategoryId equals c.CategoryId into j1 from j2 in j1.DefaultIfEmpty() orderby p.CreatedOn select new ProductModel() { ProductId = p.ProductId, ProductName = p.ProductName, CategoryId = (int)p.CategoryId, CategoryName = j2.CategoryName, 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 == "Y" ? true : false, ProductPicturesUrl = "http://103.233.79.234/Data/EverGreen_Android/ProductPictures/" + p.ProductId + ".jpg", }).ToList(); resultdata = data; } } return(resultdata); }
public ResponseStatus DeleteAddress(int addressid) { ResponseStatus response = new ResponseStatus(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { addressmaster address = new addressmaster(); address = context.addressmasters.Find(addressid); if (address != null) { context.addressmasters.Remove(address); context.SaveChanges(); response.isSuccess = true; response.serverResponseTime = System.DateTime.Now; } else { response.isSuccess = false; response.serverResponseTime = System.DateTime.Now; } } return(response); }
public IEnumerable <CategoryModel> RemoveCategory(int id) { ResponseStatus response = new ResponseStatus(); List <CategoryModel> data = new List <CategoryModel>(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { context.categorymasters.Remove(context.categorymasters.Where(d => d.CategoryId == id).First()); var result = context.SaveChanges(); if (result > 0) { data = (from c in context.categorymasters select new CategoryModel() { CategoryId = c.CategoryId, CategoryName = c.CategoryName, CategoryDescription = c.CategoryDescription, StoreId = (int)c.StoreId, CategoryPictures = "http://103.233.79.234/Data/EverGreen_Android/CategoryPictures/" + c.CategoryId + ".jpg", }).ToList(); } } return(data); }
public ProductModel AddNewProduct(ProductModel model) { ProductModel data = new ProductModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var pr = context.productmasters.Find(model.ProductId); if (pr != null) { pr.CategoryId = model.CategoryId; pr.ProductName = model.ProductName; pr.UnitPrice = model.UnitPrice; pr.GST = model.GST; pr.Discount = model.Discount; pr.TaxType = model.TaxType; if (model.Lock) { pr.Lock = "Y"; } else { pr.Lock = "N"; } pr.UOM = model.UOM; pr.ProductDetails = model.ProductDetails; pr.DeliveryCharge = model.DeliveryCharge; 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.UnitPrice = model.UnitPrice; p.GST = model.GST; p.Discount = model.Discount; p.TaxType = model.TaxType; if (model.Lock) { p.Lock = "Y"; } else { p.Lock = "N"; } 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 OrderModel CreateOrder(OrderModel model) { OrderModel data = new OrderModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var maxseq = 0; var first = context.ordermasters.Where(x => x.StoreId == model.StoreId).Select(s => s.OrderId).FirstOrDefault(); if (first == 0) { strSequnceNumber = "EVR00001"; } else { maxseq = context.ordermasters.Where(x => x.StoreId == model.StoreId).Max(s => s.OrderId); } if (maxseq != null && maxseq > 0) { strSequnceNumber = MakeIntoSequence(maxseq + 1, 8, "EVR"); } else { strSequnceNumber = "EVR00001"; } string strOrderNumber = strSequnceNumber; decimal grandtotal = 0; decimal deliverycharge = 0; decimal promocodediscount = 0; decimal specialdiscount = 0; decimal productprice = 0; decimal GSTvalue = 0; decimal productvalue = 0; decimal taxabale_value = 0; decimal gstvalue = 0; decimal productnetvalue = 0; decimal Itotal = 0; decimal Total = 0; decimal TotalDiscount = 0; decimal TotalGST = 0; decimal TotalSubTotal = 0; decimal TotalGrandTotal = 0; decimal NetPrice = 0; decimal TotalDeliveryCharge = 0; foreach (var pro in model.OrderDetails) { var product = (from p in context.productmasters where p.ProductId == pro.ProductId select p).FirstOrDefault(); if (product.TaxType != null && product.TaxType == "I") { productvalue = pro.Quantity * (decimal)product.UnitPrice; specialdiscount = (productvalue * (decimal)product.Discount / 100); taxabale_value = productvalue - specialdiscount; GSTvalue = taxabale_value * (decimal)product.GST / (100 + (decimal)product.GST); Itotal = taxabale_value - GSTvalue; productprice = (decimal)pro.Quantity * Itotal + GSTvalue; } else { productvalue = pro.Quantity * (decimal)product.UnitPrice; specialdiscount = (productvalue * (decimal)product.Discount / 100); taxabale_value = productvalue - specialdiscount; GSTvalue = taxabale_value * (decimal)product.GST / 100; productprice = taxabale_value + GSTvalue; } TotalDeliveryCharge += (decimal)product.DeliveryCharge; Total += productvalue; TotalDiscount += specialdiscount; TotalSubTotal += taxabale_value; TotalGST += GSTvalue; TotalGrandTotal += productprice; } if (model.PromoCodeId > 0) { promocodediscount = (decimal)(from p in context.promocodemasters where p.PromoCodeId == model.PromoCodeId && p.LoginId == model.LoginId select p.Discount).FirstOrDefault(); } else { promocodediscount = 0; } NetPrice = TotalGrandTotal + TotalDeliveryCharge - promocodediscount; ordermaster o = new ordermaster(); o.OrderNumber = strOrderNumber; o.StoreId = model.StoreId; o.AddressId = model.AddressId; o.LoginId = model.LoginId; o.TotalPrice = Total; o.GrandTotal = TotalGrandTotal; o.SpecialDiscount = TotalDiscount; o.Discount = promocodediscount; o.NetAmount = NetPrice; o.TotalGST = TotalGST; o.SubTotal = TotalSubTotal; o.TotalDeliveryCharge = TotalDeliveryCharge; o.OrderStatusId = 1; foreach (var product in model.OrderDetails) { orderdetail x = new orderdetail(); x.OrderNumber = strOrderNumber; x.ProductId = product.ProductId; x.Quantity = product.Quantity; context.orderdetails.Add(x); } context.ordermasters.Add(o); var result = context.SaveChanges(); var order = (from x in context.ordermasters join s in context.orderstatusmasters on x.OrderStatusId equals s.OrderStatusId join p in context.promocodemasters on x.LoginId equals p.LoginId into j1 from j2 in j1.DefaultIfEmpty() join c in context.registrationmasters on x.LoginId equals c.LoginID into j3 from j4 in j3.DefaultIfEmpty() join st in context.storemasters on x.StoreId equals st.StoreId into j5 from j6 in j5.DefaultIfEmpty() //join m in context.orderdetails on x.OrderNumber equals m.OrderNumber where x.LoginId == model.LoginId orderby x.OrderId descending select new OrderModel() { OrderId = x.OrderId, CustomerName = j4.Name, PhoneNumber = j4.PhoneNumber, EmailId = j4.EmailID, DeviceId = j4.DeviceId, OrderNumber = x.OrderNumber, StoreId = (int)x.StoreId, StoreName = j6.StoreName, StorePhoneNumber = j6.StorePhoneNumber, AddressId = (int)x.AddressId, LoginId = (int)x.LoginId, PromoCode = j2.PromoCode, TotalPrice = (decimal)x.TotalPrice, GrandTotal = (decimal)x.GrandTotal, SpecialDiscount = (decimal)x.SpecialDiscount, PromoDiscount = (decimal)x.Discount, NetPrice = (decimal)x.NetAmount, SubTotal = (decimal)x.SubTotal, TotalGST = (decimal)x.TotalGST, OrderTime = (DateTime)x.CreatedOn, OrderStatus = s.OrderStatus, DeliveryCharge = (decimal)x.TotalDeliveryCharge, }).First(); var orderdetails = (from z in context.ordermasters join r in context.orderdetails on z.OrderNumber equals r.OrderNumber join p in context.productmasters on r.ProductId equals p.ProductId where r.OrderNumber == order.OrderNumber orderby r.OrderDetailsId descending select new OrderDetailsModel() { ProductName = p.ProductName, UnitPrice = (decimal)p.UnitPrice, ProductId = (int)r.ProductId, Quantity = (decimal)r.Quantity, UOM = p.UOM, //ProductPicturesUrl = path + r.ProductId + "ProductPictures.jpg" }).ToList(); order.OrderDetails = orderdetails; return(order); } }
public UserModel SocialUserLogin(UserModel model) { UserModel user = new UserModel(); registrationmaster us = new registrationmaster(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var data = context.registrationmasters.Where(x => x.PhoneNumber == model.PhoneNumber).FirstOrDefault(); if (data != null) { us = context.registrationmasters.Find(data.LoginID); if (us != null) { us.Name = model.Name; us.PhoneNumber = model.PhoneNumber; us.OTP = Convert.ToString(SendOTP(model.PhoneNumber)); us.Role = Convert.ToInt32(model.Role); us.FbToken = model.FbToken; us.EmailID = model.EmailID; us.DeviceId = model.DeviceId; try { //user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + us.LoginID + ".jpeg"; string path = "C:/inetpub/wwwroot/Data/EverGreen_Android/EverGreenProfilePicture/" + model.LoginID + ".jpeg"; var bytess = Convert.FromBase64String(user.ProfilePictureUrl); using (var imageFile = new FileStream(path, FileMode.Create)) { imageFile.Write(bytess, 0, bytess.Length); imageFile.Flush(); } } catch (Exception ex) { } var r = context.SaveChanges(); if (r > 0) { user.LoginID = Convert.ToInt32(us.LoginID); user.Name = us.Name; user.PhoneNumber = us.PhoneNumber; user.Otp = Convert.ToInt32(us.OTP); user.Role = Convert.ToInt32(us.Role); user.FbToken = us.FbToken; user.EmailID = us.EmailID; user.DeviceId = us.DeviceId; user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + us.LoginID + ".jpeg"; } return(user); } } else { registrationmaster u = new registrationmaster(); u.Name = model.Name; u.PhoneNumber = model.PhoneNumber; u.EmailID = model.EmailID; u.FbToken = model.FbToken; u.OTP = Convert.ToString(SendOTP(model.PhoneNumber)); u.DeviceId = model.DeviceId; context.registrationmasters.Add(u); var result = context.SaveChanges(); if (result > 0) { var userdata = context.registrationmasters.Where(x => x.PhoneNumber == model.PhoneNumber).FirstOrDefault(); if (userdata != null) { try { string path = "C:/inetpub/wwwroot/Data/EverGreen_Android/EverGreenProfilePicture/" + u.LoginID + ".jpeg"; var bytess = GetBytes(model.ProfilePictureUrl); using (var imageFile = new FileStream(path, FileMode.Create)) { imageFile.Write(bytess, 0, bytess.Length); imageFile.Flush(); } } catch (Exception ex) { } user.LoginID = Convert.ToInt32(userdata.LoginID); user.Name = userdata.Name; user.PhoneNumber = userdata.PhoneNumber; user.Otp = Convert.ToInt32(userdata.OTP); user.Role = Convert.ToInt32(userdata.Role); user.FbToken = userdata.FbToken; user.EmailID = userdata.EmailID; user.DeviceId = us.DeviceId; user.ProfilePictureUrl = "http://103.233.79.234/Data/EverGreen_Android/EverGreenProfilePicture/" + userdata.LoginID + ".jpeg"; } } } } return(user); }
public StoreModel AddUpdateFavouriteStoreByUser(int loginid, int storeid) { StoreModel store = new StoreModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { if (loginid > 0 && storeid > 0) { var data = context.registrationmasters.Where(w => w.LoginID.Equals(loginid)); foreach (var item in data) { item.FavouriteStoreId = storeid; } try { var resultdata = context.SaveChanges(); if (resultdata > 0) { var favouriteStore = (from s in context.storemasters join u in context.registrationmasters on s.StoreId equals u.FavouriteStoreId into jointable from z in jointable.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId1 into j1 //from j2 in j1.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId2 into j3 //from j4 in j1.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId1 into j5 //from j6 in j1.DefaultIfEmpty() where z.LoginID == loginid && s.StoreStatus == "Y" orderby s.StoreName select z.FavouriteStoreId).SingleOrDefault(); var result = (from u in context.registrationmasters join s in context.storemasters on u.FavouriteStoreId equals s.StoreId where u.LoginID == (long)loginid && u.FavouriteStoreId == storeid select new StoreModel() { StoreId = s.StoreId, StoreName = s.StoreName, StoreStatus = s.StoreStatus == "Y" ? true : false, OpeningTime = (DateTime)s.OpeningTime, ClosingTime = (DateTime)s.ClosingTime, StoreEmailId = s.StoreEmailId, StorePhoneNumber = s.StorePhoneNumber, StoreAddress = s.StoreAddress, StorePicturesUrl = "http://103.233.79.234/Data/EverGreen_Android/StorePictures/" + s.StoreId + ".jpg", FavouriteStore = s.StoreId == favouriteStore ? true : false, }).FirstOrDefault(); store = result; } else { var favouriteStore = (from s in context.storemasters join u in context.registrationmasters on s.StoreId equals u.FavouriteStoreId into jointable from z in jointable.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId1 into j1 //from j2 in j1.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId2 into j3 //from j4 in j1.DefaultIfEmpty() //join l in context.localitymasters on s.StoreId equals l.StoreId1 into j5 //from j6 in j1.DefaultIfEmpty() where z.LoginID == loginid && s.StoreStatus == "Y" orderby s.StoreName select z.FavouriteStoreId).SingleOrDefault(); var result = (from u in context.registrationmasters join s in context.storemasters on u.FavouriteStoreId equals s.StoreId where u.LoginID == (long)loginid && u.FavouriteStoreId == storeid select new StoreModel() { StoreId = s.StoreId, StoreName = s.StoreName, StoreStatus = s.StoreStatus == "Y" ? true : false, OpeningTime = (DateTime)s.OpeningTime, ClosingTime = (DateTime)s.ClosingTime, StoreEmailId = s.StoreEmailId, StorePhoneNumber = s.StorePhoneNumber, StoreAddress = s.StoreAddress, StorePicturesUrl = "http://103.233.79.234/Data/EverGreen_Android/StorePictures/" + s.StoreId + ".jpg", FavouriteStore = s.StoreId == favouriteStore ? true : false, }).FirstOrDefault(); store = result; } } catch (Exception ex) { //Handle ex } } } return(store); }
public PaymentResponseModel CreatePaymentOrder(int loginid, string ordernumber, int storeid) { PaymentResponseModel response = new PaymentResponseModel(); string transaction_id = ""; string OrderNumber = ""; using (evergreen_androidEntities context = new evergreen_androidEntities()) { var orderDetails = (from r in context.registrationmasters join o in context.ordermasters on r.LoginID equals o.LoginId where r.LoginID == loginid && o.OrderNumber == ordernumber && o.StoreId == storeid select new PaymentGatewayModel() { name = r.Name, phone = r.PhoneNumber, email = r.EmailID, description = o.OrderNumber, amount = (double)o.NetAmount }).First(); //For Production //string Insta_client_id = "YPmEwDVMbYy4hH9EZOcY4Vsw3xJWjnAd3qlTS85J", // Insta_client_secret = "fSiNKEG8PRLdOXSzpQrBba02Ix1sfbxDSHg3f562AFY0YqvgKXMm70wbE6vqxzmmpVOKB1MyG3tlwDzX4rzNXwRwqaHVafFQv1gkj4kNf14x1eeync9PoMuGtOulBxJk", // Insta_Endpoint = InstamojoConstants.INSTAMOJO_API_ENDPOINT, // Insta_Auth_Endpoint = InstamojoConstants.INSTAMOJO_AUTH_ENDPOINT; //For Test string Insta_client_id = ""; string Insta_client_secret = ""; string Insta_Endpoint = ""; string Insta_Auth_Endpoint = ""; if (storeid == 1) { Insta_client_id = "HhWceDXORiCKCKIechUmXZX6vd4nj44kKvCUIVJv"; Insta_client_secret = "5B6CAfNsEoaakuzWLia7CMtgFsp6gt0MTrN5jR0MzsTIerNXKjmS9k1bBS1J8LdANjKXWtmlR1RuiOM8o71JVYYawBCl4NRiWbpKrI8OwkwnjNlvOuYRnjfkGnjozZDM"; Insta_Endpoint = InstamojoConstants.INSTAMOJO_API_ENDPOINT; Insta_Auth_Endpoint = InstamojoConstants.INSTAMOJO_AUTH_ENDPOINT; } if (storeid == 2) { Insta_client_id = "tmLkZZ0zV41nJwhayBGBOI4m4I7bH55qpUBdEXGS"; Insta_client_secret = "IDejdccGqKaFlGav9bntKULvMZ0g7twVFolC9gdrh9peMS0megSFr7iDpWwWIDgFUc3W5SlX99fKnhxsoy6ipdAv9JeQwebmOU6VRvOEQnNMWwZnWglYmDGrfgKRheXs"; Insta_Endpoint = InstamojoConstants.INSTAMOJO_API_ENDPOINT; Insta_Auth_Endpoint = InstamojoConstants.INSTAMOJO_AUTH_ENDPOINT; } if (storeid == 3) { Insta_client_id = "tmLkZZ0zV41nJwhayBGBOI4m4I7bH55qpUBdEXGS"; Insta_client_secret = "IDejdccGqKaFlGav9bntKULvMZ0g7twVFolC9gdrh9peMS0megSFr7iDpWwWIDgFUc3W5SlX99fKnhxsoy6ipdAv9JeQwebmOU6VRvOEQnNMWwZnWglYmDGrfgKRheXs"; Insta_Endpoint = InstamojoConstants.INSTAMOJO_API_ENDPOINT; Insta_Auth_Endpoint = InstamojoConstants.INSTAMOJO_AUTH_ENDPOINT; } InstamojoAPI.Instamojo objClass = InstamojoImplementation.getApi(Insta_client_id, Insta_client_secret, Insta_Endpoint, Insta_Auth_Endpoint); PaymentOrder objPaymentRequest = new PaymentOrder(); //Required POST parameters objPaymentRequest.name = orderDetails.name; objPaymentRequest.email = orderDetails.email; objPaymentRequest.phone = orderDetails.phone; objPaymentRequest.description = orderDetails.description; objPaymentRequest.amount = orderDetails.amount; objPaymentRequest.currency = "INR"; string randomName = Path.GetRandomFileName(); randomName = randomName.Replace(".", string.Empty); objPaymentRequest.transaction_id = "EVG" + randomName; transaction_id = objPaymentRequest.transaction_id; OrderNumber = objPaymentRequest.description; //For Production //objPaymentRequest.redirect_url = "http://103.233.79.234:1000/"; //objPaymentRequest.webhook_url = "https://your.server.com/webhook"; //Extra POST parameters //For Test objPaymentRequest.redirect_url = "https://swaggerhub.com/api/saich/pay-with-instamojo/1.0.0"; objPaymentRequest.webhook_url = "https://your.server.com/webhook"; if (objPaymentRequest.validate()) { //if (objPaymentRequest.emailInvalid) //{ // response.Message = "Email is not valid"; //} //if (objPaymentRequest.nameInvalid) //{ // response.Message = "Name is not valid"; //} if (objPaymentRequest.phoneInvalid) { response.Message = "Phone is not valid"; } if (objPaymentRequest.amountInvalid) { response.Message = "Amount is not valid"; } if (objPaymentRequest.currencyInvalid) { response.Message = "Currency is not valid"; } if (objPaymentRequest.transactionIdInvalid) { response.Message = "Transaction Id is not valid"; } if (objPaymentRequest.redirectUrlInvalid) { response.Message = "Redirect Url Id is not valid"; } if (objPaymentRequest.webhookUrlInvalid) { response.Message = "Webhook URL is not valid"; } } else { try { CreatePaymentOrderResponse objPaymentResponse = objClass.createNewPaymentRequest(objPaymentRequest); response.PaymentURL = objPaymentResponse.payment_options.payment_url; var data = context.ordermasters.Where(x => x.LoginId == loginid && x.OrderNumber == ordernumber && x.StoreId == storeid).FirstOrDefault(); if (data != null) { context.ordermasters.Where(x => x.LoginId == loginid && x.OrderNumber == ordernumber && x.StoreId == storeid).ToList().ForEach(x => x.TranactionId = transaction_id); context.SaveChanges(); } } catch (ArgumentNullException ex) { response.Message = ex.Message; } catch (WebException ex) { response.Message = ex.Message; } catch (IOException ex) { response.Message = ex.Message; } catch (InvalidPaymentOrderException ex) { if (!ex.IsWebhookValid()) { response.Message = "Webhook is invalid"; } if (!ex.IsCurrencyValid()) { response.Message = "Currency is Invalid"; } if (!ex.IsTransactionIDValid()) { response.Message = "Transaction ID is Invalid"; } } catch (ConnectionException ex) { response.Message = ex.Message; } catch (BaseException ex) { response.Message = ex.Message; } catch (Exception ex) { response.Message = ex.Message; } } } return(response); }