public void bindFacultyInfo() { clsFaculty f = new clsFaculty(); DataSet ds = f.GetFacultyInfo(uname); dlInfo.DataSource = ds; dlInfo.DataBind(); }
public void bindInterest() { clsFaculty f = new clsFaculty(); DataSet ds = f.GetAreaOfInterestOfFacultyByUserName(uname); dl2.DataSource = ds; dl2.DataBind(); }
protected void DeleteButton_Click(object sender, EventArgs e) { try { clsFaculty aFaculty = new clsFaculty(); aFaculty.LoginBy = Session["USER_ID"].ToString(); aFaculty.ID = lblID.Text; aFacultyManager.DeleteFacultyInformation(aFaculty); RefreshAll(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ale", "alert('Record(s) delete suceessfullly...!!');", true); } catch (FormatException fex) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true); } catch (Exception ex) { if (ex.Message.Contains("Database")) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true); } } }
public void bindfacultygrid() { clsFaculty f = new clsFaculty(); DataSet ds = f.listFaculty(); gvFaculty.DataSource = ds; gvFaculty.DataBind(); }
protected void UpdateButton_Click(object sender, EventArgs e) { try { clsFaculty aFaculty = new clsFaculty(); txtFacultyId.Text = aFacultyManager.GetDepartmentAutoId(); aFaculty.FacultyId = txtFacultyId.Text.Trim(); aFaculty.FacultyName = txtFacultyName.Text.Trim(); aFaculty.CourseName = ddlCourseName.SelectedValue; aFaculty.Type = ddlFacultyType.SelectedValue; aFaculty.Status = ddlStatus.SelectedValue; aFaculty.Desognation = ddlDesignation.SelectedValue; aFaculty.LoginBy = Session["USER_ID"].ToString(); aFaculty.ID = lblID.Text; FacultyManager.UpdateFacultyInformation(aFaculty); RefreshAll(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ale", "alert('Record(s) update suceessfullly...!!');", true); } catch (FormatException fex) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true); } catch (Exception ex) { if (ex.Message.Contains("Database")) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true); } } }
public void bindStudent() { clsFaculty cs = new clsFaculty(); DataSet ds = cs.getStudentByFacultyUsername(uname); gv_StudentList.DataSource = ds; gv_StudentList.DataBind(); }
public void bindFacultyName() { clsFaculty f = new clsFaculty(); DataSet ds = f.GetFacultyName(uname); dlName.DataSource = ds; dlName.DataBind(); }
public void bindFacultyImage() { clsFaculty f = new clsFaculty(); DataSet ds = f.GetFacultyImageByUsername(uname); dl1.DataSource = ds; dl1.DataBind(); //dl1.DataBind(); }
public static void UpdateFacultyInformation(clsFaculty aFaculty) { string connectionString = DataManager.OraConnString(); string updateQuery = @"UPDATE [Faculty_Info] SET [FacultyId] = '" + aFaculty.FacultyId + "',[FacultyName] = '" + aFaculty.FacultyName + "',[CourseId]='" + aFaculty.CourseName + "',[Type]='" + aFaculty.Type + "',[Status]='" + aFaculty.Status + "',[DesignationID]='" + aFaculty.Desognation + "',[UpdateBy]='" + aFaculty.LoginBy + "',[UpdateDate]=GETDATE()) WHERE [ID]='" + aFaculty.ID + "'"; DataManager.ExecuteNonQuery(connectionString, updateQuery); }
public void DeleteFacultyInformation(clsFaculty Faculty) { string connectionString = DataManager.OraConnString(); string deleteQuery = @"Update [Faculty_Info] set [DeleteBy]='" + Faculty.LoginBy + "' ,[DeleteDate]=GETDATE() WHERE [ID]='" + Faculty.ID + "' "; DataManager.ExecuteNonQuery(connectionString, deleteQuery); }
public void bindLeaveInfo() { clsFaculty f=new clsFaculty(); int f_id = f.getFacultyIDbyEmail(Session["UserName"].ToString()); clsLeaveNotification ln = new clsLeaveNotification(); DataSet ds = ln.ListLeaveNotifications(f_id); gvLeaveNotification.DataSource = ds; gvLeaveNotification.DataBind(); }
public void bindFacultyDropDown() { clsFaculty cf = new clsFaculty(); DataSet ds = cf.listFaculty(); drpFaculty.DataSource = ds; drpFaculty.DataTextField = "Faculty_name"; drpFaculty.DataValueField = "Faculty_id"; drpFaculty.DataBind(); drpFaculty.Items.Insert(0, new ListItem("Select Faculty", "-1")); }
protected void btnsubmit_Click(object sender,EventArgs e) { MembershipCreateStatus status; Membership.CreateUser(txtFacultyemailid.Text, txtFacultypassword.Text, txtFacultyemailid.Text, "Que", "Ans", true, out status); if (status == MembershipCreateStatus.Success) { Roles.AddUserToRole(txtFacultyemailid.Text, "faculty"); clsFaculty f = new clsFaculty(); f.Faculty_name = txtFacultyname.Text; f.Faculty_email = txtFacultyemailid.Text; f.Faculty_password = txtFacultypassword.Text; f.Faculty_contactno = txtFacultycontactno.Text; f.Faculty_address = txtFacultyaddress.Text; f.Faculty_AreaOfInterest = txtFacultyAreaOfInterest.Text; f.Faculty_Experience = txtFacultyExperience.Text; f.Faculty_courseid = Convert.ToInt32(txtFacultycourseid.Text); f.Faculty_batchno = Convert.ToInt32(txtFacultybatchno.Text); if (fileupload.HasFile) { string filename = Path.GetFileName(fileupload.PostedFile.FileName); string path = "../images/" + filename; fileupload.SaveAs(Server.MapPath("~/images/") + filename); f.Faculty_Image= path; // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Alert", "alert('Image saved!')", true); } if (!string.IsNullOrEmpty(txtFacultyname.Text) && !string.IsNullOrEmpty(txtFacultyemailid.Text) && !string.IsNullOrEmpty(txtFacultypassword.Text) && !string.IsNullOrEmpty(txtFacultycontactno.Text) && !string.IsNullOrEmpty(txtFacultyaddress.Text) && !string.IsNullOrEmpty(txtFacultyAreaOfInterest.Text) && !string.IsNullOrEmpty(txtFacultyExperience.Text) && !string.IsNullOrEmpty(txtFacultycourseid.Text) && !string.IsNullOrEmpty(txtFacultybatchno.Text)) { try { f.addFaculty(f); string body = "Congratulations" + f.Faculty_name+ "You are successfully registered as Faculty. Welcome to Hare Krishna Diamond Institute"; mailing ms = new mailing(); ms.SendEmail(f.Faculty_email, "Faculty Confirmation", body); } catch (Exception ex) { Membership.DeleteUser(txtFacultyemailid.Text); } bindfacultygrid(); pnlData.Visible = true; pnlForm.Visible = false; txtFacultyname.Text = ""; txtFacultyemailid.Text = ""; txtFacultypassword.Text = ""; txtFacultycontactno.Text = ""; txtFacultyaddress.Text = ""; txtFacultyAreaOfInterest.Text = ""; txtFacultyExperience.Text = ""; txtFacultycourseid.Text = ""; txtFacultybatchno.Text = ""; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { uname = Session["UserName"].ToString(); clsFaculty f = new clsFaculty(); DataSet ds = f.GetFacultyName(uname); lblFacultyName.Text = ds.Tables[0].Rows[0]["Faculty_name"].ToString(); hfFacultyID.Value = ds.Tables[0].Rows[0]["Faculty_id"].ToString(); bindMaterial(); } }
public bool addFaculty(clsFaculty f) { SqlParameter[] sp = new SqlParameter[10]; sp[0] = new SqlParameter("@Faculty_name", f.Faculty_name); sp[1] = new SqlParameter("@Faculty_email", f.Faculty_email); sp[2] = new SqlParameter("@Faculty_password", f.Faculty_password); sp[3] = new SqlParameter("@Faculty_contact_no", f.Faculty_contactno); sp[4] = new SqlParameter("@Faculty_address", f.Faculty_address); sp[5] = new SqlParameter("@Faculty_AreaOfInterest", f.Faculty_AreaOfInterest); sp[6] = new SqlParameter("@Faculty_Experience", f.Faculty_Experience); sp[7] = new SqlParameter("@Faculty_Image", f.Faculty_Image); sp[8] = new SqlParameter("@Faculty_course_id", f.Faculty_courseid); sp[9] = new SqlParameter("@Faculty_batch_no", f.Faculty_batchno); return datalayer.Execute_NonQuery("sp_addFaculty", CommandType.StoredProcedure, sp); }
public static void SaveFacultyInformation(clsFaculty aFaculty) { string connectionString = DataManager.OraConnString(); string insertQuery = @"INSERT INTO [Faculty_Info] ([FacultyId] ,[FacultyName] ,[CourseId] ,[Type] ,[Status] ,[DesignationID] ,[EntryBy] ,[EntryDate])) VALUES('" + aFaculty.FacultyId + "','" + aFaculty.FacultyName + "','" + aFaculty.CourseName + "','" + aFaculty.Type + "','" + aFaculty.Status + "','" + aFaculty.Desognation + "','" + aFaculty.LoginBy + "',GETDATE())"; DataManager.ExecuteNonQuery(connectionString, insertQuery); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["UserName"] != null) { uname = Session["UserName"].ToString(); bindFacultyImage(); bindFacultyName(); bindInterest(); bindNews(); bindFacultyInfo(); clsFaculty f = new clsFaculty(); DataSet ds = f.GetFacultyName(uname); hfFacultyID.Value = ds.Tables[0].Rows[0]["Faculty_id"].ToString(); bindMaterial(); //hfFacultyID.Value = ds.Tables[0].Rows[0]["Faculty_id"].ToString(); } } }