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");
}
}
