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);
}
