// GET: subJobTypes
public ActionResult Index()
{
List <tbl_subJobTypes> subJobTypes = new List <tbl_subJobTypes>();
string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
sqlconn.Open();
string sqlquery1 =
"SELECT tbl_subJobTypes.subJobID, tbl_subJobTypes.description " +
"FROM tbl_subJobTypes";
SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn);
SqlDataAdapter sda1 = new SqlDataAdapter(sqlcomm1);
DataTable dt1 = new DataTable();
sda1.Fill(dt1);
foreach (DataRow dr1 in dt1.Rows)
{
tbl_subJobTypes subJobType = new tbl_subJobTypes();
subJobType.subJobID = (byte)dr1[0];
subJobType.description = dr1[1].ToString();
subJobTypes.Add(subJobType);
}
sqlconn.Close();
return(View(subJobTypes));
//return View(db.tbl_subJobTypes.ToList());
}
//GET SUB JOB TYPES
public List <tbl_subJobTypes> subJobTypesByJobID(string jobID)
{
List <tbl_subJobTypes> subJobTypes = new List <tbl_subJobTypes>();
string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
string sqlquery1 = "SELECT tbl_subJobTypes.subJobID, tbl_subJobTypes.description " +
"FROM tbl_subJobTypes ";
SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn);
sqlcomm1.Parameters.Add(new SqlParameter("jobID", jobID));
SqlDataAdapter sda3 = new SqlDataAdapter(sqlcomm1);
DataTable dt1 = new DataTable();
sda3.Fill(dt1);
foreach (DataRow dr1 in dt1.Rows)
{
tbl_subJobTypes subJobType = new tbl_subJobTypes();
subJobType.subJobID = (byte)dr1[0];
subJobType.description = dr1[1].ToString();
subJobTypes.Add(subJobType);
}
return(subJobTypes);
}
public ActionResult DeleteSubJobType(tbl_subJobTypes subJobTypeDelete)
{
try
{
db.Database.ExecuteSqlCommand("DELETE FROM tbl_subJobTypes WHERE subJobID=({0})", subJobTypeDelete.subJobID);
return(Json(Url.Action("Index", "SubJobTypes")));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
public ActionResult AddSubJobType(tbl_subJobTypes subJobTypeAdd)
{
try
{
db.Database.ExecuteSqlCommand("Insert into tbl_subJobTypes Values({0})",
subJobTypeAdd.description);
return(Json(Url.Action("Index", "SubJobTypes")));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
public ActionResult UpdateSubJobType(tbl_subJobTypes subJobTypeUpdate)
{
try
{
db.Database.ExecuteSqlCommand(
"UPDATE tbl_subJobTypes " +
"SET " +
"description = {0} " +
"WHERE subJobID = {1}",
subJobTypeUpdate.description, subJobTypeUpdate.subJobID);
return(Json(Url.Action("Index", "SubJobTypes")));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
