public ActionResult DeleteConfirmed(int id)
{
StateMaster stateMaster = db.StateMasters.Find(id);
db.StateMasters.Remove(stateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
StateMaster stateMaster = await db.StateMasters.FindAsync(id);
db.StateMasters.Remove(stateMaster);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
private void apply_Click(object sender, EventArgs e)
{
foreach (string moduleTag in m_dirtyModules)
{
StateMaster.savePreferenceData(moduleTag, m_currentPreferenceData[moduleTag]);
m_cachedPreferenceData[moduleTag] = m_currentPreferenceData[moduleTag];
}
Dirty = false;
}
public async Task <IHttpActionResult> Create(StateMaster prodData)
{
if (prodData != null)
{
await StateMasterDA.AddStateMaster(prodData);
return(Ok());
}
return(BadRequest("Request cannot be NULL"));
}
public ActionResult Edit([Bind(Include = "StateId,StateName,StateCode")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.Entry(stateMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stateMaster));
}
public ActionResult Create([Bind(Include = "Id,State,IsDeleted,CustomerId")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.StateMasters.Add(stateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stateMaster));
}
public ActionResult Edit([Bind(Include = "StateId,StateName,RefCountryId")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.Entry(stateMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RefCountryId = new SelectList(db.CountryMasters, "CountryId", "CountryName", stateMaster.RefCountryId);
return(View(stateMaster));
}
public async Task <ActionResult> Edit([Bind(Include = "ID,Name,CountryID")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.Entry(stateMaster).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(stateMaster));
}
public IActionResult AddState([FromBody] StateMaster state)
{
StateMaster createdState = _stateService.Save(state);
if (createdState == null)
{
_logger.LogError("User already exists");
return(StatusCode(StatusCodes.Status409Conflict, "User Already Exists"));
}
return(Ok(createdState));
}
public ActionResult Create([Bind(Include = "StateId,StateName,StateCode")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.StateMasters.Add(stateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stateMaster));
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Index", "adminLogin"));
}
StateMaster stateMaster = db.StateMasters.Find(id);
db.StateMasters.Remove(stateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create([Bind(Include = "ID,Name,CountryID")] StateMaster stateMaster)
{
if (ModelState.IsValid)
{
db.StateMasters.Add(stateMaster);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(stateMaster));
}
public List <StateMaster> Get(QueryBO objQuery)
{
SqlDataReader reader = null;
SqlConnection con = null;
List <StateMaster> lstState = null;
SqlCommand objcmd = null;
StateMaster objState = null;
try
{
lstState = new List <StateMaster>();
using (con = DBconnection.ConnectToDB())
{
objcmd = new SqlCommand();
objcmd.Connection = con;
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "STP_SelectStateMaster";
objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber));
objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize));
objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter));
objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort));
objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output;
reader = objcmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
objState = new StateMaster();
objState.StateID = Convert.ToInt64(reader["StateID"]);
objState.StateName = Convert.ToString("" + reader["StateName"]);
objState.CountryId = Convert.ToInt32(reader["CountryID"]);
objState.Status = Convert.ToInt16("" + reader["Status"]);
objState.Remark = Convert.ToString("" + reader["Remark"]);
objState.strStatus = Convert.ToString("" + reader["strStatus"]);
lstState.Add(objState);
}
}
}
objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Dispose();
objcmd = null;
con = null;
}
return(lstState);
}
public async Task <IHttpActionResult> PostStateMaster(StateMaster stateMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.States.Add(stateMaster);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = stateMaster.Id }, stateMaster));
}
public IActionResult Put(string id, StateMaster state)
{
try
{
var res = stateServ.UpdateAsync(id, state).Result;
return(Ok(res));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static string[] GetCompletionListState(string prefixText, int count, string contextKey)
{
StateMaster objState = new StateMaster();
DataTable dt = new DataView(objState.GetStateMaster(HttpContext.Current.Session["CompId"].ToString()), "State like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["State"].ToString();
}
return(txt);
}
public async Task <IHttpActionResult> DeleteStateMaster(int id)
{
StateMaster stateMaster = await db.States.FindAsync(id);
if (stateMaster == null)
{
return(NotFound());
}
db.States.Remove(stateMaster);
await db.SaveChangesAsync();
return(Ok(stateMaster));
}
// GET: StateMasters/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StateMaster stateMaster = db.StateMasters.Find(id);
if (stateMaster == null)
{
return(HttpNotFound());
}
return(View(stateMaster));
}
private void okButton_Click(object sender, EventArgs e)
{
// Dictionary<string, Type> moduleList = StateMaster.getModules();
List <Type> selectedModules = new List <Type>();
for (int i = 0; i < checkedList.CheckedIndices.Count; i++)
{
selectedModules.Add(m_modules[checkedList.CheckedIndices[i]].GetType());
// selectedModules.Add(moduleList[checkedList.CheckedItems[i].ToString()]);
}
StateMaster.setActiveModules(selectedModules.ToArray());
this.Close();
}
// GET: StateMasters/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StateMaster stateMaster = await db.StateMasters.FindAsync(id);
if (stateMaster == null)
{
return(HttpNotFound());
}
return(View(stateMaster));
}
public ActionResult Action(StateMasterFilter objFilter, string submit)
{
CommonBL objCommonBL = null;
StateMaster objState = null;
try
{
objDetailsVM = new StateDetailsVM();
if (submit.ToLower() == "edit")
{
objCommonBL = new CommonBL();
TempData["CountryFilter"] = objFilter;
objStateBL = new StateBL();
objDetailsVM = new StateDetailsVM();
objDetailsVM.StateMstr = objStateBL.GetData(new StateMasterFilter()
{
StateID = objFilter.StateID
}).FirstOrDefault();
objDetailsVM.CntMst = Chikitsa.DataAccessLayer.StateDAL.GetCountry();
// objDetailsVM.lstUserTypes = objCommonBL.GetCodeDetail(new CodeDetailFilter() { CodeTypeId = 1 });
return(View("Details", objDetailsVM));
}
else if (submit.ToLower() == "delete")
{
objStateBL = new StateBL();
objListVM = new StateMasterListVM();
objState = new StateMaster(objFilter.StateID);
objState.ModifiedBy = 1;
objState.Remark = "Deleted";
objResponse = objStateBL.SaveState(objState, "D");
objFilter.CountryID = 0;
objListVM = GetStateListVM(objFilter);
objListVM.Toast = WebCommon.SetToast(objResponse);
return(View("Index", objListVM));
}
}
catch (Exception ex)
{
throw;
}
finally
{
objStateBL = null;
objDetailsVM = null;
objListVM = null;
objCommonBL = null;
}
return(null);
}
/***Group Operation end****/
/***State Operation start****/
public async Task <string> AddEditState(StateMaster detail)
{
var data = JsonConvert.SerializeObject(detail);
var action = string.IsNullOrEmpty(detail.StateId) ? AddStateAction : EditStateAction;
var result = await CallPostFunction(data, action);
if (result == null || !result.Status)
{
return(result.ResponseValue);
}
else
{
return(string.Empty);
}
}
// GET: Admin/StateMasters/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StateMaster stateMaster = db.StateMasters.Find(id);
if (stateMaster == null)
{
return(HttpNotFound());
}
ViewBag.RefCountryId = new SelectList(db.CountryMasters, "CountryId", "CountryName", stateMaster.RefCountryId);
return(View(stateMaster));
}
public ActionResult Create([Bind(Include = "StateId,StateName,refCountryId")] StateMaster stateMaster)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Index", "adminLogin"));
}
if (ModelState.IsValid)
{
db.StateMasters.Add(stateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.refCountryId = new SelectList(db.CountryMasters, "CountryId", "CountryName", stateMaster.refCountryId);
return(View(stateMaster));
}
// GET: admin/StateMasters1/Details/5
public ActionResult Details(int?id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Index", "adminLogin"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StateMaster stateMaster = db.StateMasters.Find(id);
if (stateMaster == null)
{
return(HttpNotFound());
}
return(View(stateMaster));
}
public static List <StateMaster> GetState(int countryID)
{
string res = "";
SqlDataReader reader = null;
SqlConnection con = null;
List <StateMaster> lstState = null;
SqlCommand objcmd = null;
StateMaster objState = null;
try
{
lstState = new List <StateMaster>();
using (con = DBconnection.ConnectToDB())
{
objcmd = new SqlCommand();
objcmd.Connection = con;
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "STP_GetStateDtls";
reader = objcmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
objState = new StateMaster();
countryID = Convert.ToInt32(reader["countryID"]);
objState.StateID = Convert.ToInt64(reader["StateID"]);
objState.StateName = Convert.ToString("" + reader["StateName"]);
lstState.Add(objState);
}
}
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Dispose();
objcmd = null;
con = null;
}
return(lstState);
}
public void fillstate()
{
try
{
List <StateMaster> _state = StateMasterCollection.GetAll();
StateMaster sm = new StateMaster();
sm.STATE_ID = 0;
sm.STATE_NAME = "-select state-";
_state.Insert(0, sm);
DropState.DataSource = _state;
DropState.DataTextField = "STATE_NAME";
DropState.DataValueField = "STATE_ID";
DropState.DataBind();
}
catch (Exception ex)
{
string script = "<script>alert('" + ex.Message + "');</script>";
}
}
// GET: admin/StateMasters1/Edit/5
public ActionResult Edit(int?id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Index", "adminLogin"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StateMaster stateMaster = db.StateMasters.Find(id);
if (stateMaster == null)
{
return(HttpNotFound());
}
ViewBag.refCountryId = new SelectList(db.CountryMasters, "CountryId", "CountryName", stateMaster.refCountryId);
return(View(stateMaster));
}
public ActionResult Edit(StateMasterVM objSttMstrVm)
{
try
{
using (var unitOfWork = new UnitWork1(new EAMSContext()))
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <StateMasterVM, StateMaster>();
});
IMapper mapper = config.CreateMapper();
StateMaster UpdateDto = mapper.Map <StateMasterVM, StateMaster>(objSttMstrVm);
unitOfWork.StateMasters.Update(UpdateDto);
unitOfWork.Complete();
return(RedirectToAction("Index"));
}
}
finally { }
}
public StateMaster State_Retrieve(int id)
{
StateMaster obj = new StateMaster();
using (MySqlDataReader reader = ExecuteDataReader("State_Retrieve",
CreateParameter("StateId", MySqlDbType.Int32, id)))
{
while (reader.Read())
{
obj.CountryId = Convert.ToInt32(reader["CountryId"]);
obj.CountryName = reader["CountryName"].ToString();
obj.StateId = Convert.ToInt32(reader["StateId"]);
obj.StateCode = reader["StateCode"].ToString();
obj.StateName = reader["StateName"].ToString();
obj.STDCode = reader["STDCode"].ToString();
}
}
return(obj);
}
