protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
String strError = "";
if (txtDepartmentName.Text.Trim() == "")
{
strError += "Enter Department +</br>";
}
if (strError.Trim() != "")
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = strError;
return;
}
#endregion Server Side Validation
#region Collect Data
DepartmentENT entDepartment = new DepartmentENT();
if (txtDepartmentName.Text.Trim() != "")
{
entDepartment.DepartmentName = txtDepartmentName.Text.Trim();
}
#endregion Collect Data
DepartmentBAL balDepartment = new DepartmentBAL();
if (Request.QueryString["DepartmentID"] == null)
{
if (balDepartment.Insert(entDepartment))
{
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balDepartment.Message;
}
}
else
{
entDepartment.DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"].ToString().Trim());
if (balDepartment.Update(entDepartment))
{
Response.Redirect("~/Content/Department/DepartmentList.aspx");
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balDepartment.Message;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region server side validation
String strErrorMessage = "";
if (txtDepartment.Text.Trim() == "")
{
strErrorMessage += "- Enter Department <br/>";
}
if (strErrorMessage.Trim() != "")
{
lblErrorMessage.Text = strErrorMessage;
return;
}
#endregion server side validation
#region Collect Form Data
DepartmentENT entDepartment = new DepartmentENT();
if (txtDepartment.Text.Trim() != "")
{
entDepartment.DepartmentName = txtDepartment.Text.Trim();
}
#endregion Collect Form Data
DepartmentBAL balDepartment = new DepartmentBAL();
if (Convert.ToBoolean(ViewState["DepartmentEditActive"]) == false)
{
if (balDepartment.Insert(entDepartment))
{
fillDepartmentGridview();
ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Department Inserted Successfully', showConfirmButton: false, timer: 2000});", true);
ClearControls();
}
else
{
lblErrorMessage.Text = balDepartment.Message;
}
}
else
{
entDepartment.DepartmentID = Convert.ToInt32(ViewState["DepartmentID"]);
if (balDepartment.Update(entDepartment))
{
fillDepartmentGridview();
ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Department Edited Successfully', showConfirmButton: false, timer: 2000});", true);
ClearControls();
ViewState["DepartmentEditActive"] = false;
lblModalTitle.Text = "Department Add";
}
else
{
lblErrorMessage.Text = balDepartment.Message;
}
}
}
public DepartmentENT SelectByPK(SqlInt32 DepartmentID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Department_SelectByPK";
objCmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = DepartmentID;
#endregion Prepare Command
#region Read Data and Set Controls
DepartmentENT entDepartment = new DepartmentENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["DepartmentID"].Equals(DBNull.Value))
{
entDepartment.DepartmentID = Convert.ToInt32(objSDR["DepartmentID"]);
}
if (!objSDR["DepartmentName"].Equals(DBNull.Value))
{
entDepartment.DepartmentName = Convert.ToString(objSDR["DepartmentName"]);
}
}
}
return(entDepartment);
#endregion Read Data and Set Controls
}
catch (SqlException ex)
{
Message = ex.Message;
return(null);
}
catch (Exception ex)
{
Message = ex.Message;
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
private void FillControls(SqlInt32 DepartmentID)
{
DepartmentBAL balDepartment = new DepartmentBAL();
DepartmentENT entDepartment = new DepartmentENT();
entDepartment = balDepartment.SelectByPK(DepartmentID);
if (!entDepartment.DepartmentName.IsNull)
{
txtDepartment.Text = entDepartment.DepartmentName.Value.ToString();
}
}
public Boolean Update(DepartmentENT entDepartment)
{
DepartmentDAL dalDepartment = new DepartmentDAL();
if (dalDepartment.Update(entDepartment))
{
return(true);
}
else
{
Message = dalDepartment.Message;
return(false);
}
}
public Boolean Insert(DepartmentENT entDepartment)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Department_Insert";
objCmd.Parameters.Add("@DepartmentID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
objCmd.Parameters.Add("@DepartmentName", SqlDbType.VarChar).Value = entDepartment.DepartmentName;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@DepartmentID"] != null)
{
entDepartment.DepartmentID = Convert.ToInt32(objCmd.Parameters["@DepartmentID"].Value);
}
return(true);
}
catch (SqlException sqlEx)
{
Message = sqlEx.InnerException.Message;
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(DepartmentENT entDepartment)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Department_UpdateByPK";
objCmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = entDepartment.DepartmentID;
objCmd.Parameters.Add("@DepartmentName", SqlDbType.VarChar).Value = entDepartment.DepartmentName;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
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();
}
}
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
#region Server Side Validation
String strErrorMessage = "";
if (txtUserName.Text.Trim() == "")
{
strErrorMessage += "- Enter Username <br/>";
}
if (txtPassword.Text.Trim() == "")
{
strErrorMessage += "- Enter Password <br/>";
}
if (strErrorMessage != "")
{
lblErrorMessage.Text = strErrorMessage;
return;
}
else
{
lblErrorMessage.Text = "";
}
#endregion Server Side Validation
#region Read Data
SqlString UserName = SqlString.Null;
SqlString Password = SqlString.Null;
if (txtUserName.Text != "")
{
UserName = txtUserName.Text.ToString().Trim();
}
if (txtPassword.Text != "")
{
Password = txtPassword.Text.ToString().Trim();
}
#endregion Read Data
if (Request.QueryString["user"] == "admin" || Convert.ToBoolean(Application["CheckAdmin"]) == true)
{
AdminBAL balAdmin = new AdminBAL();
AdminENT entAdmin = new AdminENT();
entAdmin = balAdmin.SelectByUserNamePassword(UserName, Password);
if (!entAdmin.AdminID.IsNull)
{
if (!entAdmin.AdminID.IsNull)
{
Session["UserID"] = Convert.ToString(entAdmin.AdminID.Value);
}
if (!entAdmin.UserName.IsNull)
{
Session["UserName"] = Convert.ToString(entAdmin.UserName.Value);
}
if (!entAdmin.AdminImage.IsNull)
{
Session["UserImage"] = Convert.ToString(entAdmin.AdminImage.Value);
}
string ReturnUrl = Convert.ToString(Request.QueryString["url"]);
if (!string.IsNullOrEmpty(ReturnUrl))
{
Response.Redirect(ReturnUrl);
}
else
{
Response.Redirect("~/AdminPanel/Dashboard.aspx");
}
}
else
{
lblErrorMessage.Text = "Eithe Username or password is Invalid, Try again...!";
}
}
else if (Request.QueryString["user"] == "doctor" || Convert.ToBoolean(Application["CheckDoctor"]) == true)
{
DoctorBAL balDoctor = new DoctorBAL();
DoctorENT entDoctor = new DoctorENT();
entDoctor = balDoctor.SelectByUserNamePassword(UserName, Password);
if (!entDoctor.DoctorID.IsNull)
{
if (!entDoctor.DoctorID.IsNull)
{
Session["UserID"] = Convert.ToString(entDoctor.DoctorID.Value);
}
if (!entDoctor.DoctorName.IsNull)
{
Session["UserName"] = Convert.ToString(entDoctor.DoctorName.Value);
}
if (!entDoctor.DoctorImage.IsNull)
{
Session["UserImage"] = Convert.ToString(entDoctor.DoctorImage.Value);
}
if (!entDoctor.DepartmentID.IsNull)
{
DepartmentENT entDepartment = new DepartmentENT();
DepartmentBAL balDepartment = new DepartmentBAL();
entDepartment = balDepartment.SelectByPK(Convert.ToInt32(entDoctor.DepartmentID.Value));
Session["DepartmentName"] = entDepartment.DepartmentName.Value;
}
string ReturnUrl = Convert.ToString(Request.QueryString["url"]);
if (!string.IsNullOrEmpty(ReturnUrl))
{
Response.Redirect(ReturnUrl);
}
else
{
Response.Redirect("~/AdminPanel/Dashboard.aspx");
}
}
else
{
lblErrorMessage.Text = "Eithe Username or password is Invalid, Try again...!";
}
}
else
{
Response.Redirect("~/AdminPanel/Authentication/CheckUser.aspx");
}
}
