public StateModel SaveState(StateModel _objdata)
{
tbl_States _objState = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objState.v_State = _objdata.strStateName;
_objState.int_CountryId = _objdata.intCountryId;
_objState.dt_Created_On = DateTime.Now;
_objState.b_IsActive = true;
dataContext.tbl_States.Add(_objState);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "State save sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel UpdateState(StateModel _objdata)
{
tbl_States _objproduct = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault();
if (_query != null)
{
tbl_States _log = new tbl_States();
_log = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault();
_log.v_State = _objdata.strStateName;
_log.int_CountryId = _objdata.intCountryId;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "State Updated sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel DeleteState(int intStateId)
{
StateModel _objdata = new StateModel();
tbl_States _objState = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault();
if (_query != null)
{
tbl_States _log = new tbl_States();
_log = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault();
_log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "State deleted sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
