public ActionResult Create(SET_INSTITUTE set_institute)
{
if (ModelState.IsValid)
{
List <SET_INSTITUTE> search = db.SET_INSTITUTE.Where(s => s.THANA_NO == set_institute.THANA_NO &&
s.INST_TYPE_NO == set_institute.INST_TYPE_NO &&
s.INSTITUTE_NAME == set_institute.INSTITUTE_NAME).ToList();
if (search.Count == 0)
{
db.SET_INSTITUTE_INSERT(decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
set_institute.INSTITUTE_NAME,
set_institute.INSTITUTE_NAME_BNG,
set_institute.INSTITUTE_DESC,
set_institute.INST_TYPE_NO,
set_institute.THANA_NO,
set_institute.F_INSTITUTION_DB_ID,
set_institute.EIIN_NUMBER,
set_institute.MEET_PERSON_NAME,
set_institute.CONTACT_NUMBER,
set_institute.ACTUAL_LATI_VAL,
set_institute.ACTUAL_LONG_VAL, set_institute.FROM_LATI_VAL, set_institute.FROM_LONG_VAL,
set_institute.TO_LATI_VAL, set_institute.TO_LONG_VAL, set_institute.IS_ACTIVE,
set_institute.ACTIVE_FROM, set_institute.ACTIVE_TO, set_institute.SL_NUM);
}
return(RedirectToAction("Index"));
}
return(View(set_institute));
}
public ActionResult DeleteConfirmed(decimal id)
{
SET_INSTITUTE set_institute = db.SET_INSTITUTE.Single(s => s.INSTITUTE_NO == id);
db.SET_INSTITUTE.DeleteObject(set_institute);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /SetInstitute/Delete/5
public ActionResult Delete(decimal id = 0)
{
SET_INSTITUTE set_institute = db.SET_INSTITUTE.Single(s => s.INSTITUTE_NO == id);
if (set_institute == null)
{
return(HttpNotFound());
}
return(View(set_institute));
}
//
// GET: /SetInstitute/Edit/5
public ActionResult Edit(decimal id = 0)
{
SET_INSTITUTE set_institute = db.SET_INSTITUTE.Single(s => s.INSTITUTE_NO == id);
ViewBag.ins = db.SET_INST_TYPE.ToList();
ViewBag.Thanas = db.SET_ZILLA.OrderBy(x => x.ZILLA_NAME).ToList();
if (set_institute == null)
{
return(HttpNotFound());
}
return(View(set_institute));
}
public ActionResult Edit(SET_INSTITUTE set_institute)
{
if (ModelState.IsValid)
{
db.SET_INSTITUTE_UPDATE(set_institute.INSTITUTE_NO, decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()), set_institute.INSTITUTE_NAME,
set_institute.INSTITUTE_NAME_BNG, set_institute.INSTITUTE_DESC,
set_institute.INST_TYPE_NO, set_institute.THANA_NO,
set_institute.F_INSTITUTION_DB_ID, set_institute.EIIN_NUMBER,
set_institute.MEET_PERSON_NAME, set_institute.CONTACT_NUMBER,
set_institute.ACTUAL_LATI_VAL, set_institute.ACTUAL_LONG_VAL,
set_institute.FROM_LATI_VAL, set_institute.FROM_LONG_VAL,
set_institute.TO_LATI_VAL, set_institute.TO_LONG_VAL,
set_institute.IS_ACTIVE, set_institute.ACTIVE_FROM, set_institute.ACTIVE_TO,
set_institute.SL_NUM);
return(RedirectToAction("Index"));
}
return(View(set_institute));
}