protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
String strError = "";
if (txtDesignationName.Text.Trim() == "")
{
strError += "Enter Designation +</br>";
}
if (strError.Trim() != "")
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = strError;
return;
}
#endregion Server Side Validation
#region Collect Data
DesignationENT entDesignation = new DesignationENT();
if (txtDesignationName.Text.Trim() != "")
{
entDesignation.DesignationName = txtDesignationName.Text.Trim();
}
#endregion Collect Data
DesignationBAL balDesignation = new DesignationBAL();
if (Request.QueryString["DesignationID"] == null)
{
if (balDesignation.Insert(entDesignation))
{
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Succesfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balDesignation.Message;
}
}
else
{
entDesignation.DesignationID = Convert.ToInt32(Request.QueryString["DesignationID"].ToString().Trim());
if (balDesignation.Update(entDesignation))
{
Response.Redirect("~/Content/Designation/DesignationList.aspx");
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balDesignation.Message;
}
}
}
public DesignationENT SelectByPK(SqlInt32 DesignationID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Designation_SelectByPK";
objCmd.Parameters.Add("@DesignationID", SqlDbType.Int).Value = DesignationID;
#endregion Prepare Command
#region Read Data and Set Controls
DesignationENT entDesignation = new DesignationENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["DesignationID"].Equals(DBNull.Value))
{
entDesignation.DesignationID = Convert.ToInt32(objSDR["DesignationID"]);
}
if (!objSDR["DesignationName"].Equals(DBNull.Value))
{
entDesignation.DesignationName = Convert.ToString(objSDR["DesignationName"]);
}
}
}
return(entDesignation);
#endregion Read Data and Set Controls
}
catch (SqlException ex)
{
Message = ex.InnerException.Message;
return(null);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
private void fillControls(SqlInt32 DesignationID)
{
DesignationBAL balDesignation = new DesignationBAL();
DesignationENT entDesignation = new DesignationENT();
entDesignation = balDesignation.SelectByPK(DesignationID);
if (!entDesignation.DesignationName.IsNull)
{
txtDesignationName.Text = entDesignation.DesignationName.Value.ToString();
}
}
public Boolean Update(DesignationENT entDesignation)
{
DesignationDAL dalDesignation = new DesignationDAL();
if (dalDesignation.Update(entDesignation))
{
return(true);
}
else
{
Message = dalDesignation.Message;
return(false);
}
}
public Boolean Insert(DesignationENT entDesignation)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Designation_Insert";
objCmd.Parameters.Add("@DesignationID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
objCmd.Parameters.Add("@DesignationName", SqlDbType.VarChar).Value = entDesignation.DesignationName;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@DesignationID"] != null)
{
entDesignation.DesignationID = Convert.ToInt32(objCmd.Parameters["@DesignationID"].Value);
}
return(true);
}
catch (SqlException ex)
{
Message = ex.Message;
return(false);
}
catch (Exception ex)
{
Message = ex.Message;
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(DesignationENT entDesignation)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Designation_UpdateByPK";
objCmd.Parameters.Add("@DesignationID", SqlDbType.Int).Value = entDesignation.DesignationID;
objCmd.Parameters.Add("@DesignationName", SqlDbType.VarChar).Value = entDesignation.DesignationName;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Message = ex.InnerException.Message;
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Collect Data
UserENT entUser = new UserENT();
LeaveTypeENT entLeaveType = new LeaveTypeENT();
DesignationENT entDesignation = new DesignationENT();
if (ddlDepartment.SelectedIndex > 0)
{
entUser.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);
}
if (ddlInstitute.SelectedIndex > 0)
{
entUser.InstituteID = Convert.ToInt32(ddlInstitute.SelectedValue);
}
if (ddlDesignation.SelectedIndex > 0)
{
entUser.DesignationID = Convert.ToInt32(ddlDesignation.SelectedValue);
entDesignation.DesignationID = Convert.ToInt32(ddlDesignation.SelectedValue);
}
if (rbFemale.Checked != false)
{
entUser.Gender = rbFemale.Text.Trim();
}
if (rbMale.Checked != false)
{
entUser.Gender = rbMale.Text.Trim();
}
if (txtUsername.Text.Trim() != "")
{
entUser.UserName = txtUsername.Text.Trim();
}
if (txtPassword.Text.Trim() != "")
{
entUser.Password = txtPassword.Text.Trim();
}
if (txtDisplayName.Text.Trim() != "")
{
entUser.DisplayName = txtDisplayName.Text.Trim();
}
if (txtMobileNo.Text.Trim() != "")
{
entUser.MobileNo = txtMobileNo.Text.Trim();
}
if (txtDOB.Text.Trim() != "")
{
entUser.DOB = txtDOB.Text.Trim();
}
if (txtEmail.Text.Trim() != "")
{
entUser.Email = txtEmail.Text.Trim();
}
if (txtExperience.Text.Trim() != "")
{
entUser.Experience = txtExperience.Text.Trim();
}
if (txtQualification.Text.Trim() != "")
{
entUser.Qualification = txtQualification.Text.Trim();
}
if (txtCity.Text.Trim() != "")
{
entUser.City = txtCity.Text.Trim();
}
if (fuStaffPhoto.HasFile)
{
string strFileLocationSave = "~/Content/assets/images/";
string strPhysicalPath = "";
strPhysicalPath = Server.MapPath(strFileLocationSave);
strPhysicalPath += fuStaffPhoto.FileName;
strFileLocationSave += fuStaffPhoto.FileName;
if (File.Exists(strPhysicalPath))
{
File.Delete(strPhysicalPath);
}
fuStaffPhoto.SaveAs(strPhysicalPath);
entUser.PhotoPath = strFileLocationSave;
}
#endregion Collect Data
UserBAL balUser = new UserBAL();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
DesignationBAL balDesignation = new DesignationBAL();
entDesignation = balDesignation.SelectByPK(entDesignation.DesignationID);
if (Session["UserID"] == null)
{
if (entDesignation.DesignationName == "HOD")
{
balUser.Insert(entUser);
entUser = balUser.SelectByPK(entUser.UserID);
clearSelection();
lblSuccess.Text = "Data Inserted Successfully";
}
else if (entDesignation.DesignationName != "HOD")
{
balUser.Insert(entUser);
if (entUser.UserID > 0)
{
entLeaveType.UserID = entUser.UserID;
entUser = balUser.SelectByPK(entUser.UserID);
}
else
{
lblErrorMessage.Text = "empty";
return;
}
entLeaveType.LeaveType = "Casual Leave";
entLeaveType.TotalDays = 25;
balLeaveType.Insert(entLeaveType);
entLeaveType.LeaveType = "Medical Leave";
entLeaveType.TotalDays = 15;
balLeaveType.Insert(entLeaveType);
entLeaveType.LeaveType = "LOP";
entLeaveType.TotalDays = 10;
balLeaveType.Insert(entLeaveType);
entLeaveType.LeaveType = "Other Leave";
entLeaveType.TotalDays = 5;
balLeaveType.Insert(entLeaveType);
clearSelection();
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
lblErrorMessage.Text = balUser.Message;
}
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(entUser.Email.ToString());
mail.Subject = "User Created Successfully !!";
mail.Body = "<h3>You can now login into Leave management system</h3><br>" +
"Your Username Is :- " + Convert.ToString(entUser.UserName) +
"<br>Your Password Is :- " + Convert.ToString(entUser.Password) +
"<br><br><i>Please don't reply, this is auto generated email</i>";
mail.IsBodyHtml = true;
using (SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587))
{
smtp.Credentials = new NetworkCredential("*****@*****.**", "password");
smtp.EnableSsl = true;
smtp.Send(mail);
}
}
}
else
{
entUser.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (balUser.Update(entUser))
{
if (Session["Select"].ToString() == "Employee")
{
Response.Redirect("~/Content/Home/Employee_Home.aspx");
}
else if (Session["Select"].ToString() == "HOD")
{
Response.Redirect("~/Content/Home/HOD_Home.aspx");
}
}
else
{
lblErrorMessage.Text = balUser.Message;
}
}
}
