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));
}
