public ActionResult Addregister_institute(register_institute myregins)
{
register_institute addreg = new Models.register_institute();
addreg.AcceptCode = myregins.AcceptCode;
addreg.Address = myregins.Address;
addreg.City = myregins.City;
addreg.CodeMelli = myregins.CodeMelli;
addreg.InstituteName = myregins.InstituteName;
addreg.InstituteType = myregins.InstituteType;
addreg.ManagerName = myregins.ManagerName;
addreg.Mobile = myregins.Mobile;
addreg.Ostan = myregins.Ostan;
addreg.Tell = myregins.Tell;
db.register_institutes.Add(addreg);
db.SaveChanges();
ViewModel.ViewBagError myerror = new ViewModel.ViewBagError();
myerror.ClassName = "success";
myerror.Msg = "دانش آموز با موفقیت ایجاد گردید.";
ViewBag.ErrorMsg = myerror;
return(RedirectToAction("register_institute"));
}
public ActionResult SendContact(SendContactModel MyContact)
{
ViewModel.ViewBagError msg = new ViewModel.ViewBagError();
msg.ClassName = "success";
msg.Msg = "پیام شما به دست ما رسید . کارشناسان ما درخواست شما را بررسی کرده و در صورت لزوم با شما تماس خواهند گرفت .";
TempData["msg"] = msg;
return(RedirectToAction("Contact", "Home", null));
}
public ActionResult institute(int id)
{
if (id != 0)
{
App_Start.ConnectionString constr = new App_Start.ConnectionString();
ConnectionString = constr.GetConnectionString();
SqlConnection conn = new SqlConnection(ConnectionString);
SqlDataReader rdr = null;
//============================================================
//--------------------- Get Institute Info ------
ViewModel.InstituteInfo_VM InstituteInfo = new ViewModel.InstituteInfo_VM();
#region Get Institute Info
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(@"select Institutes.id,Institutes.name,Institutes.tel1,Institutes.tel2,Institutes.website,Institutes.address
,Institutes.boyOrGirl,Institutes.city_code,Institutes.shoar,Institutes.Email
,Institutes.Group_Channel1,Institutes.Group_Channel2,Institutes.Group_Channel3,Institutes.Group_Channel4
,Institutes.Description,Institutes.mobile1,Institutes.mobile2,Institutes.Google_Map,Institutes.En_Name
,(select InstituteKind.Name from InstituteKind where InstituteKind.id=Institutes.InstituteKindid) as InstituteKindName
from Institutes
where
Institutes.id =@id
and (Institutes.Active is null or Institutes.Active=1) " , conn);
cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.BigInt));
cmd.Parameters["@id"].Value = id;
rdr = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(rdr);
if (dataTable != null)
{
if (dataTable.Rows.Count > 0)
{
DataRow dr = dataTable.Rows[0];
InstituteInfo.id = id;
InstituteInfo.name = dr["name"].ToString();
InstituteInfo.tel1 = dr["tel1"].ToString();
InstituteInfo.tel2 = dr["tel2"].ToString();
InstituteInfo.website = dr["website"].ToString();
InstituteInfo.address = dr["address"].ToString();
InstituteInfo.boyOrGirl = dr["boyOrGirl"].ToString() != ""?bool.Parse(dr["boyOrGirl"].ToString()):(bool?)null;
InstituteInfo.city_code = dr["city_code"].ToString();
InstituteInfo.shoar = dr["shoar"].ToString();
InstituteInfo.Email = dr["Email"].ToString();
InstituteInfo.Group_Channel1 = dr["Group_Channel1"].ToString();
InstituteInfo.Group_Channel2 = dr["Group_Channel2"].ToString();
InstituteInfo.Group_Channel3 = dr["Group_Channel3"].ToString();
InstituteInfo.Group_Channel4 = dr["Group_Channel4"].ToString();
InstituteInfo.Description = dr["Description"].ToString();
InstituteInfo.mobile1 = dr["mobile1"].ToString();
InstituteInfo.mobile2 = dr["mobile2"].ToString();
InstituteInfo.Google_Map = dr["Google_Map"].ToString();
InstituteInfo.En_Name = dr["En_Name"].ToString();
InstituteInfo.InstituteKindName = dr["InstituteKindName"].ToString();
dataTable.Dispose();
}
}
}
catch (Exception ex)
{
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError();
viewbagerror.ClassName = "alert-danger";
viewbagerror.Msg = "خطا در لود اطلاعات آموزشگاه : " + ex.Message;
ViewBag.ErrorMsg = viewbagerror;
}
#endregion
//--------------------- Get Institute Info ------
//============================================================
if (InstituteInfo.name != null)
{
//============================================================
//--------------------- Get Institute Grades ------
List <Grade> InstituteGrades = new List <Grade>();
#region Get Institute Grades
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(@"select Grades.id,Grades.Name
from Institute_Grade
inner join Grades ON
Institute_Grade.Instituteid=@id
AND Grades.id = Institute_Grade.Gradeid " , conn);
cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.BigInt));
cmd.Parameters["@id"].Value = id;
rdr = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(rdr);
if (dataTable != null)
{
if (dataTable.Rows.Count > 0)
{
InstituteGrades = (from DataRow dr in dataTable.Rows
select new Grade()
{
id = int.Parse(dr["id"].ToString()),
Name = dr["Name"].ToString()
}
).ToList();
ViewBag.InstituteGrades = InstituteGrades;
dataTable.Dispose();
}
}
}
catch (Exception ex)
{
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError();
viewbagerror.ClassName = "alert-danger";
viewbagerror.Msg = "خطا در لود پایه های تحصیلی آموزشگاه : " + ex.Message;
ViewBag.ErrorMsg = viewbagerror;
}
#endregion
//--------------------- Get Institute Grades ------
//============================================================
try
{
ViewBag.Images = Directory.EnumerateFiles(Server.MapPath("~/Content/images/schools/" + id + ""))
.Where(fn => Path.GetFileName(fn) != InstituteInfo.id + "-logo.png" &&
Path.GetFileName(fn) != InstituteInfo.id + "-main.png" &&
Path.GetFileName(fn) != InstituteInfo.id + "-head.png"
)
.Select(fn => "~/Content/images/schools/" + id + "/" + Path.GetFileName(fn));
}
catch (Exception ex)
{
;
}
}
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
return(View(InstituteInfo));
}
return(View());
}
public ActionResult institutes()
{
App_Start.ConnectionString constr = new App_Start.ConnectionString();
ConnectionString = constr.GetConnectionString();
SqlConnection conn = new SqlConnection(ConnectionString);
SqlDataReader rdr = null;
//============================================================
//--------------------- Get Cities ------
List <City> tbl_ostan = new List <City>();
#region Get Institute Cities
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(@"select Code,Pname from Cities where Code=State_Code and (active is null or active =1) order by Code", conn);
rdr = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(rdr);
if (dataTable != null)
{
if (dataTable.Rows.Count > 0)
{
tbl_ostan = (from DataRow dr in dataTable.Rows
select new City()
{
Code = int.Parse(dr["Code"].ToString()),
Pname = dr["Pname"].ToString()
}
).ToList();
ViewBag.ostanlist = tbl_ostan;
dataTable.Dispose();
}
}
}
catch (Exception ex)
{
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError();
viewbagerror.ClassName = "alert-danger";
viewbagerror.Msg = "خطا در لود پایه های تحصیلی آموزشگاه : " + ex.Message;
ViewBag.ErrorMsg = viewbagerror;
}
#endregion
//--------------------- Get Cities ------
//============================================================
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
ViewBag.Current_ostan = 0;
return(View());
}
public ActionResult Employee_list(int?page)
{
int pageIndex = 1;
int pagesize = 2;
pageIndex = page.HasValue ? Convert.ToInt32(page) : 1;
IPagedList <ViewModel.EmployeeList_VM> result = null;
User userinfo = (User)Session["User"];
#region Get Session
ViewModel.Institute_Info_Session_VM Institute_info_Session = new ViewModel.Institute_Info_Session_VM();
if (Session["Institute_info"] != null)
{
Institute_info_Session = (ViewModel.Institute_Info_Session_VM)Session["Institute_info"];
}
else
{
Institute_info_Session = null;
}
#endregion
if (Institute_info_Session != null)
{
App_Start.ConnectionString constr = new App_Start.ConnectionString();
ConnectionString = constr.GetConnectionString();
SqlConnection conn = new SqlConnection(ConnectionString);
SqlDataReader rdr = null;
//============================================================
//--------------------- Get Employee List in Class id ---
List <ViewModel.EmployeeList_VM> EmployeeList = new List <ViewModel.EmployeeList_VM>();
#region Get Employee List in Institute id
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(@"select Users.username,Users.firstname,Users.lastname,Users.gender,
case
When User_Jobs.Jobid = 1 Then Users.Manager_Code
When User_Jobs.Jobid = 2 Then Users.Teacher_Code
When User_Jobs.Jobid = 5 Then Users.Employe_Code
End as Code
,
(select Jobs.Name from Jobs where Jobs.id = User_Jobs.Jobid) as JobName
from User_Jobs
inner join Users On
User_Jobs.Instituteid =@Instituteid
and (User_Jobs.Jobid != 3 and User_Jobs.Jobid != 4)
and Users.username like User_Jobs.Username
", conn);
cmd.Parameters.Add(new SqlParameter("@Instituteid", SqlDbType.Int));
cmd.Parameters["@Instituteid"].Value = Institute_info_Session.id;
rdr = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(rdr);
if (dataTable != null)
{
if (dataTable.Rows.Count > 0)
{
EmployeeList = (from DataRow dr in dataTable.Rows
select new ViewModel.EmployeeList_VM()
{
username = dr["username"].ToString(),
firstname = dr["firstname"].ToString(),
lastname = dr["lastname"].ToString(),
gender = dr["gender"].ToString() != "" ? bool.Parse(dr["gender"].ToString()) : (bool?)null,
Code = dr["Code"].ToString(),
JobName = dr["JobName"].ToString()
}
).ToList();
dataTable.Dispose();
}
}
}
catch (Exception ex)
{
if (rdr != null)
{
rdr.Close();
rdr = null;
}
if (conn.State == ConnectionState.Open)
{
conn.Dispose();
conn.Close();
}
ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError();
viewbagerror.ClassName = "alert-danger";
viewbagerror.Msg = "خطا در لود لیست کارمندان : " + ex.Message;
ViewBag.ErrorMsg = viewbagerror;
}
#endregion
//--------------------- Get Employee List in Class id ---
//============================================================
result = EmployeeList.ToPagedList(pageIndex, pagesize);
return(View("~/Views/maindashboard/Employee/Employeelist.cshtml", result));
}
else
{
ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError();
viewbagerror.ClassName = "alert-danger";
viewbagerror.Msg = "شناسه آموزشگاه صحیح نیست.";
ViewBag.ErrorMsg = viewbagerror;
return(View("~/Views/maindashboard/Employee/Employeelist.cshtml"));
}
}
