private void GetDepartment()
{
string depID;
string depName;
ListItem li;
DataSet ds = new DataSet();
class_is.ClassLeaveSystem objLeaveSystem = new class_is.ClassLeaveSystem();
li = new ListItem("Please Select...", "*");
ddlDep.Items.Add(li);
ds = objLeaveSystem.getDepartment();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
depID = ds.Tables[0].Rows[i]["DEPARTMENT_ID"].ToString();
depName = ds.Tables[0].Rows[i]["DEPARTMENT_NAME"].ToString();
li = new ListItem(depName, depID);
ddlDep.Items.Add(li);
}
}
private void GetUserRole()
{
DataSet ds = new DataSet();
class_is.ClassLeaveSystem objLeave = new class_is.ClassLeaveSystem();
int i;
int count;
string RoleID, RoleName;
ListItem li;
ds = objLeave.getUserRole();
count = ds.Tables[0].Rows.Count;
for (i = 0; i <= count - 1; i++)
{
RoleID = ds.Tables[0].Rows[i]["ROLE_ID"].ToString();
RoleName = ds.Tables[0].Rows[i]["ROLE_NAME"].ToString();
li = new ListItem(RoleName, RoleID);
ddlRole.Items.Add(li);
}
}
private void GetUserGroup()
{
DataSet ds = new DataSet();
class_is.ClassLeaveSystem objLeave = new class_is.ClassLeaveSystem();
int i;
int count;
string GroupID, GroupName;
ListItem li;
li = new ListItem("Please Select...", "*");
ddlGroup.Items.Add(li);
ds = objLeave.getUserGroup();
count = ds.Tables[0].Rows.Count;
for (i = 0; i <= count - 1; i++)
{
GroupID = ds.Tables[0].Rows[i]["GroupID"].ToString();
GroupName = ds.Tables[0].Rows[i]["GroupName"].ToString();
li = new ListItem(GroupName, GroupID);
ddlGroup.Items.Add(li);
}
}
private void GetDataUser()
{
string userName = Request.QueryString["userName"];
DataSet ds = new DataSet();
class_is.ClassLeaveSystem objLeave = new class_is.ClassLeaveSystem();
ds = objLeave.getUserData(userName);
if (ds.Tables[0].Rows.Count > 0)
{
txtUserName.Enabled = false;
//txtPassword.Enabled = false;
txtUserName.Text = ds.Tables[0].Rows[0]["USER_NAME"].ToString();
//txtPassword.Text = "Password";
txtLine.Text = ds.Tables[0].Rows[0]["LINE_ID"].ToString();
txtFName.Text = ds.Tables[0].Rows[0]["FIRST_NAME"].ToString();
txtLName.Text = ds.Tables[0].Rows[0]["LAST_NAME"].ToString();
txtEmpID.Text = ds.Tables[0].Rows[0]["EMP_CODE"].ToString();
txtEmail.Text = ds.Tables[0].Rows[0]["EMAIL"].ToString();
ddlRole.SelectedValue = ds.Tables[0].Rows[0]["ROLE_ID"].ToString();
ddlGroup.SelectedValue = ds.Tables[0].Rows[0]["USER_GROUP"].ToString();
ddlDep.SelectedValue = ds.Tables[0].Rows[0]["DeptID"].ToString();
}
}
private Boolean SaveData()
{
string sql;
class_is.dbconfig db = new class_is.dbconfig();
class_is.ClassLeaveSystem objLeave = new class_is.ClassLeaveSystem();
if (Mode == "Edit")
{
sql = "UPDATE [USER] SET ";
sql += "USER_GROUP = '" + ddlGroup.SelectedValue + "',";
sql += "ROLE_ID = '" + ddlRole.SelectedValue + "',";
sql += "LINE_ID = '" + txtLine.Text + "',";
sql += "FIRST_NAME = '" + txtFName.Text + "',";
sql += "LAST_NAME = '" + txtLName.Text + "',";
sql += "EMP_CODE = '" + txtEmpID.Text + "',";
sql += "DeptID = '" + ddlDep.SelectedValue + "',";
sql += "EMAIL = '" + txtEmail.Text + "'";
sql += "where USER_NAME = '" + userName + "'";
if (db.ExecuteSQL(sql))
{
return(true);
}
else
{
return(false);
}
}
else
{
if (UserNameExist())
{
Response.Write("<script> alert('User Name is Exist') </script>");
return(false);
}
else if (empCodeExist())
{
Response.Write("<script> alert('Emp Code is Exist') </script>");
return(false);
}
else
{
sql = "INSERT INTO [USER] ";
sql += "(USER_NAME,PASSWORD,USER_GROUP,ROLE_ID,LINE_ID,FIRST_NAME,LAST_NAME,EMP_CODE,DeptID,EMAIL) ";
sql += "VALUES ( ";
sql += "'" + txtUserName.Text + "',";
sql += "'" + objLeave.ComputeHash(txtPassword.Text, "SHA512", null) + "',";
sql += "'" + ddlGroup.SelectedValue + "',";
sql += "'" + ddlRole.SelectedValue + "',";
sql += "'" + txtLine.Text + "',";
sql += "'" + txtFName.Text + "',";
sql += "'" + txtLName.Text + "',";
sql += "'" + txtEmpID.Text + "',";
sql += "'" + ddlDep.SelectedValue + "',";
sql += "'" + txtEmail.Text + "'";
sql += ")";
if (db.ExecuteSQL(sql))
{
return(true);
}
else
{
return(false);
}
}
}
}
