protected void gvDepartment_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRecord")
{
if (e.CommandArgument != null)
{
ViewState["DepartmentEditActive"] = true;
ViewState["DepartmentID"] = Convert.ToInt32(e.CommandArgument.ToString());
lblModalTitle.Text = "Department Edit";
FillControls(Convert.ToInt32(e.CommandArgument.ToString()));
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "departmentAddEditModal();", true);
}
}
if (e.CommandName == "DeleteRecord")
{
if (e.CommandArgument != null)
{
DepartmentBAL balDepartment = new DepartmentBAL();
if (balDepartment.Delete(Convert.ToInt32(e.CommandArgument.ToString())))
{
fillDepartmentGridview();
ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Department Deleted Successfully', showConfirmButton: false, timer: 2000});", true);
}
else
{
lblErrorMessage.Text = balDepartment.Message;
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (selectedRecordId != 0)
{
try
{
Cursor = Cursors.WaitCursor;
DepartmentBAL _objBAL = new DepartmentBAL();
_objBAL.DeleteUser(selectedRecordId);
MessageBox.Show("Record has been deleted successfully!");
FillGrid();
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number == 547)
{
MessageBox.Show("You cannot delete this record. Its refference exists in other documents.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
Cursor = Cursors.Default;
MakeEmpty();
}
}
}
protected void gvDepartment_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord")
{
if (e.CommandArgument != null)
{
DepartmentBAL balDepartment = new DepartmentBAL();
if (balDepartment.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim())))
{
FillGridViewDepartment();
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balDepartment.Message;
}
}
}
else if (e.CommandName == "EditRecord")
{
if (e.CommandArgument != null)
{
Response.Redirect(e.CommandArgument.ToString().Trim());
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
try
{
if (validate() == true)
{
DepartmentBAL _objBAL = new DepartmentBAL();
DepartmentModel _objModel = new DepartmentModel();
_objModel._DeptID = selectedRecordId;
_objModel._DeptName = tbxDeptName.Text;
_objModel._Description = tbxDescription.Text;
_objModel._ModifiedDate = DateTime.Now;
_objModel._IsActive = (cmbIsActive.SelectedIndex == 0) ? true : false;
if (selectedRecordId == 0)
{
_objBAL.SaveDepartment(_objModel);
}
else
{
_objBAL.UpdateDepartment(_objModel);
}
MakeEmpty();
MessageBox.Show("Record Saved Successfully!");
FillGrid();
}
}
catch
{ }
finally
{
Cursor = Cursors.Default;
}
}
public async Task <ActionResult> Add(EmployeeRegistrationModel employee)
{
if (ModelState.IsValid)
{
using (HttpClient httpClient = new HttpClient())
{
string endPoint = CommonHelper.GetSiteUrl() + "API/Account/register";
HttpContent content = new FormUrlEncodedContent(new[]
{
new KeyValuePair <string, string>("firstName", employee.firstName),
new KeyValuePair <string, string>("lastName", employee.lastName),
new KeyValuePair <string, string>("email", employee.email),
new KeyValuePair <string, string>("password", employee.password),
new KeyValuePair <string, string>("confirmPassword", employee.confirmPassword),
new KeyValuePair <string, string>("departmentId", employee.departmentId.ToString()),
new KeyValuePair <string, string>("gender", employee.gender),
new KeyValuePair <string, string>("cityId", employee.cityId.ToString()),
new KeyValuePair <string, string>("countryId", employee.countryId.ToString()),
});
HttpResponseMessage result = await httpClient.PostAsync(endPoint, content);
string resultContent = result.Content.ReadAsStringAsync().Result;
var response = JsonConvert.DeserializeObject <AddEmployeeResponse>(resultContent);
if (!string.IsNullOrEmpty(response.data.id.ToString()))
{
ViewBag.Added = "true";
}
}
}
ViewBag.DepartmentId = new SelectList(await DepartmentBAL.getDepartment(), "Id", "DepartmentName");
ViewBag.CountryId = new SelectList(entity.Countries, "Id", "CountryName");
ViewBag.CityId = new SelectList(entity.Cities, "Id", "CityName");
return(View(employee));
}
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;
}
}
}
public async Task <ActionResult> Add()
{
ViewBag.Added = "false";
ViewBag.DepartmentId = new SelectList(await DepartmentBAL.getDepartment(), "Id", "DepartmentName");
ViewBag.CountryId = new SelectList(entity.Countries, "Id", "CountryName");
ViewBag.CityId = new SelectList(entity.Cities, "Id", "CityName");
return(View());
}
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 static void fillDropDownListDepartment(DropDownList ddl)
{
DepartmentBAL balDepartment = new DepartmentBAL();
ddl.DataSource = balDepartment.SelectForDropDownList();
ddl.DataValueField = "DepartmentID";
ddl.DataTextField = "DepartmentName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem(" --Select Department--", "-1"));
}
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();
}
}
private void FillDepartmentList()
{
DepartmentBAL _objBAL = new DepartmentBAL();
List <DepartmentModel> DepartmentList = new List <DepartmentModel>();
DepartmentList = _objBAL.GetDepartmentList();
cmbDepartment.DataSource = DepartmentList;
cmbDepartment.DisplayMember = "_DeptName";
cmbDepartment.ValueMember = "_DeptID";
cmbDepartment.SelectedIndex = -1;
cmbDepartment.Text = "Select Department";
}
public void fillDepartmentGridview()
{
DepartmentBAL balDepartment = new DepartmentBAL();
DataTable dt = new DataTable();
dt = balDepartment.SelectAll();
if (dt != null && dt.Rows.Count > 0)
{
gvDepartment.DataSource = dt;
gvDepartment.DataBind();
}
}
private void FillGridViewDepartment()
{
DepartmentBAL balDepartment = new DepartmentBAL();
DataTable dtDepartment = new DataTable();
dtDepartment = balDepartment.SelectAll();
if (dtDepartment != null && dtDepartment.Rows.Count > 0)
{
gvDepartment.DataSource = dtDepartment;
gvDepartment.DataBind();
}
}
public async Task <ActionResult> Edit(EmployeeUpdateModel employee)
{
if (ModelState.IsValid)
{
bool isUpdated = await UserBAL.updateEmployee(employee);
if (isUpdated)
{
ViewBag.Updated = "true";
}
}
ViewBag.DepartmentId = new SelectList(await DepartmentBAL.getDepartment(), "Id", "DepartmentName");
ViewBag.CountryId = new SelectList(entity.Countries, "Id", "CountryName");
ViewBag.CityId = new SelectList(entity.Cities, "Id", "CityName");
return(View(employee));
}
private void FillForm(Int32 _DeptID)
{
try
{
DepartmentBAL _objBAL = new DepartmentBAL();
DepartmentModel _objModel = _objBAL.SearchDepartment(_DeptID);
tbxDeptName.Text = _objModel._DeptName;
tbxDescription.Text = _objModel._Description;
tbxModifiedDate.Text = _objModel._ModifiedDate.ToShortDateString();
cmbIsActive.SelectedIndex = (_objModel._IsActive == true) ? 0 : 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillGrid()
{
DepartmentBAL _objBAL = new DepartmentBAL();
List <DepartmentModel> DepartmentList = new List <DepartmentModel>();
grdDepartment.DataSource = null;
grdDepartment.Rows.Clear();
DepartmentList = _objBAL.GetDepartmentList();
grdDepartment.AutoGenerateColumns = false;
int count = 0;
foreach (var item in DepartmentList)
{
count++;
grdDepartment.Rows.Add(item._DeptID, item._DeptName, item._Description, item._ModifiedDate.ToShortDateString());
}
tbxCount.Text = count.ToString();;
}
public async Task <ActionResult> Edit(long id)
{
ViewBag.Updated = "false";
EmployeeUpdateModel employee;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
employee = await UserBAL.getEmployeeById(id);
}
ViewBag.DepartmentId = new SelectList(await DepartmentBAL.getDepartment(), "Id", "DepartmentName", employee.departmentId);
ViewBag.CountryId = new SelectList(entity.Countries, "Id", "CountryName", employee.countryId);
ViewBag.CityId = new SelectList(entity.Cities, "Id", "CityName", employee.cityId);
return(View(employee));
}
public DepartmentController()
{
departmentBAL = new DepartmentBAL();
}
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");
}
}
