public void EditEmp(emp_detail emp)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"UPDATE `emp_profile`
SET
`FirstName` = @first_Name,
`LastName` = @last_Name,
`Email` = @email,
`contact` = @contact,
`contact1` = @contact1,
`contact2` = @contact2,
`address` = @address,
`address1` = @address1,
`address2` = @address2,
`district` = @district,
`state` = @state,
`country` = @country,
`pincode` = @pincode,
`FatherName` = @FatherName,
`MotherName` = @MotherName,
`dob` = @dob,
`sex` = @sex,
`education` = @education,
`doj` = @doj,
`epf_no` = @epf_no,
`aadhaar_no` = @aadhaar_no,
`pan_no` = @pan_no,
`bank_name` = @bank_name,
`acc_no` = @acc_no,
`ifsc_code` = @ifsc_no,
`bank_branch` = @bank_branch,
`designation` = @designation,
`bioMatricNo` = @bioMatricNo,
`emp_active` = @emp_active
WHERE `user_id` = @user_id";
con.Execute(query, emp);
if (!emp.emp_active)
{
query = @"DELETE FROM `enable_features`
WHERE
user_id = @user_id;";
con.Execute(query, emp);
query = @"DELETE FROM `enable_wedget`
WHERE
user_id = @user_id;";
con.Execute(query, emp);
query = @"DELETE FROM `mst_attendance`
WHERE
user_id = @user_id;";
con.Execute(query, emp);
query = @"DELETE FROM `hariti`.`users`
WHERE
user_id = @user_id;";
con.Execute(query, emp);
}
}
}
public void AddEmployee(emp_detail emp)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string maxid = "select ifnull(MAX(user_id),0)+1 from emp_profile";
int id = con.ExecuteScalar <int>(maxid);
string query = @"INSERT INTO `emp_profile`
(`user_id`,
`FirstName`,
`LastName`,
`Email`,
`contact`,
`contact1`,
`contact2`,
`address`,
`address1`,
`address2`,
`district`,
`state`,
`country`,
`pincode`,
`FatherName`,
`MotherName`,
`dob`,
`sex`,
`education`,
`doj`,
`epf_no`,
`aadhaar_no`,
`pan_no`,
`bank_name`,
`acc_no`,
`ifsc_code`,
`bank_branch`,
`designation`,
`bioMatricNo`,
emp_active)
VALUES
(@user_id,
@First_Name,
@Last_Name ,
@email,
@contact,
@contact1,
@contact2,
@address,
@address1,
@address2,
@district,
@state,
@country,
@pincode,
@FatherName,
@MotherName,
@dob,
@sex,
@education,
@doj,
@epf_no,
@aadhaar_no,
@pan_no,
@bank_name,
@acc_no,
@ifsc_no,
@bank_branch,
@designation,
@bioMatricNo,
1)";
emp.user_id = id;
con.Execute(query,
new
{
emp.user_id,
emp.first_name,
emp.last_name,
emp.email,
emp.contact,
emp.contact1,
emp.contact2,
emp.address,
emp.address1,
emp.address2,
emp.district,
emp.state,
emp.country,
emp.pincode,
emp.FatherName,
emp.MotherName,
emp.dob,
emp.sex,
emp.education,
emp.doj,
emp.epf_no,
emp.aadhaar_no,
emp.pan_no,
emp.bank_name,
emp.acc_no,
emp.ifsc_no,
emp.bank_branch,
emp.designation,
emp.bioMatricNo
});
}
}
catch (Exception ex)
{
throw ex;
}
}
