public Task <string> Update(IdNameForDropdownModel aModel) { try { const string query = @"UPDATE tbl_GROUP_OF_PRODUCT_PHAR SET Name=@Name WHERE Id=@Id"; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", aModel.Id); cmd.Parameters.AddWithValue("@Name", aModel.Name); cmd.ExecuteNonQuery(); Con.Close(); return(Task.FromResult <string>("Update Successful")); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }
public string Update(IdNameForDropdownModel aModel) { try { string msg = ""; const string query = @"UPDATE Department SET Name=@Name WHERE Id=@Id"; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Name", aModel.Name); cmd.Parameters.AddWithValue("@Id", aModel.Id); int rtn = cmd.ExecuteNonQuery(); msg = rtn == 1 ? "Update Success" : "Update Failed"; Con.Close(); return(msg); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(exception.ToString()); } }
/////////////////SAVE public string Save(IdNameForDropdownModel amodel) { try { string msg = ""; const string query = @"INSERT INTO InformationFrom (Name) VALUES (@Name)"; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Name", amodel.Name); int rtn = cmd.ExecuteNonQuery(); msg = rtn == 1 ? "Saved Success" : "Saved Failed"; Con.Close(); return(msg); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(exception.ToString()); } }
public async Task <HttpResponseMessage> Save_GROUP_OF_PRODUCT_PHAR([FromBody] IdNameForDropdownModel aModel) { var formate = RequestFormat.JsonFormaterString(); try { if (string.IsNullOrEmpty(aModel.Name)) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Name is Empty" }, formate)); } if (_gt.FncSeekRecordNew("tbl_GROUP_OF_PRODUCT_PHAR", "Name='" + aModel.Name + "'") == true) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Name Already Exists" }, formate)); } else { if (_gt.FncSeekRecordNew("tbl_GROUP_OF_PRODUCT_PHAR", "Id=" + aModel.Id + "") == false) { string msg = await _gt.Save(aModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formate)); } else { string msg = await _gt.Update(aModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formate)); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK , new Confirmation { Output = "error", Msg = ex.ToString() }, formate)); } }
public Task <string> Save(IdNameForDropdownModel aModel) { try { const string query = @"INSERT INTO tbl_GROUP_OF_PRODUCT_PHAR (Name) VALUES (@Name)" ; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Name", aModel.Name); cmd.ExecuteNonQuery(); Con.Close(); return(Task.FromResult("Save successful")); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }
//------------------------------ public string AddNewProductCategory(IdNameForDropdownModel aModel) { try { string msg = ""; const string query = @"INSERT INTO ProductCategory (ProductCategoryName) VALUES(@Name) "; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Name", aModel.Name); int rtn = cmd.ExecuteNonQuery(); msg = rtn == 1 ? "Save Successful" : "Save Failed"; Con.Close(); return(msg); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(exception.Message); } }
public JsonResult UpdateDrType(IdNameForDropdownModel aModel) { var data = _doctorTypeGateway.Update(aModel); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveMr(IdNameForDropdownModel aModel) { var data = _mrGateway.Save(aModel); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateDepartment(IdNameForDropdownModel aModel) { var data = _departmentGateway.Update(aModel); return(Json(data, JsonRequestBehavior.AllowGet)); }