public CountryModel UpdateCountry(CountryModel _objdata)
{
tbl_Countries _objCountry = new tbl_Countries();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault();
if (_query != null)
{
tbl_Countries _objTemp = new tbl_Countries();
_objTemp = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault();
_objTemp.v_country = _objdata.strCountryName;
_objTemp.v_currency = _objdata.strCourncy;
_objTemp.v_currency_symbol = _objdata.strCourncySymbol;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Country updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public CountryModel DeleteCountry(int intCountryId)
{
CountryModel _objdata = new CountryModel();
tbl_Countries _objBrand = new tbl_Countries();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Countries.Where(x => x.int_Id == intCountryId).FirstOrDefault();
if (_query != null)
{
tbl_Countries _log = new tbl_Countries();
_log = dataContext.tbl_Countries.Where(x => x.int_Id == intCountryId).FirstOrDefault();
_log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Country deleted sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public CountryModel SaveCountry(CountryModel _objdata)
{
tbl_Countries _objCountry = new tbl_Countries();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objCountry.v_country = _objdata.strCountryName;
_objCountry.v_currency = _objdata.strCourncy;
_objCountry.v_currency_symbol = _objdata.strCourncySymbol;
_objCountry.b_IsActive = true;
dataContext.tbl_Countries.Add(_objCountry);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "Country save sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public tbl_Countries POST([FromBody] tbl_Countries countries)
{
using (ClaimyWebServies_dbEntities2 entity = new ClaimyWebServies_dbEntities2())
{
entity.Configuration.ProxyCreationEnabled = false;
entity.tbl_Countries.Add(countries);
entity.SaveChanges();
return(countries);
}
}
