public string UpdateState(StateVM state)
{
string stateId = string.Empty;
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@Id", Value = state.Id
},
new SqlParameter {
ParameterName = "@CountryId", Value = state.CountryId
},
new SqlParameter {
ParameterName = "@Code", Value = state.Code
},
new SqlParameter {
ParameterName = "@Name", Value = state.Name
},
new SqlParameter {
ParameterName = "@IsActive", Value = state.IsActive
},
new SqlParameter {
ParameterName = "@UpdatedBy", Value = state.UpdatedBy
}
};
stateId = Convert.ToString(DALHelper.ExecuteScalar("UpdateState", parameters));
return(stateId);
}
public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <StateVM> viewModels = new List <StateVM>();
StateBAL balObject = new StateBAL();
IQueryable <Entities.State> entites = balObject.GetAll();
CountryBAL countryBAL = new CountryBAL();
IQueryable <Entities.Country> countries = countryBAL.GetAll();
foreach (Entities.State entity in entites)
{
StateVM viewModel = new StateVM();
viewModel.StateId = entity.StateId;
viewModel.StateName = entity.StateName;
viewModel.CountryName = countries.Where(c => c.CountryId == entity.CountryId).FirstOrDefault().CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <StateVM> {
Data = viewModels
}));
}
}
public IActionResult State(StateVM stateVM, string selectedCountryId, string selectedStateId)
{
StateVM_DataManager stateVM_DataManager = new StateVM_DataManager();
stateVM_DataManager.SaveState(stateVM);
return(RedirectToAction("State", stateVM));
}
public ActionResult AddState(StateVM stateVM)
{
stateVM.ValidStates = StatesList.States;
stateVM.State = (stateVM.State ?? new State
{
StateAbbreviation = "",
StateName = null
});
if (ModelState.IsValid)
{
try
{
stateVM.State.StateName = StatesList.States.FirstOrDefault(s => stateVM?.State.StateAbbreviation == s.Value)?.Text;
}
catch (NullReferenceException)
{ stateVM.State.StateName = null; }
if (stateVM.State.StateName == null)
{
return(View(stateVM));
}
StateRepository.Add(stateVM.State);
return(RedirectToAction("States"));
}
return(View(stateVM));
}
public ActionResult AddState2(StateVM sVM)
{
IEnumerable <State> states = StateRepository.GetAll();
IEnumerable <State> allStates = StateRepository.AllStates();
if (states.Any(s => s.StateAbbreviation == sVM.State.StateAbbreviation))
{
ModelState.AddModelError("StateAbbreviation", "This State Abbreviation is already in use.");
}
if (!allStates.Any(s => s.StateAbbreviation == sVM.State.StateAbbreviation))
{
ModelState.AddModelError("StateAbbreviation", "Please choose a valid state to add.");
}
foreach (var item in allStates)
{
if (item.StateAbbreviation == sVM.State.StateAbbreviation)
{
sVM.State = item;
}
}
if (ModelState.IsValid)
{
StateRepository.Add(sVM.State);
return(RedirectToAction("States"));
}
return(View("AddState2", sVM));
}
public ActionResult AddState()
{
StateVM model = new StateVM();
model.ValidStates = StatesList.States;
model.State = new State();
return(View(model));
}
public ActionResult DeleteState(StateVM stateVM)
{
var state = new State();
state.StateAbbreviation = stateVM.StateAbbreviation;
state.StateName = stateVM.StateName;
StateRepository.Delete(state.StateAbbreviation);
return(RedirectToAction("States"));
}
public ActionResult DeleteState(string id)
{
var state = StateRepository.Get(id);
var stateVM = new StateVM();
stateVM.StateAbbreviation = state.StateAbbreviation;
stateVM.StateName = state.StateName;
return(View(stateVM));
}
public ActionResult AddState2()
{
StateVM svm = new StateVM();
svm.SetStateItems(StateRepository.GetAll());
svm.SetAllStateItems(StateRepository.AllStates());
svm.SetAvailableStateItems(StateRepository.AvailableStates());
return(View(svm));
}
//
// GET: /SysAdmin/State/Create
public ActionResult Create()
{
StateVM viewModel = new StateVM();
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
//viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
//CountryBAL countryBAL = new CountryBAL();
//viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem() { Text = obj.CountryName, Value = obj.CountryId.ToString() };
viewModel.Status = true;
return(View(viewModel));
}
public StateVM EditState(StateVM c)
{
DB.tblState State = IMSDB.tblStates.Find(c.StateId);
if (State != null)
{
State.StateName = c.StateName;
State.CountryId = c.Country.CountryId;
//State.StateCode = c.StateCode;
State.IsActive = c.IsActive;
IMSDB.Entry(State).State = EntityState.Modified;
IMSDB.SaveChanges();
}
return(c);
}
public StateVM AddState(StateVM c)
{
DB.tblState State = IMSDB.tblStates.Add(
new DB.tblState
{
//StateCode = c.StateCode,
StateName = c.StateName,
CountryId = c.Country.CountryId,
IsActive = c.IsActive
});
IMSDB.SaveChanges();
c.StateId = State.StateId;
return(c);
}
public ActionResult SaveSts(StateVM Sts)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Sts.CmpyCode = list[0].CmpyCode;
return(Json(_StService.SaveSts(Sts), JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditState(StateVM stateVM)
{
if (ModelState.IsValid)
{
var state = new State();
state.StateAbbreviation = stateVM.StateAbbreviation;
state.StateName = stateVM.StateName;
StateRepository.Edit(state);
return(RedirectToAction("States"));
}
else
{
return(View("EditState", stateVM));
}
}
public ActionResult Edit(int id)
{
var state = stateRepository.GetStateById(id);
if (state != null && state.Count > 0)
{
StateVM model = new StateVM();
model = state[0];
var countryList = new SelectList(countryRepository.GetCountries(), "Id", "Name").ToList();
ViewBag.CountryList = countryList;
return(View(model));
}
return(RedirectToAction("List"));
}
public async Task <ActionResult <StateVM> > GetState(int id)
{
StateVM p = new StateVM();
if (id > 0)
{
var state = await setupBL.GetStateByIDAsync(id);
if (state != null)
{
p.Name = state.Name;
p.Code = state.Code;
p.CountryId = state.CountryId;
}
}
return(p);
}
//
// GET: /SysAdmin/State/Details/5
public ActionResult Details(int id)
{
StateVM viewModel = new StateVM();
StateBAL balObject = new StateBAL();
IQueryable <Entities.State> entites = balObject.FindBy(a => a.StateId == id);
if (entites != null && entites.Count() > 0)
{
Entities.State entity = entites.FirstOrDefault();
viewModel.StateId = entity.StateId;
viewModel.StateName = entity.StateName;
CountryBAL countryBAL = new CountryBAL();
viewModel.CountryName = countryBAL.FindBy(c => c.CountryId == entity.CountryId).FirstOrDefault().CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
public async Task <ActionResult <bool> > UpdateState(StateVM p)
{
bool result = false;
if (ModelState.IsValid)
{
var state = await setupBL.GetStateByIDAsync(p.Code);
if (state != null)
{
state.Name = p.Name;
if (await setupBL.UpdateStateAsync(state))
{
result = true;
}
}
}
return(result);
}
public ActionResult Edit(StateVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.State entity = new Entities.State();
entity.StateId = viewModel.StateId;
entity.CountryId = viewModel.CountryId;
entity.StateName = viewModel.StateName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
StateBAL balObject = new StateBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
//viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View(viewModel));
}
}
catch
{
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
//viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View());
}
}
public ActionResult Index()
{
List <StateVM> viewModels = new List <StateVM>();
StateBAL balObject = new StateBAL();
IQueryable <Entities.State> entites = balObject.GetAll();
foreach (Entities.State entity in entites)
{
StateVM viewModel = new StateVM();
viewModel.StateId = entity.StateId;
viewModel.StateName = entity.StateName;
viewModel.CountryName = entity.CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <StateVM> {
Data = viewModels
}));
}
public ActionResult Edit(StateVM model)
{
try
{
string stateId = string.Empty;
model.UpdatedBy = LogInManager.LoggedInUserId;
stateId = stateRepository.UpdateState(model);
if (!string.IsNullOrWhiteSpace(stateId))
{
return(Json(new
{
IsSuccess = true,
data = new
{
StateId = stateId
}
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
IsSuccess = false,
errorMessage = "State details not updated successfully."
}, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
Utility.Utility.LogError(e, "Edit");
return(Json(new
{
IsSuccess = false,
errorMessage = e.Message
}));
}
}
public StateVM SaveSts(StateVM Sts)
{
try
{
if (!Sts.EditFlag)
{
var Drecord = new List <string>();
List <StateNew> ObjList = new List <StateNew>();
ObjList.AddRange(Sts.StateNew.Select(m => new StateNew
{
CmpyCode = m.CmpyCode,
Code = m.Code,
Name = m.Name,
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'");
if (Bbs1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Sts.CmpyCode + "',");
sb.Append("'" + ObjList[n - 1].Code + "',");
sb.Append("'" + ObjList[n - 1].Name + "')");
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("insert into MSM059(CmpyCode,Code,Name) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(Sts.CmpyCode, Sts.UserName, "Add State Master", Sts.Code, Environment.MachineName);
Sts.SaveFlag = true;
Sts.ErrorMessage = string.Empty;
scope.Complete();
}
}
else
{
Drecord.Add(ObjList[n - 1].Code.ToString());
Sts.Drecord = Drecord;
Sts.SaveFlag = false;
Sts.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
//ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'");
//dt = ds.Tables[0];
//int Sts1 = 0;
//foreach (DataRow dr in dt.Rows)
//{
// Sts1 = int.Parse(dr["count1"].ToString());
//}
//if (Sts1 == 0)
//{
// StringBuilder sb = new StringBuilder();
// sb.Append("'" + Sts.CmpyCode + "',");
// //sb.Append("'UM',");
// sb.Append("'" + Sts.Code + "',");
// sb.Append("'" + Sts.Name + "')");
// _EzBusinessHelper.ExecuteNonQuery("insert into MSM059(CmpyCode,Code,Name) values(" + sb.ToString() + "");
// Sts.SaveFlag = true;
// Sts.ErrorMessage = string.Empty;
//}
//else
//{
// Sts.SaveFlag = false;
// Sts.ErrorMessage = "Duplicate Record";
//}
return(Sts);
}
var StsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'");
if (StsEdit != 0)
{
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("update MSM059 set Name='" + Sts.Name + "' where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'");
_EzBusinessHelper.ActivityLog(Sts.CmpyCode, Sts.UserName, "Update State Master", Sts.Code, Environment.MachineName);
Sts.SaveFlag = true;
Sts.ErrorMessage = string.Empty;
scope.Complete();
}
}
else
{
Sts.SaveFlag = false;
Sts.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
Sts.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Sts);
}
public StateVM AddState(StateVM c)
{
return(_StateBL.AddState(c));
}
public int DeleteState(StateVM c)
{
return(_StateBL.DeleteState(c.StateId));
}
public StateVM EditState(StateVM c)
{
return(_StateBL.EditState(c));
}
public StateVM SaveSts(StateVM Sts)
{
return(_StRepo.SaveSts(Sts));
}
