public object CreateNewWard([FromBody] WardRequestDTO WardData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(WardData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
Response = WardBUS.AddOrUpdateWard(WardData);
return(Response);
}
public static ResponseDTO AddOrUpdateWard(WardRequestDTO WardData)
{
ErrorDTO ErrorResponse = new ErrorDTO();
ResponseDTO Response = new ResponseDTO();
SqlConnection con = connection.loadDB();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = WardData.id == null ? "AddWardData" : "UpdateWardData";
if (WardData.id != null)
{
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "ID";
param1.SqlDbType = SqlDbType.Int;
param1.Value = WardData.id;
cmd.Parameters.Add(param1);
}
SqlParameter param6 = new SqlParameter();
param6.ParameterName = "WardCode";
param6.SqlDbType = SqlDbType.NVarChar;
param6.Value = WardData.ward_code != "" ? WardData.ward_code : "";
cmd.Parameters.Add(param6);
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "WardName";
param2.SqlDbType = SqlDbType.NVarChar;
param2.Value = WardData.ward_name != "" ? WardData.ward_name : "";
cmd.Parameters.Add(param2);
SqlParameter param10 = new SqlParameter();
param10.ParameterName = "Type";
param10.SqlDbType = SqlDbType.NVarChar;
param10.Value = WardData.type != "" ? WardData.type : "";
cmd.Parameters.Add(param10);
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "DistrictCode";
param3.SqlDbType = SqlDbType.NVarChar;
param3.Value = WardData.district_code != "" ? WardData.district_code : "";
cmd.Parameters.Add(param3);
SqlParameter param4 = new SqlParameter();
param4.ParameterName = "DistrictName";
param4.SqlDbType = SqlDbType.NVarChar;
param4.Value = WardData.district_name != "" ? WardData.district_name : "";
cmd.Parameters.Add(param4);
SqlParameter param5 = new SqlParameter();
param5.ParameterName = "CityCode";
param5.SqlDbType = SqlDbType.NVarChar;
param5.Value = WardData.city_code != "" ? WardData.city_code : "";
cmd.Parameters.Add(param5);
SqlParameter param7 = new SqlParameter();
param7.ParameterName = "CityName";
param7.SqlDbType = SqlDbType.NVarChar;
param7.Value = WardData.city_name != "" ? WardData.city_name : "";
cmd.Parameters.Add(param7);
SqlParameter param8 = new SqlParameter();
param8.ParameterName = "Population";
param8.SqlDbType = SqlDbType.NChar;
param8.Value = WardData.population != "" ? WardData.population : "";
cmd.Parameters.Add(param8);
SqlParameter param9 = new SqlParameter();
param9.ParameterName = "Area";
param9.SqlDbType = SqlDbType.NChar;
param9.Value = WardData.area != "" ? WardData.area : "";
cmd.Parameters.Add(param9);
try
{
cmd.ExecuteNonQuery();
Response.Data = WardData.id == null ? "CREATED" : "UPDATED";
}
catch (Exception ex)
{
ErrorResponse.Code = 400;
ErrorResponse.Message = ex.ToString();
Response.Error = ErrorResponse;
}
finally
{
con.Close();
}
return(Response);
}
