public async Task <IActionResult> PutMstCountry([FromRoute] int id, [FromBody] MstCountry mstCountry)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mstCountry.CountryId)
{
return(BadRequest());
}
_context.Entry(mstCountry).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MstCountryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public DBResult <DataTable> DAL_SaveCountry(MstCountry country)
{
try
{
DataTable table = new DataTable();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("usp_GetAddUpdateDeleteCountry", conn))
{
cmd.CommandTimeout = 60;
if (country.CountryId == 0)
{
cmd.Parameters.Add(new SqlParameter("@CountryName", country.CountryName));
cmd.Parameters.Add(new SqlParameter("@CountryCode", country.CountryCode));
cmd.Parameters.Add(new SqlParameter("@UserId", country.UserId));
cmd.Parameters.Add(new SqlParameter("@IsActive", true));
cmd.Parameters.Add(new SqlParameter("@IsAdd", true));
cmd.Parameters.Add(new SqlParameter("@IsEdit", false));
cmd.Parameters.Add(new SqlParameter("@IsDelete", false));
}
else
{
cmd.Parameters.Add(new SqlParameter("@CountryId", country.CountryId));
cmd.Parameters.Add(new SqlParameter("@CountryName", country.CountryName));
cmd.Parameters.Add(new SqlParameter("@CountryCode", country.CountryCode));
cmd.Parameters.Add(new SqlParameter("@UserId", country.UserId));
cmd.Parameters.Add(new SqlParameter("@IsAdd", false));
cmd.Parameters.Add(new SqlParameter("@IsEdit", true));
cmd.Parameters.Add(new SqlParameter("@IsDelete", false));
}
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.StoredProcedure;
da.Fill(table);
}
}
conn.Close();
}
return(new DBResult <DataTable>
{
TransactionResult = true,
Data = table
});
}
catch (Exception ex)
{
return(new DBResult <DataTable>
{
TransactionResult = false
});
}
}
public async Task <IActionResult> PostMstCountry([FromBody] MstCountry mstCountry)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MstCountry.Add(mstCountry);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMstCountry", new { id = mstCountry.CountryId }, mstCountry));
}
