public bool IsWhouseExists(W_h_info wHInfo) { try { string Query = "SELECT * FROM tb_WH_Info WHERE (WhName = @WhName and Location = @Location)"; SqlCommand Command = new SqlCommand(Query, _connection); _connection.Open(); Command.Parameters.Clear(); Command.Parameters.Add("WhName", SqlDbType.VarChar); Command.Parameters["WhName"].Value = wHInfo.WhName; Command.Parameters.Add("Location", SqlDbType.VarChar); Command.Parameters["Location"].Value = wHInfo.Location; SqlDataReader Reader = Command.ExecuteReader(); Reader.Read(); bool isExist = Reader.HasRows; Reader.Close(); return(isExist); } catch (Exception exception) { throw new Exception("Unable to connect Server", exception); } finally { _connection.Close(); } }
public int SaveWhouse(W_h_info wHInfo) { string query = @"INSERT INTO [dbo].[tb_WH_Info] ([WhName] ,[Location] ,[Capacity] ,[EmployeeId]) VALUES ('" + wHInfo.WhName + "', '" + wHInfo.Location + "', '" + wHInfo.Capacity + "', '" + wHInfo.EmployeeId + "')"; try { SqlCommand command = new SqlCommand(query, _connection); _connection.Open(); int rowAffected = command.ExecuteNonQuery(); _connection.Close(); return(rowAffected); } catch (Exception exception) { throw new Exception("Unable to connect Server", exception); } finally { _connection.Close(); } }
public HttpResponseMessage PostWhouse(W_h_info wHInfo) { var messages = _whouseinfo.SaveWhouse(wHInfo); if (messages != null) { var message = Request.CreateResponse(HttpStatusCode.Created, messages); return(message); } return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Category not created")); }
public string SaveWhouse(W_h_info wHInfo) { if (_whouseinfo.IsWhouseExists(wHInfo)) { return("W H Name Already Exists."); } if (_whouseinfo.SaveWhouse(wHInfo) > 0) { return("W H Name Saved Successfully"); } return("W H Name Save Faild"); }
public ActionResult SaveWhouse(W_h_info wHInfo) { if (ModelState.IsValid) { try { ViewBag.ShowMsg = _whouseinfo.SaveWhouse(wHInfo); } catch (Exception exception) { ViewBag.ShowMsg = exception.Message; } } ViewBag.employees = _shopInfo.GetAllEmployees(); return(View()); }
public ActionResult SaveWhouse(W_h_info wHInfo) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:32331"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var response = client.PostAsJsonAsync("api/Whouse/PostWhouse", wHInfo).Result; if (response.IsSuccessStatusCode) { string msg = response.Content.ReadAsStringAsync().Result; var records = JsonConvert.DeserializeObject(msg); // JSON.Net ViewBag.ShowMsg = records; } } using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:32331"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = client.GetAsync("api/Whouse/").Result; string res = ""; using (HttpContent content = response.Content) { // ... Read the string. Task <string> result = content.ReadAsStringAsync(); res = result.Result; var records = JsonConvert.DeserializeObject <List <Employee> >(res); // JSON.Net foreach (Employee record in records) { var category = (string.Format("Id: {0}, EmployeeName: {1}", record.Id, record.EmployeeName)); } ViewBag.employees = records; } } return(View()); }