private List <Sub_Results> fetchSubResultsWithDetailWeb(SqlCommand cmd, int sid)
{
SqlConnection con = cmd.Connection;
List <Sub_Results> sub_results = null;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
sub_results = new List <Sub_Results>();
while (dr.Read())
{
Sub_Results sr = new Sub_Results();
sr.id = Convert.ToString(dr["id"]);
sr.name = Convert.ToString(dr["name"]);
sr.Publish = Convert.ToString(dr["publish"]);
sr.Percentage = Convert.ToDouble(dr["percentage"]);
sr.S_r = SelectResultByRidSid_ForWeb(Convert.ToInt32(dr["id"]), sid);
sub_results.Add(sr);
}
sub_results.TrimExcess();
}
}
return(sub_results);
}
public ActionResult PublishSubResult(Sub_Result Update, int id)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
Sub_Results SubResult = new Sub_Results();
SubResult.Publish = Update.Publish;
new Cateloge().PublishSubResults(SubResult, id);
if (Update.Publish == "2")
{
TempData["Msg"] = "Sub Result Have Published Successfully";
}
else
{
TempData["Msg"] = "Sub Result Have Blocked Successfully";
}
return(RedirectToAction("View", new { id = id }));
}
return(RedirectToAction("Index"));
}
}
private List <Sub_Results> fetchSubResults(SqlCommand cmd)
{
SqlConnection con = cmd.Connection;
List <Sub_Results> sub_results = null;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
sub_results = new List <Sub_Results>();
while (dr.Read())
{
Sub_Results sr = new Sub_Results();
sr.id = Convert.ToString(dr["id"]);
sr.name = Convert.ToString(dr["name"]);
sr.Publish = Convert.ToString(dr["publish"]);
sr.S_id = SelectResultTitleById(Convert.ToInt32(dr["r_id"]));
sub_results.Add(sr);
}
sub_results.TrimExcess();
}
}
return(sub_results);
}
public void PublishSubResult(Sub_Results pr, int id)
{
SqlCommand cmd = new SqlCommand("Update sub_results Set publish=@Publish_result Where id=@Id", DALUtil.getConnection());
cmd.Parameters.AddWithValue("@Id", id);
cmd.Parameters.AddWithValue("@Publish_result", (pr.Publish == null) ? Convert.DBNull : pr.Publish);
addresult(cmd);
}
public void UpdateSubResult(Sub_Results usr, int id)
{
SqlCommand cmd = new SqlCommand("Update sub_results Set name=@Name Where id=@Id", DALUtil.getConnection());
cmd.Parameters.AddWithValue("@Id", id);
cmd.Parameters.AddWithValue("@Name", (usr.name == null) ? Convert.DBNull : usr.name);
addresult(cmd);
}
public void AddSubResult(Sub_Results sr, int Id)
{
SqlCommand cmd = new SqlCommand("INSERT into sub_results (r_id,name,date,month,year,time) VALUES (@Id,@Name,@Date,@Month,@Year,@Time)", DALUtil.getConnection());
cmd.Parameters.AddWithValue("@Id", Id);
cmd.Parameters.AddWithValue("@Name", (sr.name == null) ? Convert.DBNull : sr.name);
cmd.Parameters.AddWithValue("@Date", (sr.Date == null) ? Convert.DBNull : sr.Date);
cmd.Parameters.AddWithValue("@Month", (sr.Month == null) ? Convert.DBNull : sr.Month);
cmd.Parameters.AddWithValue("@Year", (sr.Year == null) ? Convert.DBNull : sr.Year);
cmd.Parameters.AddWithValue("@Time", (sr.Time == null) ? Convert.DBNull : sr.Time);
addresult(cmd);
}
public ActionResult SubResults(Sub_Result Add, int id)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
Sub_Results AddSubResult = new Sub_Results();
AddSubResult.name = Add.name;
AddSubResult.Date = DateTime.Today.ToString("dd-MM-yyyy");
AddSubResult.Month = DateTime.Today.ToString("MMM");
AddSubResult.Year = DateTime.Today.ToString("yyyy");
AddSubResult.Time = DateTime.Now.ToString("HH:mm:ss");
new Cateloge().AddSubResult(AddSubResult, id);
TempData["Msg"] = "New Sub Result Have Added Successfully";
return(RedirectToAction("View", new { id = id }));
}
return(RedirectToAction("Index"));
}
}
public void PublishSubResults(Sub_Results sr, int id)
{
new AddAndUpdtResultDAL().PublishSubResult(sr, id);
}
public void AddSubResult(Sub_Results sr, int id)
{
new AddAndUpdtResultDAL().AddSubResult(sr, id);
}
