protected void btnSave_Click(object sender, EventArgs e) { try { string msg = "Expense has been added!"; TblExpense obj = new TblExpense(); obj.IsNew = true; if (!String.IsNullOrEmpty(hdnExpenseID.Value)) { obj.IsNew = false; obj = new TblExpense(hdnExpenseID.Value); msg = "Expense has been Updated!"; } obj.HeadID = Convert.ToInt32(ddlHead.SelectedValue); obj.UpdateBy = 1;//Use User session obj.DateX = getDateTime(); obj.ExpenseDate = txtDate.SelectedDate; obj.Description = txtDescription.Text.Trim(); obj.Amount = Convert.ToInt32(txtAmount.Text); obj.Save(); hdnExpenseID.Value = null; lblmsg.Text = MessageBox.Show(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); BindExpenses(); loadExpenseHead(); } catch { } }
protected void btnDeleteExpense_Click(object sender, EventArgs e) { LinkButton ExpenseID = (LinkButton)sender; TblExpense.Delete(ExpenseID.CommandArgument); lblmsg.Text = MessageBox.Show(msgDiv, "Expense Detail has been deleted", "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); BindExpenses(); }
protected void btnDelete_Click(object sender, EventArgs e) { try { LinkButton ExpenseID = (LinkButton)sender; TblExpense.Delete(ExpenseID.CommandArgument); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, "Expenses detail has been deleted!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-check"); BindExpenses(); } catch { } }
public void ViewReport(int HeadID, string fromDate, string toDate) { DataTable dt = TblExpense.GetExpenseReport(HeadID, (fromDate.Replace("-", "/")), (toDate.Replace("-", "/"))); rptExpenses.DataSource = dt; rptExpenses.DataBind(); if (dt.Rows.Count > 0) { ltrTotal.Text = Convert.ToString(dt.Rows[0]["TotalExpense"]); } }
private void cloneData() { if (Session["ExpenseID"] != null) { TblExpense obj = new TblExpense(Session["ExpenseID"]); txtTitle.Text = obj.Title; txtDescription.Text = obj.Description; txtAmount.Text = obj.Amount.ToString(); txtExpenseDate.SelectedDate = obj.ExpenseDate; ddlExpenseHead.SelectedValue = obj.HeadID.ToString(); } }
protected void btnShowYearlyReport_Click(object sender, EventArgs e) { DataTable dt = TblExpense.GetSelectedYearReport(Convert.ToInt32(ddBranches.SelectedValue), Convert.ToInt32(ddlExpenseHead.SelectedValue), ddlYear.SelectedItem.Text); if (dt.Rows.Count > 0) { ExpenseReport.GetExpenseDetails = dt; ExpenseReport.BranchName = ddBranches.SelectedItem.Text; ExpenseReport.ExpenseHead = ddlExpenseHead.SelectedItem.Text; ExpenseReport.rptType = "For Year " + ddlYear.SelectedItem.Text; string pageurl = "../Reports/ExpenseReport.aspx"; // Response.Write("<script> window.open('" + pageurl + "','_blank'); </script>"); ScriptManager.RegisterClientScriptBlock(this.pnl, this.pnl.GetType(), "openReport", " window.open('" + pageurl + "','_blank');", true); } }
protected void btnShowRangeReport_Click(object sender, EventArgs e) { DataTable dt = TblExpense.GetDateRangeReport(Convert.ToInt32(ddBranches.SelectedValue), Convert.ToInt32(ddlExpenseHead.SelectedValue), Convert.ToDateTime(txtRangeFromDate.SelectedDate).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtToRangeDate.SelectedDate).ToString("yyyy-MM-dd")); if (dt.Rows.Count > 0) { ExpenseReport.GetExpenseDetails = dt; ExpenseReport.BranchName = ddBranches.SelectedItem.Text; ExpenseReport.ExpenseHead = ddlExpenseHead.SelectedItem.Text; ExpenseReport.rptType = "For Date " + Convert.ToDateTime(txtRangeFromDate.SelectedDate).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(txtToRangeDate.SelectedDate).ToString("dd-MM-yyyy"); string pageurl = "../Reports/ExpenseReport.aspx"; // Response.Write("<script> window.open('" + pageurl + "','_blank'); </script>"); ScriptManager.RegisterClientScriptBlock(this.pnl, this.pnl.GetType(), "openReport", " window.open('" + pageurl + "','_blank');", true); } }
protected void btnDelete_Click(object sender, EventArgs e) { LinkButton ExpenseHeadID = (LinkButton)sender; TblExpense obj = new TblExpense(TblExpense.Columns.HeadID, ExpenseHeadID.CommandArgument); if (obj.ExpenseID != 0) { lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, "Some expenses against " + ExpenseHeadID.CommandName + " are exists!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o"); } else { TblExpenseHead.Delete(ExpenseHeadID.CommandArgument); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, "Expense head has been deleted successfully!", "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); BindExpenseHead(); } }
protected void btnEditEnpense_Click(object sender, EventArgs e) { LinkButton ExpenseID = (LinkButton)sender; TblExpense obj = new TblExpense(ExpenseID.CommandArgument); txtAmount.Text = obj.Amount.ToString(); txtDescription.Text = obj.Description; txtDate.SelectedDate = obj.DateX; try { ddlHead.SelectedValue = string.IsNullOrEmpty(obj.HeadID.ToString()) ? "-1" : obj.HeadID.ToString(); } catch { ddlHead.SelectedValue = "-1"; } hdnExpenseID.Value = ExpenseID.CommandArgument; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal('#formPopUp');", true); }
protected void btnSave_Click(object sender, EventArgs e) { try { string msg = "Expenses detail has been added!"; TblExpense obj = new TblExpense(); obj.IsNew = true; if (Session["ExpenseID"] != null) { obj.IsNew = false; obj = new TblExpense(Session["ExpenseID"]); msg = "Expenses detail has been updated!"; } obj.HeadID = Convert.ToInt32(ddlExpenseHead.SelectedValue); if (Session["ExpenseID"] == null) { obj.BranchID = Convert.ToInt32(Session["BranchID"]); obj.UserID = Convert.ToInt32(Session["BranchUserID"]); } obj.UpdateBy = Convert.ToInt32(Session["BranchUserID"]); obj.DateX = DateTime.Now; obj.ExpenseDate = txtExpenseDate.SelectedDate; obj.Title = txtTitle.Text.Trim(); obj.Description = txtDescription.Text.Trim(); obj.Amount = Convert.ToInt32(txtAmount.Text); obj.Save(); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(Page.Controls); Session["ExpenseID"] = null; } catch { lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, "Internal Server Error!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o"); } }