public CompassCat FindCompassCat(string id) { CompassCat _retVal = new CompassCat(); SqlConnection objCon = new SqlConnection(); SqlCommand objCom; ConnectionString(objCon); objCom = new SqlCommand("Select strCategoryID, strCategoryDescr, dteCreated, CreaterID, dteModified, ModifierID from GIOS.GIOS_SVC.CompassCat where strCategoryID ='" + id + "'", objCon); objCon.Open(); SqlDataReader reader = objCom.ExecuteReader(); while (reader.Read()) { _retVal = new CompassCat(); _retVal.strCategoryID = reader["strCategoryID"].ToString(); _retVal.strCategoryDescr = reader["strCategoryDescr"].ToString(); _retVal.dtmCreated = Convert.ToDateTime(reader["dteCreated"]); _retVal.strCreatorID = reader["CreaterID"].ToString(); if (reader["dteModified"] == System.DBNull.Value) { _retVal.dtmModified = null; } else { _retVal.dtmModified = Convert.ToDateTime(reader["dteModified"]); } _retVal.strModifierID = reader["ModifierID"].ToString(); } reader.Close(); objCon.Close(); return(_retVal); }
public string CreateEditCompassCat(string AddUpdateFlag, CompassCat compassCat) { string _retVal; SqlConnection objCon = new SqlConnection(); SqlCommand objCom; try { ConnectionString(objCon); objCom = new SqlCommand("GIOS.GIOS_AddUpdateCompassCat", objCon); objCom.CommandType = System.Data.CommandType.StoredProcedure; objCom.Parameters.Add(new SqlParameter("@AddupdateFlag", AddUpdateFlag)); objCom.Parameters.Add(new SqlParameter("@strCategoryID", compassCat.strCategoryID)); objCom.Parameters.Add(new SqlParameter("@strCategoryDescr", compassCat.strCategoryDescr)); if (AddUpdateFlag == "I") { objCom.Parameters.Add(new SqlParameter("@strUserID", compassCat.strCreatorID)); } else { objCom.Parameters.Add(new SqlParameter("@strUserID", compassCat.strModifierID)); } objCon.Open(); objCom.ExecuteScalar(); objCon.Close(); _retVal = "Sucess"; } catch (Exception ex) { _retVal = ex.Message; } return(_retVal); }
public ActionResult DDLCompassCat(string id) { CompassCat compassCat = new CompassCat { CategoryDDL = new SelectList(useCase_DAL.ListCompassCats(), "strCategoryID", "strCategoryDescr") }; return(Json(compassCat.CategoryDDL, JsonRequestBehavior.AllowGet)); }
public ActionResult ListCompassCat() { CompassCat compassCat = new CompassCat { CategoryList = useCase_DAL.ListCompassCats().ToList() }; return(PartialView(compassCat.CategoryList)); }
public ActionResult UpdateCompassCat(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var CompassCatToEdit = useCase_DAL.FindCompassCat(id); CompassCat compassCat = CompassCatToEdit; return(PartialView(compassCat)); }
public ActionResult UpdateCompassCat(string id, [Bind(Include = "strCategoryID, strCategoryDescr, strCreatorID")] CompassCat modCompassCat) { try { // TODO: Add update logic here modCompassCat.strModifierID = GetUserID(); string message = useCase_DAL.CreateEditCompassCat("U", modCompassCat); ViewBag.Err = message; return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult CreateCompassCat([Bind(Include = "strCategoryID, strCategoryDescr")] CompassCat newCompassCat) { try { newCompassCat.strCreatorID = GetUserID(); string message = useCase_DAL.CreateEditCompassCat("I", newCompassCat); ViewBag.Err = message; return(RedirectToAction("Index")); } catch { // ViewBag.Err(ex.Message); return(View()); } }
public IEnumerable <CompassCat> ListCompassCats() { List <CompassCat> _retVal = new List <CompassCat>(); SqlConnection objCon = new SqlConnection(); SqlCommand objCom; CompassCat compassCat; ConnectionString(objCon); objCom = new SqlCommand("Select strCategoryID, strCategoryDescr, dteCreated, CreaterID, dteModified, ModifierID from GIOS.GIOS_SVC.CompassCat", objCon); objCon.Open(); SqlDataReader reader = objCom.ExecuteReader(); while (reader.Read()) { compassCat = new CompassCat(); compassCat.strCategoryID = reader["strCategoryID"].ToString(); compassCat.strCategoryDescr = reader["strCategoryDescr"].ToString(); compassCat.dtmCreated = Convert.ToDateTime(reader["dteCreated"]); compassCat.strCreatorID = reader["CreaterID"].ToString(); if (reader["dteModified"] == System.DBNull.Value) { compassCat.dtmModified = null; } else { compassCat.dtmModified = Convert.ToDateTime(reader["dteModified"]); } compassCat.strModifierID = reader["ModifierID"].ToString(); _retVal.Add(compassCat); } reader.Close(); objCon.Close(); return(_retVal); }