public bool Insert_Staff(System_DTO account, Staff_DTO staff)
{
string query = "exec USP_AddStaff @username , @password , @role , @displayname , @sex , @birthday , @address , @phone , @email , @image";
int x = (int)Connect.Instance.ExecuteOutPut(query, new object[] { account.Username, account.Password, account.Id_type, staff.Name, staff.Sex, staff.Birthday, staff.Address, staff.Phone, staff.Email, staff.Image });
return(x == 2);
}
public int InsertByTableName(string tablename, System_DTO entity)
{
sysRep.AddInputParameters("@tablename", tablename);
sysRep.AddInputParameters("@code", entity.code);
sysRep.AddInputParameters("@title", entity.title);
if (tablename == "tbl_Position")
{
sysRep.AddInputParameters("@status", entity.status);
}
return(sysRep.IUD("sp_Rows_InsertByTableName", CommandType.StoredProcedure));
}
public ActionResult SaveChanges(string tableName, System_DTO entity)
{
if (ModelState.IsValid)
{
sysServ.UpdateByTableName(tableName, entity);
return(Json(new { mesaj = "Redaktə edildi" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { mesaj = "Məlumatları düzgün doldurun!!!" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveRecord(string tableName, System_DTO entity)
{
if (ModelState.IsValid)
{
sysServ.InsertByTableName(tableName, entity);
return(Json(new { mesaj = "Əlavə olundu" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { mesaj = "Məlumatları düzgün doldurun!!!" }, JsonRequestBehavior.AllowGet));
}
}
public bool Insert_Staff(System_DTO account, Staff_DTO staff)
{
try
{
MD5 md5 = MD5.Create();
string password_md5 = Function_Other.Instance.GetMd5Hash(md5, account.Password);
account.Password = password_md5;
return(Staff_DAO.Instance.Insert_Staff(account, staff));
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception("Error!");
}
}
public bool Check_pass_old(string username, string pass_old)
{
try
{
System_DTO account = System_DAO.Instance.Get_Account(username);
MD5 md5 = MD5.Create();
string password_md5 = GetMd5Hash(md5, pass_old);
return(password_md5 == account.Password);
}
catch
{
throw new Exception("Error!");
}
}
public System_DTO Get_Account(string username)
{
string query = "exec USP_GetAccount @username";
DataTable account_info = Connect.Instance.ExecuteQuery(query, new object[] { username });
System_DTO account = null;
foreach (DataRow item in account_info.Rows)
{
account = new System_DTO(item);
}
return(account);
}
public List <System_DTO> Get_List_Staff_Service()
{
string query = "exec USP_GetList_Staff_Service";
DataTable list = Connect.Instance.ExecuteQuery(query);
List <System_DTO> list_staff = new List <System_DTO>();
foreach (DataRow item in list.Rows)
{
System_DTO account = new System_DTO(item);
list_staff.Add(account);
}
return(list_staff);
}
public System_DTO GetSingleRecord(string tablename, int id)
{
sysRep.AddInputParameters("@tablename", tablename);
sysRep.AddInputParameters("@id", id);
DataTable dt = sysRep.GetList("sp_SingleRow_GetByID", CommandType.StoredProcedure);
System_DTO singleRow = new System_DTO();
singleRow.id = Convert.ToInt32(dt.Rows[0]["id"]);
singleRow.title = dt.Rows[0]["title"].ToString();
singleRow.code = dt.Rows[0]["code"].ToString();
singleRow.table = tablename;
if (tablename == "tbl_Position")
{
singleRow.status = Convert.ToInt32(dt.Rows[0]["status"]);
}
return(singleRow);
}
private void btn_add_Click(object sender, EventArgs e)
{
bool flat = true;
if (txt_password.Text == "" || cb_role.SelectedIndex == -1 || txt_name.Text == "" || txt_phone.Text == "" || txt_address.Text == "" || txt_email.Text == "" || cb_sex.SelectedIndex == -1)
{
MessageBox.Show("Error!");
flat = false;
return;
}
try
{
var addr = new System.Net.Mail.MailAddress(txt_email.Text);
flat = true;
}
catch
{
MessageBox.Show("Email is not exists", "Error validate", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
flat = false;
return;
}
if (txt_phone.Text.Length != 11 && txt_phone.Text.Length != 10)
{
MessageBox.Show("Phone is not exist!", "Error validate", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
flat = false;
return;
}
System_DTO account = new System_DTO();
account.Username = txt_username.Text;
account.Password = txt_password.Text;
account.Id_type = cb_role.SelectedIndex;
Staff_DTO staff = new Staff_DTO();
staff.Username = txt_username.Text;
staff.Name = txt_name.Text;
if (cb_sex.SelectedIndex == 1)
{
staff.Sex = true;
}
else
{
staff.Sex = false;
}
staff.Birthday = dtp_birthday.Value;
staff.Address = txt_address.Text;
staff.Phone = txt_phone.Text;
staff.Email = txt_email.Text;
if (this.filename != null)
{
staff.Image = this.CovertImage();
}
else
{
MessageBox.Show("You must upload image!");
return;
}
if (Staff_BUS.Instance.Check_Email(txt_email.Text) == false)
{
if (Staff_BUS.Instance.Insert_Staff(account, staff))
{
MessageBox.Show("Add satff is success!");
this.Close();
}
else
{
MessageBox.Show("Error!");
}
}
else
{
MessageBox.Show("Email was exists in system!");
return;
}
}
private void fChange_pass_Load(object sender, EventArgs e)
{
txt_username.Text = this.Username;
txt_pass_old.Focus();
this.account = System_BUS.Instance.Get_Account(this.Username);
}
