public ActionResult Edit(int id)
{
if (Session["Role_id"].ToString() == "2")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Student> Student_list = db.Get_edit_student_list(id);
ViewBag.student = Student_list;
List_Header getheader = db.list_get_Headerdata(id);
ViewBag.getHeader = getheader;
List <List_Details> getdtl = db.List_get_detaildata(id);
ViewBag.getdtllist = getdtl;
ViewBag.id = id;
return(View(menudisplay));
}
}
public ActionResult updateCourse(int id)
{
var enddate_with_id = db.get_course_end_date(id);
DateTime date = DateTime.Now;
var current_date = date.Date;
if (enddate_with_id.created_date < current_date)
{
return(RedirectToAction("Index", "Course_list"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(15);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
TempData["mydata"] = id;
Batch_header bhdata = db.get_batch_Master_data(id);
ViewBag.bhdata = bhdata;
List <Batch_details> bddata = db.Get_Batch_detail_data(id);
ViewBag.bddata = bddata;
List <Teacher> tdp = db.Teacher_DropDown();
ViewBag.Teachdropdown = tdp;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
return(View(menudisplay));
}
}
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
Attendance_data count_user = db.Get_all_users();
ViewBag.allusers = count_user.att_id;
Attendance_data courses = db.Get_Valid_Course();
ViewBag.allcourses = courses.att_id;
Attendance_data helpers = db.Get_Expired_Course();
ViewBag.allhelper = helpers.att_id;
Attendance_data attendance = db.Get_all_attendance();
ViewBag.attendance = attendance.att_id;
List <Batch_header> bh_hd = db.Incomplete_course();
ViewBag.incom_cour = bh_hd;
return(View(menudisplay));
}
}
public ActionResult Index(int id)
{
if (Session["U_id"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
MV db = new MV();
AP_Menu menu = new AP_Menu();
var r = Convert.ToInt32(Session["U_id"]);
var user_id = r;
var Menulist = db.user_rights(user_id);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
//Merge_Ads_images MAI = new Merge_Ads_images();
//MAI.ads = db.adsdetail(id);
//MAI.images = db.adsdetailimages(id);
//MAI.Menu = menudisplay;
Ads ad = db.adsdetail(id);
ViewBag.ads = ad;
List <Ads> img_list = db.adsdetailimages(id);
ViewBag.imglst = img_list;
ViewBag.state = new SelectList(model.States, "S_id", "S_name");
ViewBag.category = new SelectList(model.Categories, "C_id", "C_Name");
return(View(menudisplay));
}
}
// GET: Pads
public ActionResult Index()
{
if (Session["U_id"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
AP_Menu menu = new AP_Menu();
var r = Convert.ToInt32(Session["U_id"]);
var user_id = r;
var Menulist = db.user_rights(user_id);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
Ads emp = db.AutoGenerate();
ViewBag.autoid = emp;
ViewBag.state = new SelectList(model.States, "S_id", "S_name");
ViewBag.category = new SelectList(model.Categories, "C_id", "C_Name");
//ViewBag.menu = menudisplay;
return(View(menudisplay));
}
}
public ActionResult Index()
{
if (Session["U_id"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
Merge_Ads_images MAI = new Merge_Ads_images();
AP_Menu menu = new AP_Menu();
var r = Convert.ToInt32(Session["U_id"]);
var user_id = r;
var Menulist = db.user_rights(user_id);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Ads> ads = db.fetchdetail(r);
ViewBag.data = ads;
//MAI.Menu = menudisplay;
//MAI.images = ads;
return(View(menudisplay));
}
}
public List<AP_Menu> user_rights(int user_id)
{
List<AP_Menu> DBase = new List<AP_Menu>();
using (SqlConnection conn = new SqlConnection(connstring))
{
using (SqlCommand cmd = new SqlCommand("select m.Menu_id ,m.Menu_name , m.Menu_parent_id ,m.Menu_URL from Login l , role r , user_privilege u , Menu m where l.Role_id = r.Role_id and r.Role_id = u.role_id and u.menu_id = m.Menu_id and l.User_id = @user_id", conn))
{
conn.Open();
SqlParameter user = cmd.Parameters.AddWithValue("@user_id", user_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AP_Menu emp = new AP_Menu();
emp.Menu_id = Convert.ToInt16(reader["Menu_id"]);
emp.Menu_name = reader["Menu_name"].ToString();
emp.Menu_URL = reader["Menu_URL"].ToString();
emp.Menu_parent_id = reader["Menu_parent_id"] != DBNull.Value ? Convert.ToInt16(reader["Menu_Parent_id"]) : (int?)null;
DBase.Add(emp);
}
}
}
return DBase;
}
// GET: New_Helper
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else if (Session["Role_id"].ToString() == "2")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Batch_header> Course_dropdown = db.get_Course_dropdown();
ViewBag.course = Course_dropdown;
List <List_Header> List_dropdown = db.get_list_dropdown();
ViewBag.list = List_dropdown;
return(View(menudisplay));
}
}
public ActionResult updateHelper(int id)
{
var enddate_with_id = db.get_helper_Course_end_date(id);
DateTime date = DateTime.Now;
var current_date = date.Date;
if (enddate_with_id.created_date < current_date)
{
return(RedirectToAction("Index", "Helper_list"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(15);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
TempData["mydata"] = id;
Helper_mst hmdata = db.get_helper_Master_data(id);
ViewBag.hmdata = hmdata;
List <Helper_dtl> hddata = db.Get_helper_detail_data(id);
ViewBag.hddata = hddata;
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
List <Batch_header> bh = db.Course_DropDown();
ViewBag.cordropdown = bh;
return(View(menudisplay));
}
}
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Batch_list> bhlist = db.Batchfetchdetail();
ViewBag.batchlist = bhlist;
return(View(menudisplay));
}
//AP_Menu menu = new AP_Menu();
//var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
//List<AP_Menu> menudisplay = menu.Menutree(Menulist, null);
//List<Batch_header> bh = db.Course_DropDown();
//ViewBag.cordropdown = bh;
//string status = null;
//if (Session["User_id"] == null)
//{
// status = "usernull";
//}
//else
//{
// if (Convert.ToInt32(Session["Role_id"]) == 1)
// {
// status = "done";
// }
// else
// {
// status = "usernotrole";
// }
//}
//if (status == "usernull")
//{
// return RedirectToAction("Index", "Login");
//}
//else if (status == "usernotrole")
//{
// return RedirectToAction("Index", "Dashboard");
//}
//else
//{
// return View(menudisplay);
//}
}
public ActionResult Index(int id, string bh_name)
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
List <Batch_list> bhlist = db.Batchfetchdetail();
ViewBag.batchlist = bhlist;
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Registor> Reg = db.fatch_students_list(id);
ViewBag.userdata = Reg;
ViewBag.Batch_name = bh_name;
return(View(menudisplay));
}
//string status = null;
//if (Session["User_id"] == null)
//{
// status = "usernull";
//}
//else
//{
// if (Convert.ToInt32(Session["Role_id"]) == 1)
// {
// status = "done";
// }
// else
// {
// status = "usernotrole";
// }
//}
//if (status == "usernull")
//{
// return RedirectToAction("Index", "Login");
//}
//else if (status == "usernotrole")
//{
// return RedirectToAction("Index", "Dashboard");
//}
//else
//{
// return View(menudisplay);
//}
}
public ActionResult Index()
{
AP_Menu menu = new AP_Menu();
//var user = Convert.ToInt32(Session["U_id"]);
var Menulist = db.user_rights(1);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
return(View(menudisplay));
}
// GET: List_details
public ActionResult Index(int id)
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <List_Details> listdetails = db.List_Details_data(id);
ViewBag.listdtl = listdetails;
return(View(menudisplay));
}
}
// GET: Helper
public ActionResult Index()
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Student> sdp = db.Student_DropDown();
ViewBag.stddropdown = sdp;
List <Batch_header> bh = db.Course_DropDown();
ViewBag.cordropdown = bh;
string status = null;
if (Session["User_id"] == null)
{
status = "usernull";
}
else
{
if (Convert.ToInt32(Session["Role_id"]) == 1)
{
status = "done";
}
else
{
status = "usernotrole";
}
}
if (status == "usernull")
{
return(RedirectToAction("Index", "Login"));
}
else if (status == "usernotrole")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
return(View(menudisplay));
}
}
public ActionResult Index()
{
if (Session["U_id"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
AP_Menu menu = new AP_Menu();
Merge_Ads_images MAI = new Merge_Ads_images();
var user = Convert.ToInt32(Session["U_id"]);
var Menulist = db.user_rights(user);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
var r = Session["U_id"].ToString();
var graph = db.adscount(r).ToArray();
List <Ads> ads = db.fetchdetail(Convert.ToInt16(r));
ViewBag.table_list = ads;
ViewBag.grap = graph;
var bid_count = db.count_bid(Convert.ToInt16(r));
ViewBag.bid_count = bid_count.id;
var bid_prod = db.count_prod(Convert.ToInt16(r));
ViewBag.bid_prod = bid_prod.id;
var earn = db.earntotal(Convert.ToInt16(r));
ViewBag.earn = earn.Price;
var bid_saleprod = db.count_saleprod(Convert.ToInt16(r));
ViewBag.bid_saleprod = bid_saleprod.id;
var count_bid = db.count_bidperprod(Convert.ToInt16(r));
ViewBag.count_bid = count_bid.id;
return(View(menudisplay));
}
}
// GET: New_Helper_List
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
List <Helper_mst> hm = db.Helpers_list();
ViewBag.hlp_list = hm;
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
return(View(menudisplay));
}
}
// GET: MonthReport_Param
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Batch_header> batch = db.Report_Courses_list();
ViewBag.bthdropdown = batch;
return(View(menudisplay));
}
}
// GET: List_Header_list
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <List_Header> AllList = db.List_Header_list();
ViewBag.alllist = AllList;
return(View(menudisplay));
}
}
// GET: User_Create
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
AP_Menu menu = new AP_Menu();
List <Role> tdp = db.Role_Dropdown();
ViewBag.roledropdown = tdp;
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
return(View(menudisplay));
}
}
public ActionResult Index()
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Batch_header> attlist = db.Attfetchdetail();
ViewBag.attlist = attlist;
string status = null;
if (Session["User_id"] == null)
{
status = "usernull";
}
else
{
if (Convert.ToInt32(Session["Role_id"]) == 1)
{
status = "done";
}
else
{
status = "usernotrole";
}
}
if (status == "usernull")
{
return(RedirectToAction("Index", "Login"));
}
else if (status == "usernotrole")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
return(View(menudisplay));
}
}
// GET: Users_update
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
List <Batch_list> bhlist = db.Batchfetchdetail();
ViewBag.batchlist = bhlist;
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Registor> Reg = db.Fetch_all_students_details();
ViewBag.userdata = Reg;
return(View(menudisplay));
}
}
// GET: Report_Param
public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
List <Batch_header> bh = db.Course_DropDown();
ViewBag.cordropdown = bh;
List <Student> std = db.Approved_student_list();
ViewBag.stddropdown = std;
return(View(menudisplay));
}
}
// GET: New_Helper_Update
public ActionResult Index(int id)
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else if (Session["Role_id"].ToString() == "2")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
Helper_mst hm = db.Hlp_mst_data(id);
ViewBag.hlphd = hm;
List <Helper_dtl> hd = db.Helpers_Details_list(id);
ViewBag.hlpdt = hd;
List <Helper_dtl> stud_list = db.List_dropdown(hm.list_id);
ViewBag.hlpdt_list = stud_list;
List <Batch_header> Course_dropdown = db.get_Course_dropdown();
ViewBag.course = Course_dropdown;
List <List_Header> List_dropdown = db.get_list_dropdown();
ViewBag.list = List_dropdown;
return(View(menudisplay));
}
}
// GET: UsersData_Update
public ActionResult Index(int id)
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "login"));
}
else if (Session["Role_id"].ToString() == "2")
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
TempData["Registor_bh_id"] = id;
Registor userdata = db.Registor_get_stud_data(id);
ViewBag.Userdata = userdata;
return(View(menudisplay));
}
}
public ActionResult Index()
{
if (Session["U_id"] == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
AP_Menu menu = new AP_Menu();
var r = Convert.ToInt32(Session["U_id"]);
var user_id = r;
var Menulist = db.user_rights(user_id);
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
//ViewBag.menu = menudisplay;
login login = db.user_profile(r);
ViewBag.data = login;
return(View(menudisplay));
}
}
