public Boolean Insert(AdminENT entAdmin)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Admin_Insert";
objCmd.Parameters.Add("@AdminID", SqlDbType.Int).Direction = ParameterDirection.Output;
objCmd.Parameters.Add("@AdminName", SqlDbType.VarChar).Value = entAdmin.AdminName;
objCmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = entAdmin.Address;
objCmd.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = entAdmin.Mobile;
objCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = entAdmin.Email;
objCmd.Parameters.Add("@AdminImage", SqlDbType.VarChar).Value = entAdmin.AdminImage;
objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = entAdmin.UserName;
objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = entAdmin.Password;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@AdminID"] != null)
{
entAdmin.AdminID = Convert.ToInt32(objCmd.Parameters["@AdminID"].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 Insert(AdminENT entAdmin)
{
AdminDAL dalAdmin = new AdminDAL();
if (dalAdmin.Insert(entAdmin))
{
return(true);
}
else
{
Message = dalAdmin.Message;
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region server side validation
String strErrorMessage = "";
if (txtAdminName.Text.Trim() == "")
{
strErrorMessage += "- Enter Admin Name <br/>";
}
if (txtAddress.Text.Trim() == "")
{
strErrorMessage += "- Enter Address <br/>";
}
if (txtEmail.Text.Trim() == "")
{
strErrorMessage += "- Enter Email <br/>";
}
if (txtMobile.Text.Trim() == "")
{
strErrorMessage += "- Enter Mobile <br/>";
}
if (Request.QueryString["AdminID"] == null)
{
if (txtUserName.Text.Trim() == "")
{
strErrorMessage += "- Enter UserName <br/>";
}
if (txtPassword.Text.Trim() == "")
{
strErrorMessage += "- Enter Password <br/>";
}
if (txtReTypePassword.Text.Trim() == "")
{
strErrorMessage += "- Re-type Password <br/>";
}
if (txtPassword.Text.Trim() != txtReTypePassword.Text.Trim())
{
strErrorMessage += "- Password & Re-type Password must be Same.<br/>";
}
}
if (strErrorMessage.Trim() != "")
{
lblErrorMessage.Text = strErrorMessage;
return;
}
else
{
lblErrorMessage.Text = "";
}
#endregion server side validation
#region Collect Form Data
AdminENT entAdmin = new AdminENT();
String strLogicalPath = "~/UploadedData/Images/Admin/";
String strPhysicalPath = "";
if (txtAdminName.Text.Trim() != "")
{
entAdmin.AdminName = txtAdminName.Text.Trim();
}
if (txtAddress.Text.Trim() != "")
{
entAdmin.Address = txtAddress.Text.Trim();
}
if (txtEmail.Text.Trim() != "")
{
entAdmin.Email = txtEmail.Text.Trim();
}
if (txtMobile.Text.Trim() != "")
{
entAdmin.Mobile = txtMobile.Text.Trim();
}
if (fuAdminImage.HasFile)
{
strPhysicalPath = Server.MapPath(strLogicalPath) + fuAdminImage.FileName;
if (File.Exists(strPhysicalPath))
{
File.Delete(strPhysicalPath);
}
fuAdminImage.SaveAs(strPhysicalPath);
entAdmin.AdminImage = strLogicalPath + fuAdminImage.FileName;
}
else
{
entAdmin.AdminImage = "~/UploadedData/Images/Admin/avatar.png";
}
if (txtUserName.Text.Trim() != "")
{
entAdmin.UserName = txtUserName.Text.Trim();
}
if (txtPassword.Text.Trim() != "")
{
entAdmin.Password = txtPassword.Text.Trim();
}
#endregion Collect Form Data
AdminBAL balAdmin = new AdminBAL();
if (Request.QueryString["AdminID"] == null)
{
if (balAdmin.Insert(entAdmin))
{
ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Admin Inserted Successfully', showConfirmButton: false, timer: 2000});", true);
ClearControls();
}
else
{
lblErrorMessage.Text = balAdmin.Message;
}
}
else
{
}
}
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");
}
}
public AdminENT SelectByUserNamePassword(SqlString UserName, SqlString Password)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Admin_SelectByUserNamePassword";
objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = UserName;
objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Password;
#endregion Prepare Command
#region ReadData and Set Controls
AdminENT entAdmin = new AdminENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
if (objSDR.HasRows == true)
{
while (objSDR.Read())
{
if (!objSDR["AdminID"].Equals(DBNull.Value))
{
entAdmin.AdminID = Convert.ToInt32(objSDR["AdminID"]);
}
if (!objSDR["AdminName"].Equals(DBNull.Value))
{
entAdmin.AdminName = Convert.ToString(objSDR["AdminName"]);
}
if (!objSDR["AdminImage"].Equals(DBNull.Value))
{
entAdmin.AdminImage = Convert.ToString(objSDR["AdminImage"]);
}
if (!objSDR["Address"].Equals(DBNull.Value))
{
entAdmin.Address = Convert.ToString(objSDR["Address"]);
}
if (!objSDR["Email"].Equals(DBNull.Value))
{
entAdmin.Email = Convert.ToString(objSDR["Email"]);
}
if (!objSDR["Mobile"].Equals(DBNull.Value))
{
entAdmin.Mobile = Convert.ToString(objSDR["Mobile"]);
}
if (!objSDR["UserName"].Equals(DBNull.Value))
{
entAdmin.UserName = Convert.ToString(objSDR["UserName"]);
}
}
}
}
return(entAdmin);
#endregion ReadData and Set Controls
}
catch (SqlException sqlEx)
{
Message = sqlEx.InnerException.Message;
return(null);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
