private DataTable getSchoolDetails()
{
DataTable dt = new DataTable("SchoolDetails");
dt.TableName = "SchoolDetails";
dt.Columns.Add(new DataColumn("ManagementName", typeof(string)));
dt.Columns.Add(new DataColumn("SchoolName", typeof(string)));
dt.Columns.Add(new DataColumn("Address", typeof(string)));
dt.Columns.Add(new DataColumn("Taluka", typeof(string)));
dt.Columns.Add(new DataColumn("District", typeof(string)));
dt.Columns.Add(new DataColumn("ContactNumber", typeof(string)));
dt.Columns.Add(new DataColumn("EmailId", typeof(string)));
dt.Columns.Add(new DataColumn("SchoolReconginationNo", typeof(string)));
dt.Columns.Add(new DataColumn("Medium", typeof(string)));
dt.Columns.Add(new DataColumn("UDiscNo", typeof(string)));
dt.Columns.Add(new DataColumn("Board", typeof(string)));
dt.Columns.Add(new DataColumn("AffilationNo", typeof(string)));
dt.Columns.Add(new DataColumn("LogoPath", typeof(string)));
SchoolDetailsBAL balObject = new SchoolDetailsBAL();
var entites = balObject.GetAll().Where(u => u.SchoolId == SessionHelper.SchoolId);
if (entites != null && entites.Count() > 0)
{
Entities.SchoolDetails entity = entites.FirstOrDefault();
DataRow dr = dt.NewRow();
dr["ManagementName"] = entity.ManagementName.Trim();
dr["SchoolName"] = entity.SchoolName.Trim();
dr["Address"] = entity.Address.Trim();
dr["Taluka"] = entity.Taluka.Trim();
dr["District"] = entity.District.Trim();
dr["ContactNumber"] = entity.ContactNumber.Trim();
dr["EmailId"] = entity.EmailId.Trim();
dr["SchoolReconginationNo"] = entity.SchoolReconginationNo.Trim();
dr["Medium"] = entity.Medium.Trim();
dr["UDiscNo"] = entity.UDiscNo.Trim();
dr["Board"] = entity.Board.Trim();
dr["AffilationNo"] = entity.AffilationNo.Trim();
string host = HttpContext.Current.Request.Url.Host;
dr["LogoPath"] = "http://" + host + entity.LogoPath.Trim();
dt.Rows.Add(dr);
}
return(dt);
}
public ActionResult Index(LoginUserVM entity)
{
int iRet = 0;
// iRet = ApplicationCore.VerifyLic(@"C:\inetpub\license.lic");
if (iRet != 0)
{
if (iRet == -1)
{
ViewBag.Error = myRes.Licensedatehaspassed;
}
else if (iRet == -4)
{
ViewBag.Error = myRes.Licensecopynotfound;
}
else
{
ViewBag.Error = myRes.Thelicensecopyisnotvalid;
}
}
if (ModelState.IsValid && iRet == 0)
{
UserBAL balObject = new UserBAL();
int schoolId = 0;
//var roles = from obj in roleObject.GetAll().Where(r => r.Status == true) select new SelectListItem() { Text = obj.RoleName, Value = obj.Id.ToString() };
//var roleEntities = roles.Where(r => r.Value == entity.RoleId.ToString());
//if (roleEntities != null && roleEntities.Count() > 0)
//{
//}
//balObject.OledbConnectionString = ConfigurationManager.ConnectionStrings["OLEDbConnection"].ToString();
var entites = balObject.GetAll().Where(u => u.RoleId == entity.RoleId && u.UserId.Trim() == entity.UserId.Trim() && u.Password.Trim() == entity.Password.Trim());
if (entites != null)
{
if (entites.Count() > 0)
{
Entities.User userEntity = entites.FirstOrDefault();
SessionHelper.UserId = entity.UserId;
SessionHelper.Username = userEntity.UserName;
SessionHelper.Title = userEntity.UserRole.RoleName;
SessionHelper.IsAuthenticated = true;
// get School Information
schoolId = userEntity.SchoolId;
SchoolDetailsBAL balObj = new SchoolDetailsBAL();
var entity1 = balObj.GetAll().Where(u => u.SchoolId == schoolId);
if (entity1 != null)
{
if (entity1.Count() > 0)
{
Entities.SchoolDetails userEntity1 = entity1.FirstOrDefault();
SessionHelper.SchoolName = userEntity1.SchoolName.Trim();
SessionHelper.SchoolId = userEntity1.SchoolId;
SessionHelper.LogoPath = userEntity1.LogoPath.Trim();
}
}
return(RedirectToAction("Index", "Home"));
}
}
ViewBag.Error = myRes.TheUserDoesNotExistOrTheProvidedUsernameOrPasswordIsIncorrect;
}
RoleBAL roleObject = new RoleBAL();
entity.Roles = from obj in roleObject.GetAll().Where(r => r.Status == true) select new SelectListItem()
{
Text = obj.RoleName, Value = obj.Id.ToString()
};
ViewBag.AdminRoleId = entity.Roles.Where(r => r.Text == "Admin").FirstOrDefault().Value;
return(View(entity));
}
