protected void BtnOk_Click(object sender, EventArgs e)
{
busEmployees busemp = new busEmployees();
Employees frmEmp = new Employees();
frmEmp.FullName = this.txtFullname.Text;
frmEmp.Email = this.txtEmail.Text;
frmEmp.Login = this.txtLogin.Text;
frmEmp.LastName = this.txtLastName.Text;
frmEmp.passwords = this.txtPassword.Text;
frmEmp.IDAccess = int.Parse(this.ddpAccess.SelectedValue);
isExisting = isUserExisting();
if (isExisting.Equals(true))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('User existing')", true);
}
else
{
string x = busemp.insertEmployee(frmEmp);
if (x.Trim() == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully added new User')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Failed to added new User')", true);
}
}
//DataTable dt = new DataTable("User");
//dt = busemp.allUser();
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
public Employees isUserExisting(string userid)
{
DataTable dt = new DataTable("Customer");
dt.Clear();
string query = "SELECT * FROM Employees where Login='******'";
dt = DataAccess.DBAdapter.GetRecordSet(query);
Employees log = null;
if (dt.Rows.Count > 0)
{
log = new Employees(dt.Rows[0]);
}
return log;
}
public FrameWork.Employees[] Retrieve()
{
string query = "SELECT [ID] ,[Email],[FullName],[LastName],[Login] FROM [inventory].[dbo].[Employees]";
DataTable table = new DataTable();
table = DataAccess.DBAdapter.GetRecordSet(query);
FrameWork.Employees[] dec = new FrameWork.Employees[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
dec[i] = new FrameWork.Employees(table.Rows[i]);
}
return dec;
}
public FrameWork.Employees Retrieve1(string user, string pass)
{
string query = "SELECT [ID] ,[Email],[FullName],[Login] FROM [inventory].[dbo].[Employees] where login = '******' and passwords ='" + pass + "'";
DataTable table = new DataTable();
table = DataAccess.DBAdapter.GetRecordSet(query);
FrameWork.Employees dec = null;
if (table.Rows.Count > 0)
{
dec = new FrameWork.Employees(table.Rows[0]);
}
return(dec);
}
public FrameWork.Employees[] Retrieve()
{
string query = "SELECT [ID] ,[Email],[FullName],[LastName],[Login] FROM [inventory].[dbo].[Employees]";
DataTable table = new DataTable();
table = DataAccess.DBAdapter.GetRecordSet(query);
FrameWork.Employees[] dec = new FrameWork.Employees[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
dec[i] = new FrameWork.Employees(table.Rows[i]);
}
return(dec);
}
public string insertEmployee(Employees emp)
{
string Message = string.Empty;
int result = 0;
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [Employees]([Email] ,[FullName] ,[Login],passwords,LastName) VALUES (@Email,@FullName,@Login,@passwords,@LastName)", con);
cmd.Parameters.AddWithValue("@Email", emp.Email);
cmd.Parameters.AddWithValue("@FullName", emp.FullName);
cmd.Parameters.AddWithValue("@Login", emp.Login);
cmd.Parameters.AddWithValue("@passwords", emp.passwords);
cmd.Parameters.AddWithValue("@LastName", emp.LastName);
result = cmd.ExecuteNonQuery();
con.Close();
return Message;
}
private bool isUserExisting()
{
string userid = this.txtLogin.Text;
busEmployees busemp = new busEmployees();
FrameWork.Employees log = busemp.isUserExisting(userid);
if (log == null)
{
return(false);
}
else if (userid.Equals(log.Login))
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
busEmployees busemp = new busEmployees();
Employees frmEmp = new Employees();
frmEmp.FullName = this.txtFullname.Text;
frmEmp.Email = this.txtEmail.Text;
frmEmp.Login = this.txtLogin.Text;
frmEmp.LastName = this.txtLastName.Text;
frmEmp.passwords = this.txtPassword.Text;
isExisting = isUserExisting();
if (isExisting.Equals(true))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('User existing')", true);
}
else
{
busemp.insertEmployee(frmEmp);
}
DataTable dt = new DataTable("User");
dt = busemp.allUser();
GridView1.DataSource = dt;
GridView1.DataBind();
}
public FrameWork.Employees Retrieve1(string user, string pass)
{
string query = "SELECT [ID] ,[Email],[FullName],[Login] FROM [inventory].[dbo].[Employees] where login = '******' and passwords ='"+ pass +"'";
DataTable table = new DataTable();
table = DataAccess.DBAdapter.GetRecordSet(query);
FrameWork.Employees dec =null;
if (table.Rows.Count > 0)
{
dec = new FrameWork.Employees(table.Rows[0]);
}
return dec;
}
