protected void btnDelete_Click(object sender, EventArgs e) { if (Page.IsValid) { try { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(hfInstituteID.Value.ToString()); ; if (new BOInstituteDetails().DeleteInstituteDetails(toins)) { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Record deleted';var elem = document.createElement('img');elem.setAttribute('src', 'tick.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Green';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Institute Details Deleted Successfully', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); RefreshGridView(); clear(); } else { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Error';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Red';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Error', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); } } catch { } } }
public int? GetStudentCountReport(DTOInstituteDetails toinst, string gender) { using (Campus2CaretakerDataContext dbcontext = new Campus2CaretakerDataContext()) { return (dbcontext.GetStudentCount(toinst.InstituteID)).Where(t => t.Gender == gender).Select(x => x.TotalCount).FirstOrDefault(); } }
public List<DTOClasswiseCount> GetStudentCountClasswiseReport(DTOInstituteDetails toinst, string gender, int branchid) { Campus2CaretakerDataContext dbcontext = new Campus2CaretakerDataContext(); return (from v in dbcontext.GetStudentCountClasswiseGender(toinst.InstituteID) where v.Gender == gender && v.colBranchId == branchid select new DTOClasswiseCount { Count = v.TotalCount, ClassName = v.colBranchName }).ToList(); }
public bool DeleteInstituteDetails(DTOInstituteDetails toins) { try { Campus2CaretakerDataContext dbContext = new Campus2CaretakerDataContext(); // Institute Details tblInstituteDetail InstDetail = dbContext.tblInstituteDetails.Where(x => x.colInstituteId == toins.InstituteID).FirstOrDefault(); dbContext.tblInstituteDetails.DeleteOnSubmit(InstDetail); dbContext.SubmitChanges(); return true; } catch { return false; } }
protected void btnGetInstituteInfo_Click(object sender, EventArgs e) { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(hfInstituteID.Value); txtInstituteEmail.Enabled = false; btnSave.Enabled = false; btnUpdate.Enabled = true; btnDelete.Enabled = true; DataTable dt = new DataTable(); dt = new BOInstituteDetails().GetInstituteDetails(toins); try { txtInstituteName.Text = dt.Rows[0][0].ToString(); txtInstituteEmail.Text = dt.Rows[0][7].ToString(); Session["LogoPhoto"] = dt.Rows[0][3].ToString(); imgInstituteLogo.Src = "~/uploaded/" + Session["LogoPhoto"].ToString(); txtInstituteAddress.Text = dt.Rows[0][1].ToString(); txtInstitutePhoneNumber.Text = dt.Rows[0][2].ToString(); txtState.Text = dt.Rows[0][9].ToString(); txtDistrict.Text = dt.Rows[0][8].ToString(); txtMaxStudents.Text = dt.Rows[0][10].ToString(); if (dt.Rows[0][6].ToString().Equals("S")) { ddlInstituteType.SelectedIndex = 1; } else if (dt.Rows[0][6].ToString().Equals("C")) { ddlInstituteType.SelectedIndex = 2; } else if (dt.Rows[0][6].ToString().Equals("D")) { ddlInstituteType.SelectedIndex = 3; } txtPrincipalContactNumber.Text = dt.Rows[0][5].ToString(); txtPrincipalName.Text = dt.Rows[0][4].ToString(); } catch { } }
protected void LoginButton_Click(object sender, EventArgs e) { try { DTOLogin tologin = new DTOLogin(); tologin.UserID = UserName.Text; tologin.Password = PasswordEncDec.EncodePasswordToBase64(Password.Text); bool authenticated = new BOLogin().CheckInstituteUser(tologin); if (authenticated) { Session["InstituteID"] = new BOInstituteDetails().GetInstituteId(UserName.Text); Session["UserName"] = UserName.Text; DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteEmail = Session["UserName"].ToString(); toins.InstituteID = int.Parse(Session["InstituteID"].ToString()); DataTable dt = new BOInstituteDetails().GetInstituteDetails(toins); Session["LogoPath"] = dt.Rows[0][3].ToString(); Session["InstituteName"] = dt.Rows[0][0].ToString(); Session["InstituteType"] = dt.Rows[0][6].ToString(); Session["MaxStudentsInstitute"] = dt.Rows[0][10].ToString(); Response.Redirect("InstituteDefault.aspx"); } else { FailureText.Text = "Username or Password is incorrect."; } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public bool UpdateInstituteDetails(DTOInstituteDetails toinst) { return new DAOInstituteDetails().UpdateInstituteDetails(toinst); }
public bool DeleteInstituteDetails(DTOInstituteDetails toins) { return new DAOInstituteDetails().DeleteInstituteDetails(toins); }
public bool IsInstituteEmailExists(DTOInstituteDetails toinst) { return new DAOInstituteDetails().IsInstituteEmailExists(toinst); }
public DataTable GetInstituteDetails(DTOInstituteDetails toins) { return new DAOInstituteDetails().GetInstituteDetails(toins); }
public bool InsertInstituteDetails(DTOInstituteDetails toins) { try { Campus2CaretakerDataContext dbContext = new Campus2CaretakerDataContext(); // Institute Details tblInstituteDetail InstDetail = new tblInstituteDetail(); InstDetail.colAddress = toins.InstituteAddress; InstDetail.colInstituteName = toins.InstituteName; InstDetail.colInstituteType = toins.InstituteType; InstDetail.colLogoPath = toins.LogoPath; InstDetail.colPhone = toins.InstitutePhoneNo; InstDetail.colPrincipalContact = toins.PrincipalContact; InstDetail.colPrincipalName = toins.PrincipalName; InstDetail.colState = toins.State; InstDetail.colDistrict = toins.District; InstDetail.colMaxStudents = toins.MaxStudents; dbContext.tblInstituteDetails.InsertOnSubmit(InstDetail); dbContext.SubmitChanges(); // Institute Login Details tblInstituteLogin InstLogin = new tblInstituteLogin(); InstLogin.colInstituteId = dbContext.tblInstituteDetails.Select(x => x.colInstituteId).Max(); InstLogin.colPassword = toins.InstituteDefaultPwd; InstLogin.colUsername = toins.InstituteEmail; InstLogin.colUserType = toins.InstituteUserType; dbContext.tblInstituteLogins.InsertOnSubmit(InstLogin); dbContext.SubmitChanges(); return true; } catch { return false; } }
public bool InsertInstituteDetails(DTOInstituteDetails toinst) { return new DAOInstituteDetails().InsertInstituteDetails(toinst); }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Page.IsValid) { try { DTOInstituteDetails toinst = new DTOInstituteDetails(); toinst.InstituteID = int.Parse(hfInstituteID.Value.ToString()); toinst.InstituteName = txtInstituteName.Text; toinst.InstituteEmail = txtInstituteEmail.Text; if (imgInstituteLogo.Src != null) { toinst.LogoPath = Session["LogoPhoto"].ToString(); } toinst.InstituteAddress = txtInstituteAddress.Text; toinst.InstitutePhoneNo = txtInstitutePhoneNumber.Text; toinst.InstituteType = ddlInstituteType.SelectedValue; toinst.PrincipalContact = txtPrincipalContactNumber.Text; toinst.PrincipalName = txtPrincipalName.Text; toinst.State = txtState.Text; toinst.District = txtDistrict.Text; toinst.MaxStudents = int.Parse(txtMaxStudents.Text); if (new BOInstituteDetails().UpdateInstituteDetails(toinst)) { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Record updated';var elem = document.createElement('img');elem.setAttribute('src', 'tick.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Green';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Institute Details Updated Successfully', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); RefreshGridView(); clear(); } else { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Error';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Red';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Error', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); } } catch { } } }
public bool IsInstituteNameExists(DTOInstituteDetails toins) { try { Campus2CaretakerDataContext dbContext = new Campus2CaretakerDataContext(); int inCount = dbContext.tblInstituteDetails.Where(x => x.colInstituteName == toins.InstituteName).Count(); if (inCount > 0) return true; else return false; } catch { return false; } }
public bool UpdateInstituteDetails(DTOInstituteDetails toins) { try { Campus2CaretakerDataContext dbContext = new Campus2CaretakerDataContext(); // Institute Details tblInstituteDetail InstDetail = dbContext.tblInstituteDetails.Where(x => x.colInstituteId == toins.InstituteID).FirstOrDefault(); InstDetail.colAddress = toins.InstituteAddress; InstDetail.colInstituteName = toins.InstituteName; InstDetail.colInstituteType = toins.InstituteType; InstDetail.colLogoPath = toins.LogoPath; InstDetail.colPhone = toins.InstitutePhoneNo; InstDetail.colPrincipalContact = toins.PrincipalContact; InstDetail.colPrincipalName = toins.PrincipalName; InstDetail.colState = toins.State; InstDetail.colDistrict = toins.District; InstDetail.colMaxStudents = toins.MaxStudents; dbContext.SubmitChanges(); return true; } catch { return false; } }
protected void btnSave_Click(object sender, EventArgs e) { //to Save a new employee to the db and updates it to the below gridview if (Page.IsValid) { DTOInstituteDetails toinst = new DTOInstituteDetails(); toinst.InstituteName = txtInstituteName.Text; toinst.InstituteEmail = txtInstituteEmail.Text; if (new BOInstituteDetails().IsInstituteNameExists(toinst) || new BOInstituteDetails().IsInstituteEmailExists(toinst)) { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Institute already exists!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Red';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Institute already exists', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); return; } if (imgInstituteLogo.Src != null) { toinst.LogoPath = Session["LogoPhoto"].ToString(); } toinst.InstituteAddress = txtInstituteAddress.Text; toinst.InstitutePhoneNo = txtInstitutePhoneNumber.Text; toinst.InstituteType = ddlInstituteType.SelectedValue; toinst.PrincipalContact = txtPrincipalContactNumber.Text; toinst.PrincipalName = txtPrincipalName.Text; toinst.State = txtState.Text; toinst.District = txtDistrict.Text; toinst.MaxStudents = int.Parse(txtMaxStudents.Text); RandomStringGenerator randstring = new RandomStringGenerator(); string DefaultPwd = randstring.Generate(8); toinst.InstituteDefaultPwd = PasswordEncDec.EncodePasswordToBase64(DefaultPwd); toinst.InstituteUserType = "Usr"; if (new BOInstituteDetails().InsertInstituteDetails(toinst)) { //string script = @"document.getElementById('" + divStatus.ClientID + "').innerHTML='Record inserted';var elem = document.createElement('img');elem.setAttribute('src', 'tick.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Green';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Institute Details Saved Successfully', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); #region E-Mail //Send mail string s_subject = "Institute Account Details From Campus2Caretaker"; string s_msg = "Please use the below details for managing your institute account in Campus2Caretaker." + Environment.NewLine + Environment.NewLine; string s_link = "http://" + Request.ServerVariables["SERVER_NAME"] + ":" + Request.ServerVariables["SERVER_PORT"] + "/Institute/InstituteLogin.aspx"; s_msg += s_link + Environment.NewLine + Environment.NewLine; s_msg += "Username and Password to Login to account is" + Environment.NewLine + Environment.NewLine; s_msg += "Username :"******"Password :"******"document.getElementById('" + divStatus.ClientID + "').innerHTML='Error';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + divStatus.ClientID + "').appendChild(elem);document.getElementById('" + divStatus.ClientID + "').style.color = 'Red';document.getElementById('" + divStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + divStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + divStatus.ClientID + "').style.display='none';},4500);"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); string alertScript = "jAlert('Error', 'Campus2Caretaker');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true); } } }
public DataTable GetInstituteDetails(DTOInstituteDetails toins) { using (Campus2CaretakerDataContext dbcontext = new Campus2CaretakerDataContext()) { return (dbcontext.GetInstituteDetails(toins.InstituteID)).ToDataTable(); } }
private void LoadStudentsCountClasswise(string instituteId) { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(instituteId); DataTable branches = new BOPersonalizeApplication().GetClassesList(instituteId); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[4] { new DataColumn("colBranchName", typeof(string)), new DataColumn("colTotalCount", typeof(string)), new DataColumn("colMaleCount",typeof(string)) , new DataColumn("colFemaleCount",typeof(string)) }); for (int j = 0; j < branches.Rows.Count; j++) { List<DTOClasswiseCount> allCount = new BOReport().GetStudentCountClasswiseReport(toins, "All", int.Parse(branches.Rows[j][0].ToString())); List<DTOClasswiseCount> maleCount = new BOReport().GetStudentCountClasswiseReport(toins, "Male", int.Parse(branches.Rows[j][0].ToString())); List<DTOClasswiseCount> femaleCount = new BOReport().GetStudentCountClasswiseReport(toins, "Female", int.Parse(branches.Rows[j][0].ToString())); for (int i = 0; i < allCount.Count; i++) { string finalMaleCount = "0"; if (maleCount.Count > i) { finalMaleCount = maleCount[i].Count.ToString(); } string finalFemaleCount = "0"; if (femaleCount.Count > i) { finalFemaleCount = femaleCount[i].Count.ToString(); } dt.Rows.Add(allCount[i].ClassName, allCount[i].Count.ToString(), finalMaleCount, finalFemaleCount); } } for (int i = 1; i < dt.Columns.Count; i++) { Series series = new Series(); foreach (DataRow dr in dt.Rows) { int y = Convert.ToInt32(dr[i]); series.Points.AddXY(dr["colBranchName"].ToString(), y); } chrtStudentsStrengthvsClass.Series.Add(series); } gvClasswiseStrength.DataSource = dt; gvClasswiseStrength.DataBind(); }
private void LoadStudentsCount(string instituteId) { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(instituteId); int? allCount = new BOReport().GetStudentCountReport(toins, "All"); int? maleCount = new BOReport().GetStudentCountReport(toins, "Male"); int? femaleCount = new BOReport().GetStudentCountReport(toins, "Female"); double? allPercent = (double)((double)allCount / double.Parse(Session["MaxStudentsInstitute"].ToString())); dvAllCount.InnerText = String.Concat(String.Format("{0:0.00}", (allPercent * 100)).ToString(), "%"); dvAllCount.Attributes["data-percent"] = (allPercent * 100).ToString(); lblAllCount.InnerText = allCount.ToString(); lblAllCountText.InnerText = "Total Students"; double? malePercent = (double)((double)maleCount / (double)allCount); dvMaleCount.InnerText = String.Concat(String.Format("{0:0.00}", (malePercent * 100)).ToString(), "%"); dvMaleCount.Attributes["data-percent"] = (malePercent * 100).ToString(); lblMaleCount.InnerText = maleCount.ToString(); lblMaleCountText.InnerText = "Male"; double? femalePercent = (double)((double)femaleCount / (double)allCount); dvFemaleCount.InnerText = String.Concat(String.Format("{0:0.00}", (femalePercent * 100)).ToString(), "%"); dvFemaleCount.Attributes["data-percent"] = (femalePercent * 100).ToString(); lblFemaleCount.InnerText = femaleCount.ToString(); lblFemaleCountText.InnerText = "Female"; }
public int? GetStudentCountReport(DTOInstituteDetails toinst, string gender) { return new DAOReport().GetStudentCountReport(toinst, gender); }
public List<DTOClasswiseCount> GetStudentCountClasswiseReport(DTOInstituteDetails toinst, string gender, int branchid) { return new DAOReport().GetStudentCountClasswiseReport(toinst, gender, branchid); }