public DataSet Insert_InstituteList(ChoiceFilling _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("Student_Choice_Filling_Insert", _cn); _cmd.Parameters.AddWithValue("@Created_By", _obj.studentid); _cmd.Parameters.AddWithValue("@Type", _obj.Type); _cmd.Parameters.AddWithValue("@Control", _obj.Control); _cmd.Parameters.AddWithValue("@Discipline_ID", _obj.Discipline_ID); _cmd.Parameters.AddWithValue("@ProgramLevel_Id", _obj.ProgramLevel_Id); _cmd.Parameters.AddWithValue("@Natureofcourse_Id", _obj.Natureofcourse_Id); _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); _cmd.Parameters.AddWithValue("@Branch_Id", _obj.Branch_Id); _cmd.Parameters.AddWithValue("@Institute_List_JSON", _obj.Institute_List_JSON); _cmd.Parameters.AddWithValue("@StudentId", _obj.studentid); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public DataSet Insert_InstituteList_New(ChoiceFilling _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("Student_Choice_Filling_Insert_New", _cn); _cmd.Parameters.AddWithValue("@Student_ID", _obj.studentid); _cmd.Parameters.AddWithValue("@InstituteCourse_ID", _obj.InstituteCourse_ID); _cmd.Parameters.AddWithValue("@CreatedBy", _obj.CreatedBy); _cmd.Parameters.AddWithValue("@CreatedIp", _obj.CreatedIp); _cmd.Parameters.AddWithValue("@SeatWaivertype", _obj.SeatWaivertype); _cmd.Parameters.AddWithValue("@Type", _obj.Type); _cmd.Parameters.AddWithValue("@Control", _obj.Control); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public DataSet UpdateSequenceNumber_swap_move(ChoiceFilling _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("update_SequenceNumber_swap_move", _cn); _cmd.Parameters.AddWithValue("@Created_By", _obj.studentid); _cmd.Parameters.AddWithValue("@Type", _obj.Type); _cmd.Parameters.AddWithValue("@drpformid", _obj.drpformid); _cmd.Parameters.AddWithValue("@drptoid", _obj.drptoid); _cmd.Parameters.AddWithValue("@Created_Ip", _obj.CreatedIp); _cmd.Parameters.AddWithValue("@studentid", _obj.studentid); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public DataSet student_submit_choice_filling(ChoiceFilling _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("student_submit_choice_filling", _cn); _cmd.Parameters.AddWithValue("@student_id", _obj.studentid); _cmd.Parameters.AddWithValue("@ip", _obj.CreatedIp); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public JsonResult UpdateSequenceNumber_swap_move(ChoiceFilling obj) { ChoiceFillingRepository objRep = new ChoiceFillingRepository(); //obj.Type = "SWAP"; string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); obj.CreatedIp = localIP; obj.studentid = Session["studentid"].ToString(); DataSet _ds = objRep.UpdateSequenceNumber_swap_move(obj); bool flag = true; if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "0") { flag = false; } } } return(Json(new { flag = flag }, JsonRequestBehavior.AllowGet )); }
public JsonResult Insert_InstituteList(ChoiceFilling _obj) { ChoiceFillingRepository objRep = new ChoiceFillingRepository(); _obj.studentid = Session["studentid"].ToString(); _obj.CreatedBy = Session["studentid"].ToString(); _obj.CreatedIp = Session["localIP"].ToString(); DataSet _ds = objRep.Insert_InstituteList_New(_obj); bool flag = true; if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "0") { flag = false; } } } return(Json(new { flag = flag }, JsonRequestBehavior.AllowGet )); }
public JsonResult student_submit_choice_filling(ChoiceFilling obj) { ChoiceFillingRepository objRep = new ChoiceFillingRepository(); //obj.Type = "SWAP"; string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); obj.CreatedIp = localIP; obj.studentid = Session["studentid"].ToString(); DataSet _ds = objRep.student_submit_choice_filling(obj); bool flag = true; SendEmail _objseedemail = new SendEmail(); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "0") { flag = false; } else { string strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername"]; string Subject = "Study in India"; StringBuilder MailBody = new StringBuilder(); MailBody.Append("<br/>Dear Candidate, " + Session["studentname"].ToString() + ",<br/>"); MailBody.Append("<br/>Thank you for choosing Study in India!"); MailBody.Append("<br/>You have successfully submitted your choices for institutes."); MailBody.Append("<br/>Results of the counseling will be shared with you shortly."); MailBody.Append("<br/><br/><br/>Best,<br/>"); MailBody.Append("Study in India Team<br/>"); string bcc = ""; string cc = ""; _objseedemail.SendEmailInBackgroundThread(strform, Session["Email"].ToString(), bcc, cc, Subject, MailBody.ToString(), "", true); } } } return(Json(new { flag = flag }, JsonRequestBehavior.AllowGet )); }
public JsonResult SelectInstitute(ChoiceFilling obj) { ChoiceFillingRepository objRep = new ChoiceFillingRepository(); obj.Type = "GridDetails"; obj.studentid = Session["studentid"].ToString(); obj.CreatedBy = Session["studentid"].ToString(); DataSet ds = objRep.Select_InstituteList(obj); List <ChoiceFilling> _list = new List <ChoiceFilling>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { ChoiceFilling objChoice = new ChoiceFilling(); //objChoice.ID = row["ID"].ToString(); objChoice.tbl_InstituteCourse_ID = row["tbl_InstituteCourse_ID"].ToString(); objChoice.InstituteID = row["InstituteId"].ToString(); //objChoice.Discipline = row["Discipline"].ToString(); objChoice.Natureofcourse = row["Natureofcourse"].ToString(); //objChoice.ProgramLevel = row["ProgramLevel"].ToString(); // objChoice.BranchName = row["BranchName"].ToString(); objChoice.InstituteName = row["InstituteName"].ToString(); // objChoice.DisplayName = row["DisplayName"].ToString(); objChoice.state_name = row["state_name"].ToString(); objChoice.G1SeatWaiver = row["G1SeatWaiver"].ToString(); objChoice.G2SeatWaiver = row["G2SeatWaiver"].ToString(); objChoice.G3SeatWaiver = row["G3SeatWaiver"].ToString(); objChoice.G4SeatWaiver = row["G4SeatWaiver"].ToString(); _list.Add(objChoice); } } } return(Json(new { List = _list }, JsonRequestBehavior.AllowGet )); }
public ActionResult SelectInstitutePaging(ChoiceFilling obj) { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); string search = Request.Form.GetValues("search[value]").FirstOrDefault(); // var data=""; int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; ChoiceFillingRepository objRep = new ChoiceFillingRepository(); obj.Type = "GridDetails"; obj.studentid = Session["studentid"].ToString(); obj.CreatedBy = Session["studentid"].ToString(); List <ChoiceFilling> _list = new List <ChoiceFilling>(); DataSet ds = objRep.Select_InstituteList(obj); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { ChoiceFilling objChoice = new ChoiceFilling(); objChoice.tbl_InstituteCourse_ID = row["tbl_InstituteCourse_ID"].ToString(); objChoice.InstituteID = row["InstituteId"].ToString(); objChoice.Natureofcourse = row["Natureofcourse"].ToString(); objChoice.InstituteName = row["InstituteName"].ToString(); objChoice.state_name = row["state_name"].ToString(); objChoice.G1SeatWaiver = row["G1SeatWaiver"].ToString(); objChoice.G2SeatWaiver = row["G2SeatWaiver"].ToString(); objChoice.G3SeatWaiver = row["G3SeatWaiver"].ToString(); objChoice.G4SeatWaiver = row["G4SeatWaiver"].ToString(); _list.Add(objChoice); } } } List <ChoiceFilling> list = new List <ChoiceFilling>(); if (search == null) { list = _list; } else { // simulate search foreach (ChoiceFilling dataItem in _list) { if (dataItem.InstituteName.ToUpper().Contains(search.ToUpper()) || dataItem.Natureofcourse.ToString().Contains(search.ToUpper())) { list.Add(dataItem); } } } var v = list; recordsTotal = v.Count(); var data = v.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }, JsonRequestBehavior.AllowGet)); }