public ActionResult Addemployee()
{
Cms_Employee cms_getdepart = new Cms_Employee();
cms_getdepart.Departmentname = DepartmentList();
return(View(cms_getdepart));
}
public string Checkemployee_req(Cms_Employee cms_emp)
{
string empemail, empphoneno, empaadharno;
empaadharno = cms_emp.Employee_Addharno;
empemail = cms_emp.Employee_Email;
empphoneno = cms_emp.Employee_Phone;
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Select * from Cms_Employee Where Employee_Addharno=@empaadharno and Employee_Email=@empemail and Employee_Phone=@empphoneno";
cmd.Parameters.AddWithValue("@empaadharno", empaadharno);
cmd.Parameters.AddWithValue("@empemail", empemail);
cmd.Parameters.AddWithValue("@empphoneno", empphoneno);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count != 0)
{
return("Aadharno,email and phoneno already exists");
}
return("User succcess");
}
public bool AddEmployee(Cms_Employee cms_employee)
{
string emp_aadharno, emp_username, emp_gender, emp_email, emp_phone, emp_type, emp_depid, emp_password, emp_dob, emp_regdate;
try
{
con.Open();
SqlTransaction trans = con.BeginTransaction();
try
{
emp_aadharno = cms_employee.Employee_Addharno;
emp_username = cms_employee.Employee_Name;
emp_gender = cms_employee.Employee_Gender;
emp_email = cms_employee.Employee_Email;
emp_dob = cms_employee.Employee_Dob.ToString();
emp_phone = cms_employee.Employee_Phone;
emp_depid = Convert.ToString(cms_employee.Employee_Departmentid);
emp_type = cms_employee.Employee_type;
emp_password = cms_employee.Employee_Password;
emp_regdate = cms_employee.Employee_Registerdatetime.ToString();
SqlCommand dbcmd = con.CreateCommand();
dbcmd.Transaction = trans;
dbcmd.CommandText = "insert into Cms_Employee(Employee_Addharno,Employee_Name,Employee_Gender,Employee_Email,Employee_Dob,Employee_Phone,Employee_Departmentid,Employee_type,Employee_Password,Employee_Registerdatetime) Values(@empaadharno,@empname,@empgender,@empemail,@empdob,@empphone,@empdepid,@emptype,@emppassword,@empregdate)";
dbcmd.Parameters.AddWithValue("@empaadharno", emp_aadharno);
dbcmd.Parameters.AddWithValue("@empname", emp_username);
dbcmd.Parameters.AddWithValue("@empgender", emp_gender);
dbcmd.Parameters.AddWithValue("@empemail", emp_email);
dbcmd.Parameters.AddWithValue("@empdob", emp_dob);
dbcmd.Parameters.AddWithValue("@empphone", emp_phone);
dbcmd.Parameters.AddWithValue("@empdepid", emp_depid);
dbcmd.Parameters.AddWithValue("@emptype", emp_type);
dbcmd.Parameters.AddWithValue("@emppassword", emp_password);
dbcmd.Parameters.AddWithValue("@empregdate", emp_regdate);
dbcmd.ExecuteNonQuery();
trans.Commit();
con.Close();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
con.Close();
return(false);
}
}
catch
{
return(false);
}
}
public ActionResult Addemployee(Cms_Employee cms_employee)
{
if (ModelState.IsValid)
{
cms_employee.Employee_Registerdatetime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
string a = qh.Checkemployee_req(cms_employee);
if (a == "Aadharno,email and phoneno already exists")
{
ViewBag.message = "Aadharno,email and phoneno is already exists";
}
else
{
try
{
cms_employee.Departmentname = DepartmentList();
var selectedItem = cms_employee.Departmentname.Find(p => p.Value == cms_employee.Employee_Departmentid.ToString());
if (selectedItem != null)
{
selectedItem.Selected = true;
qh.AddEmployee(cms_employee);
}
MailMessage mail = new MailMessage();
mail.To.Add(cms_employee.Employee_Email);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Account creation";
string Body = "Hello <b>" + cms_employee.Employee_Name + "<b><br/><br/>";
Body += "Your Employeement account is successfully Activate by the Administrator";
Body += "<br/>Your UserName and Password here:-<br/><br/>";
Body += "<br/>UserName= <b>" + cms_employee.Employee_Email + "<b><br/><br/>";
Body += "<br/>Password = <b>" + cms_employee.Employee_Password + "<b><br/><br/>";
Body += "<br/>This Autogenerated email please do not reply";
Body += "<br/>Call monitaring System ";
Body += "<br/>Thanks ";
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "7976862730@umang"); // Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
ViewBag.Success = "Successfully Added!! ";
ModelState.Clear();
}
catch (Exception ex)
{
ViewBag.Error = "Error Occured:" + ex.Message.ToString();
}
}
}
else
{
ViewBag.Error = "Something went wrong";
}
ViewBag.Success = "Successfully register for Cms system!! ";
return(View(cms_employee));
}
