public ResponseModel editstore([FromBody] StoreMaster storeMaster, int StoreID) { StoreCaller newStore = new StoreCaller(); ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token)); int result = newStore.EditStore(new StoreService(Cache, Db), storeMaster, StoreID, authenticate.TenantId, authenticate.UserMasterID); statusCode = result == 0 ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// Create Store /// </summary> /// <param name=""></param> /// <returns></returns> public int CreateStore(StoreMaster storeMaster, int TenantID, int UserID) { // MySqlCommand cmd = new MySqlCommand(); int storeId = 0; try { conn = Db.Connection; MySqlCommand cmd = new MySqlCommand("SP_InsertStore", conn); cmd.Connection = conn; //cmd.Parameters.AddWithValue("@Brand_ID", storeMaster.BrandID); cmd.Parameters.AddWithValue("@Store_Code", storeMaster.StoreCode); cmd.Parameters.AddWithValue("@Store_Name", storeMaster.StoreName); cmd.Parameters.AddWithValue("@State_ID", storeMaster.StateID); cmd.Parameters.AddWithValue("@City_ID", storeMaster.CityID); cmd.Parameters.AddWithValue("@Pincode_ID", storeMaster.Pincode); cmd.Parameters.AddWithValue("@Store_Address", storeMaster.Address); cmd.Parameters.AddWithValue("@Region_ID", storeMaster.RegionID); cmd.Parameters.AddWithValue("@Zone_ID", storeMaster.ZoneID); cmd.Parameters.AddWithValue("@StoreType_ID", storeMaster.StoreTypeID); cmd.Parameters.AddWithValue("@StoreEmail_ID", storeMaster.StoreEmailID); cmd.Parameters.AddWithValue("@StorePhone_No", storeMaster.StorePhoneNo); cmd.Parameters.AddWithValue("@Is_Active", storeMaster.IsActive); cmd.Parameters.AddWithValue("@Tenant_ID", TenantID); cmd.Parameters.AddWithValue("@User_ID", UserID); cmd.Parameters.AddWithValue("@BrandIDs", storeMaster.BrandIDs); cmd.CommandType = CommandType.StoredProcedure; storeId = Convert.ToInt32(cmd.ExecuteScalar()); } catch (MySql.Data.MySqlClient.MySqlException ex) { } return(storeId); }
private StoreMaster masterStore(int idStore) { Store storeDb = _context.Store.Where(c => c.Id == idStore).First(); StoreMaster store = new StoreMaster(); store.Id = idStore; store.Code = storeDb.Code; store.Name = storeDb.Name; store.Address = storeDb.Name; store.Address2 = storeDb.Address2; store.Address3 = storeDb.Address3; store.Address4 = storeDb.Address4; store.City = storeDb.City; store.Location = storeDb.Location; store.Regional = storeDb.Regional; store.StoreTypeId = storeDb.StoreTypeId; store.WarehouseId = storeDb.WarehouseId; try { store.CustomerIdStore = _context.Customer.Where(c => c.StoreId == idStore).First().CustId; } catch { // store.CustomerIdStore = _context.Customer.Where(c => c.StoreId == 962).First().CustId; } return store; }
public async Task <IActionResult> EditStore(int id, [Bind("Id,ImporterName,DealerName,StoreGroupName,StoreCode,Type,StoreName,StoreAddress1,StoreAddress2,StorePhone,StoreContact,Zone,Area,Region,PostTown,StorePostcode,IsDeleted,CreatedBy,ModifiedBy")] StoreMaster storeMaster) { if (id != storeMaster.Id) { return(NotFound()); } if (ModelState.IsValid) { try { var user = _userManager.GetUserId(User); //var userName = _context.Users.Where(x => x.Id == user).Select(x => x.FirstName + " " + x.LastName).FirstOrDefault(); var userName = _context.Users.Where(x => x.Id == user).Select(x => x.Id).FirstOrDefault(); storeMaster.ModifiedBy = userName; _context.Update(storeMaster); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (StoreMasterExists(storeMaster.Id)) { throw; } else { return(NotFound()); } } return(RedirectToAction(nameof(StoreList))); } return(View(storeMaster)); }
public StoreMaster Getstore(int Id) { using (trymvc1DataContext context = new trymvc1DataContext()) { StoreMaster storemaster = context.StoreMasters.Where(x => x.id == Id).FirstOrDefault(); return(storemaster); } }
public ActionResult DeleteConfirmed(int id) { StoreMaster stores = db.StoreMasters.Find(id); db.StoreMasters.Remove(stores); db.SaveChanges(); return(RedirectToAction("StoreList")); }
/// <summary> /// get StoreDetail By Storecode OR Pincode /// </summary> /// <param name="searchText"></param> /// <param name="tenantID"></param> public List <StoreMaster> getStoreDetailByStorecodenPincode(string searchText, int tenantID) { List <StoreMaster> storeMaster = new List <StoreMaster>(); MySqlCommand cmd = new MySqlCommand(); DataSet ds = new DataSet(); try { conn.Open(); cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_getStoreSDetialwithStorenamenPincode", conn); cmd1.Parameters.AddWithValue("@searchText", searchText); cmd1.Parameters.AddWithValue("@Tenant_Id", tenantID); cmd1.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(cmd1); da.SelectCommand = cmd1; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { StoreMaster store = new StoreMaster(); store.StoreCode = ds.Tables[0].Rows[i]["StoreCode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreCode"]); store.StoreName = ds.Tables[0].Rows[i]["StoreName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]); store.Pincode = ds.Tables[0].Rows[i]["PincodeID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["PincodeID"]); store.StoreEmailID = ds.Tables[0].Rows[i]["StoreEmailID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreEmailID"]); store.Address = ds.Tables[0].Rows[i]["Address"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Address"]); store.StoreID = Convert.ToInt32(ds.Tables[0].Rows[i]["StoreID"]); //store.StoreVisitDate= ds.Tables[0].Rows[i]["StoreVisitDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreVisitDate"]); //store.Purpose= ds.Tables[0].Rows[i]["Purpose"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Purpose"]); storeMaster.Add(store); } } else { storeMaster = GetStoreDetaisFromAPI(searchText); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(storeMaster); }
StoreMaster IStoreMaster.Getstore(int Id) { StoreMaster storemaster = new StoreMaster() { id = 1, storename = "sf" }; return(storemaster); //throw new NotImplementedException(); }
public IHttpActionResult Update(StoreMaster storeMaster) { var isupdate = _storeMasterRepository.Update(storeMaster); if (isupdate == true) { return(Ok(isupdate)); } return(BadRequest()); }
/// <summary> /// Get list of the Stores details from LPASS API /// </summary> /// <param name="searchText"></param> /// <returns></returns> public List <StoreMaster> GetStoreDetaisFromAPI(string searchText) { List <StoreMaster> storeMaster = new List <StoreMaster>(); CustomStoreSearch objStore = new CustomStoreSearch(); List <CustomStoreDetails> objStoreDetails = new List <CustomStoreDetails>(); try { objStore.programCode = "bata"; objStore.storeAddressPin = searchText; objStore.securityToken = apisecurityToken; objStore.userID = 3; objStore.appID = 7; string apiReq = JsonConvert.SerializeObject(objStore); apiResponse = CommonService.SendApiRequest(apiURL + "StoreDetails", apiReq); if (!string.IsNullOrEmpty(apiResponse)) { ApiResponse = JsonConvert.DeserializeObject <CustomResponse>(apiResponse); if (ApiResponse != null) { objStoreDetails = JsonConvert.DeserializeObject <List <CustomStoreDetails> >(Convert.ToString((ApiResponse.Responce))); if (objStoreDetails.Count > 0) { for (int k = 0; k < objStoreDetails.Count; k++) { StoreMaster store = new StoreMaster(); store.StoreCode = objStoreDetails[k].StoreCode; store.StoreName = objStoreDetails[k].StoreCode;// no store name provided in the api response hence mapped storecode mapped as per req store.Pincode = objStoreDetails[k].StorePinCode; store.StoreEmailID = objStoreDetails[k].StoreEmailId; store.Address = objStoreDetails[k].StoreAddress; store.StoreID = 0; store.LpassStoreID = objStoreDetails[k].StoreId; storeMaster.Add(store); } } } } } catch (Exception) { throw; } return(storeMaster); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StoreMaster stores = db.StoreMasters.Find(id); if (stores == null) { return(HttpNotFound()); } return(View(stores)); }
/// <summary> /// Get list of Stores /// </summary> /// <param name="TicketId">Id of the Ticket</param> /// <returns></returns> public List <StoreMaster> getSelectedStoreByTicketId(int TicketId) { List <StoreMaster> storeMaster = new List <StoreMaster>(); DataSet ds = new DataSet(); string GMT = " GMT+0530 (" + TimeZoneInfo.Local.StandardName + ")"; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_GetSelectedStoresByTicketID", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@Ticket_ID", TicketId); cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { StoreMaster store = new StoreMaster(); store.StoreCode = ds.Tables[0].Rows[i]["StoreCode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreCode"]); store.StoreName = ds.Tables[0].Rows[i]["StoreName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]); store.Pincode = ds.Tables[0].Rows[i]["Pincode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Pincode"]); store.StoreEmailID = ds.Tables[0].Rows[i]["StoreEmailID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreEmailID"]); store.Address = ds.Tables[0].Rows[i]["Address"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Address"]); store.StoreID = Convert.ToInt32(ds.Tables[0].Rows[i]["StoreID"]); store.StoreVisitDate = ds.Tables[0].Rows[i]["StoreVisitDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StoreVisitDate"]) + GMT; store.Purpose = ds.Tables[0].Rows[i]["Purpose"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Purpose"]); storeMaster.Add(store); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(storeMaster); }
/// <summary> /// Search Store /// <param name="StateID"></param> /// <param name="PinCode"></param> /// <param name="Area"></param> /// <param name="IsCountry"></param> /// </summary> public List <StoreMaster> SearchStore(int StateID, int PinCode, string Area, bool IsCountry) { List <StoreMaster> storeMaster = new List <StoreMaster>(); DataSet ds = new DataSet(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_SearchStore", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@State_ID", StateID); cmd.Parameters.AddWithValue("@Pin_Code", PinCode); cmd.Parameters.AddWithValue("@Store_Area", Area); cmd.Parameters.AddWithValue("@Is_Country", IsCountry); cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { StoreMaster store = new StoreMaster(); store.StoreID = Convert.ToInt32(ds.Tables[0].Rows[i]["StoreID"]); store.StoreName = Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]); store.StoreCode = Convert.ToString(ds.Tables[0].Rows[i]["StoreCode"]); store.StorePhoneNo = Convert.ToString(ds.Tables[0].Rows[i]["StoreCode"]); //store.CreatedDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""]); storeMaster.Add(store); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(storeMaster); }
public async Task <IActionResult> CreateStore([Bind("Id,ImporterName,DealerName,StoreGroupName,StoreCode,Type,StoreName,StoreAddress1,StoreAddress2,StorePhone,StoreContact,Zone,Area,Region,PostTown,StorePostcode,IsDeleted,CreatedBy,ModifiedBy")] StoreMaster storeMaster) { if (ModelState.IsValid) { var user = _userManager.GetUserId(User); // var userName = _context.Users.Where(x => x.Id == user).Select(x=>x.FirstName+" "+x.LastName).FirstOrDefault() ; var userName = _context.Users.Where(x => x.Id == user).Select(x => x.Id).FirstOrDefault(); storeMaster.CreatedBy = userName; _context.Add(storeMaster); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(StoreList))); } return(View(storeMaster)); }
public ActionResult Edit(int?id) { ViewBag.Status = new SelectList(db.StatusMasters, "CustomerId,RecordId", "StatusName"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StoreMaster stores = db.StoreMasters.Find(id); if (stores == null) { return(HttpNotFound()); } return(View(stores)); }
/// <summary> /// Get list of the Stores /// </summary> /// <param name="searchText"></param> /// <param name="tenantID"></param> /// <returns></returns> public List <StoreMaster> getStores(string searchText, int tenantID) { List <StoreMaster> storeMaster = new List <StoreMaster>(); MySqlCommand cmd = new MySqlCommand(); DataSet ds = new DataSet(); try { conn.Open(); cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_getStores", conn); cmd1.Parameters.AddWithValue("@Tenant_Id", tenantID); cmd1.Parameters.AddWithValue("@searchText", searchText); cmd1.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(cmd1); da.SelectCommand = cmd1; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { StoreMaster store = new StoreMaster(); store.StoreID = Convert.ToInt32(ds.Tables[0].Rows[i]["StoreID"]); store.StoreName = Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]); store.Address = Convert.ToString(ds.Tables[0].Rows[i]["Address"]); storeMaster.Add(store); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(storeMaster); }
public List <StoreMaster> getStore(String storeCode) { //1 city, 2 regional List <StoreMaster> listRetails = new List <StoreMaster>(); List <Store> stores = new List <Store>(); String customerId = ""; stores = _context.Store.Where(c => c.Code != "ACF" || c.Code != "CAM" || c.Code != "KAT" || c.Code != "KAU" || c.Code != "LAC" || c.Code != "NBR" || c.Code != "NBS" || c.Code != "NBT" || c.Code != "300" || c.Code != "310").ToList(); foreach (Store p in stores) { try { customerId = _context.Customer.Where(c => c.StoreId == p.Id).First().CustId; } catch (Exception ex) { customerId = "Non"; } StoreMaster article = new StoreMaster { Id = p.Id, Code = p.Code, Name = p.Name, City = p.City, Regional = p.Regional, Address = p.Address, CustomerIdStore = customerId }; if (article.CustomerIdStore.Equals("Non")) { } else { listRetails.Add(article); } } return(listRetails); }
/// <summary> /// Edit Store /// </summary> /// <param name="storeMaster"></param> /// <param name="TenantID"></param> /// <param name="UserID"></param> /// <returns></returns> public int EditStore(StoreMaster storeMaster, int TenantID, int UserID) { int Success = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_UpdateStore", conn); cmd.Connection = conn; //cmd.Parameters.AddWithValue("@Brand_ID", storeMaster.BrandID); cmd.Parameters.AddWithValue("@Store_Code", storeMaster.StoreCode); cmd.Parameters.AddWithValue("@Store_Name", storeMaster.StoreName); cmd.Parameters.AddWithValue("@State_ID", storeMaster.StateID); cmd.Parameters.AddWithValue("@City_ID", storeMaster.CityID); cmd.Parameters.AddWithValue("@Pincode_ID", storeMaster.PincodeID); cmd.Parameters.AddWithValue("@Store_Address", storeMaster.Address); cmd.Parameters.AddWithValue("@Region_ID", storeMaster.RegionID); cmd.Parameters.AddWithValue("@Zone_ID", storeMaster.ZoneID); cmd.Parameters.AddWithValue("@StoreType_ID", storeMaster.StoreTypeID); cmd.Parameters.AddWithValue("@StoreEmail_ID", storeMaster.StoreEmailID); cmd.Parameters.AddWithValue("@StorePhone_No", storeMaster.StorePhoneNo); cmd.Parameters.AddWithValue("@Is_Active", storeMaster.IsActive); cmd.Parameters.AddWithValue("@Tenant_ID", TenantID); cmd.Parameters.AddWithValue("@User_ID", UserID); cmd.Parameters.AddWithValue("@Store_ID", storeMaster.StoreID); cmd.Parameters.AddWithValue("@BrandIDs", storeMaster.BrandIDs); cmd.CommandType = CommandType.StoredProcedure; Success = Convert.ToInt32(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(Success); }
public ActionResult Create([Bind(Include = "CustomerId,StoreNumber,StoreName,StoreStatus,StoreDesc,StoreImgName")] StoreMaster storeMaster, HttpPostedFileBase StoreImgName) { StoreMaster s = new StoreMaster(); ViewBag.Status = new SelectList(db.StatusMasters, "RecordId", "StatusName"); if (StoreImgName != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } System.Drawing.Image img = System.Drawing.Image.FromStream(StoreImgName.InputStream); int height = img.Height; int width = img.Width; decimal size = Math.Round(((decimal)StoreImgName.ContentLength / (decimal)1024), 2); if (width == 300 || height == 250) { s.EmployeeID = Convert.ToInt32(@Session["employeecode"]); s.CreatedDate = DateTime.Now; s.StoreName = storeMaster.StoreName; s.StoreNumber = storeMaster.StoreNumber; s.StoreStatus = storeMaster.StoreStatus; s.StoreImgName = (storeMaster.StoreName + "_" + Path.GetFileName(StoreImgName.FileName)); s.StoreDesc = storeMaster.StoreDesc; db.StoreMasters.Add(s); db.SaveChanges(); StoreImgName.SaveAs(path + (storeMaster.StoreName + "_" + Path.GetFileName(StoreImgName.FileName))); return(RedirectToAction("Create")); } else { ViewBag.ImgMessage = string.Format("Please Select Image With resolution of 300px X 250px .\\nCurrent resolution is Width: {0}px and Heigth: {1}px", width.ToString(), height.ToString()); return(View()); } } else { ViewBag.ImgMessage = string.Format("Please select image"); return(View()); } }
public ActionResult Edit([Bind(Include = "CustomerId,RecordId,StoreNumber,StoreName,StoreStatus,StoreDesc")] StoreMaster store) { StoreMaster s = (from c in db.StoreMasters where c.RecordId == store.RecordId select c).FirstOrDefault(); ViewBag.Status = new SelectList(db.StatusMasters, "RecordId", "StatusName"); var file = Request.Files["ImageUpload"]; if (file != null && file.ContentLength > 0) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } System.Drawing.Image img = System.Drawing.Image.FromStream(file.InputStream); int height = img.Height; int width = img.Width; decimal size = Math.Round(((decimal)file.ContentLength / (decimal)1024), 2); if (width == 300 || height == 250) { file.SaveAs(path + (store.StoreName + "_" + Path.GetFileName(file.FileName))); s.StoreImgName = store.StoreName + "_" + Path.GetFileName(file.FileName); } else { ViewBag.ImgMessage = string.Format("Please Select Image With resolution of 300px X 250px .\\nCurrent resolution is Width: {0}px and Heigth: {1}px", width.ToString(), height.ToString()); return(RedirectToAction("Edit/1"));; } } s.EmployeeID = Convert.ToInt32(@Session["employeecode"]); s.StoreName = store.StoreName; s.StoreNumber = store.StoreNumber; s.StoreStatus = store.StoreStatus; s.StoreDesc = store.StoreDesc; s.UpdatedDate = DateTime.Now; db.SaveChanges(); return(RedirectToAction("StoreList")); }
public bool Update(StoreMaster storeMaster) { bool returnvalue = false; DynamicParameters param = new DynamicParameters(); param.Add("@Id", storeMaster.Id); param.Add("@IsActive", 1); param.Add("@CreatedBy", 1); param.Add("@CreatedDate", DateTime.UtcNow); param.Add("@ModifiedBy", 1); param.Add("@ModifiedDate", DateTime.UtcNow); param.Add("@Name", storeMaster.Name); _db.Open(); var val = _db.Execute("USP_UpdateStoreMaster", param, commandType: CommandType.StoredProcedure); if (val > 0) { returnvalue = true; } _db.Close(); return(returnvalue); }
bool IStoreMaster.UpdateDocument(StoreMaster storemaster) { throw new NotImplementedException(); }
public bool SaveDocument(StoreMaster storemaster) { throw new NotImplementedException(); }
public int EditStore(IStore store, StoreMaster storeMaster, int TenantID, int UserID) { _storeRepository = store; return(_storeRepository.EditStore(storeMaster, TenantID, UserID)); }
// GET: Store public ActionResult Index() { StoreMaster storemaster = _IStoreMaster.Getstore(1); return(View(storemaster)); }