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();
}
}
}
