public JsonResult Select_Campus_Life_On_Campus()
{
InstituteInfrascutureRepository objRep = new InstituteInfrascutureRepository();
DataSet ds = objRep.Select_Campus_Life_On_Campus(Session["InstituteID"].ToString());
List <LifeOnCampus> _list = new List <LifeOnCampus>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
LifeOnCampus objCourse = new LifeOnCampus();
objCourse.ID = row["ID"].ToString();
objCourse.InstituteID = row["InstituteId"].ToString();
objCourse.SportArea = row["SportArea"].ToString();
objCourse.TypesOfSportsCurrentlyPlayed = row["TypesOfSportsCurrentlyPlayed"].ToString();
objCourse.SportAccomplishments = row["SportAccomplishments"].ToString();
objCourse.MusicInstruments = row["MusicInstruments"].ToString();
objCourse.MusicAccomplishments = row["MusicAccomplishments"].ToString();
objCourse.AcademicBodie = row["AcademicBodie"].ToString();
objCourse.FestivalsConductedByStudents = row["FestivalsConductedByStudents"].ToString();
objCourse.NewsLatters = row["NewsLatters"].ToString();
objCourse.EventsCompetitions = row["EventsCompetitions"].ToString();
objCourse.OfficialEvents = row["OfficialEvents"].ToString();
_list.Add(objCourse);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public DataSet Save_Campus_Life_On_Campus(LifeOnCampus _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Insert_Update_Institute_Life_On_Campus", _cn);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@SportArea", _obj.SportArea);
_cmd.Parameters.AddWithValue("@TypesOfSportsCurrentlyPlayed", _obj.TypesOfSportsCurrentlyPlayed);
_cmd.Parameters.AddWithValue("@SportAccomplishments", _obj.SportAccomplishments);
_cmd.Parameters.AddWithValue("@MusicInstruments", _obj.MusicInstruments);
_cmd.Parameters.AddWithValue("@MusicAccomplishments", _obj.MusicAccomplishments);
_cmd.Parameters.AddWithValue("@AcademicBodie", _obj.AcademicBodie);
_cmd.Parameters.AddWithValue("@FestivalsConductedByStudents", _obj.FestivalsConductedByStudents);
_cmd.Parameters.AddWithValue("@NewsLatters", _obj.NewsLatters);
_cmd.Parameters.AddWithValue("@EventsCompetitions", _obj.EventsCompetitions);
_cmd.Parameters.AddWithValue("@OfficialEvents", _obj.OfficialEvents);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_cmd.Parameters.AddWithValue("@Edited_by", _obj.Edited_by);
_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 Save_Campus_Life_On_Campus(LifeOnCampus _obj)
{
_obj.InstituteID = Session["InstituteID"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
_obj.Edited_by = Session["User_id"].ToString();
string path = "";
string filename = "";
string fname = "";
if (Request.Files.Count > 0)
{
if (Request.Files[0].ContentLength > 0)
{
HttpFileCollectionBase files = Request.Files;
path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/Institute/" + _obj.InstituteID + "/Newslatter/";
filename = Path.GetFileName(Request.Files[0].FileName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
else
{
string[] curentfiles = Directory.GetFiles(path);
}
HttpPostedFileBase file = files[0];
filename = _obj.InstituteID + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetExtension(file.FileName);
fname = Path.Combine(Server.MapPath("~/Uploads/Institute/" + _obj.InstituteID + "/Newslatter/"), filename);
file.SaveAs(fname);
_obj.NewsLatters = "Uploads/Institute/" + _obj.InstituteID + "/Newslatter/" + filename;
}
else
{
_obj.NewsLatters = "";
}
}
else
{
_obj.NewsLatters = "";
}
InstituteInfrascutureRepository objRepository = new InstituteInfrascutureRepository();
DataSet _ds = objRepository.Save_Campus_Life_On_Campus(_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
));
}
