protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName.ToLower())
{
case "deleteleave":
{
EmployeeLeaveDays.DeleteEmployeeLeaveDaysByEmployeeLeaveDaysId(Convert.ToInt32(e.CommandArgument), this.Master.LoggedOnAccount);
EmployeeLeave.UpdateEmloyeeLeaveCurrentDaysByEmployeeLeaveDaysId(Convert.ToInt32(e.CommandArgument), 2 /*Delete*/, this.Master.LoggedOnAccount);
SendEmployeeLeaveDeletionNotificationList();
BindGridviewResult();
BindEmployeeLeave();
break;
}
case "viewattachment":
{
EmployeeLeaveDays employeeLeaveDays = EmployeeLeaveDays.GetEmployeeLeaveDaysByEmployeeLeaveDaysId(Convert.ToInt32(e.CommandArgument));
//Response.Redirect(String.Format("{0}",employeeLeaveDays.Attachment));
//System.IO.FileStream fs = null;
//fs = System.IO.File.Open(employeeLeaveDays.Attachment, System.IO.FileMode.Open);
//byte[] btFile = new byte[fs.Length];
//fs.Read(btFile, 0, Convert.ToInt32(fs.Length));
//fs.Close();
//Response.AddHeader("Content-disposition", "attachment; filename=" + "LeaveAttachment");
//Response.ContentType = "image/jpeg";
//Response.BinaryWrite(btFile);
//Response.End();
Response.Clear();
Response.ContentType = "image/jpg";
Response.AppendHeader("Content-Disposition", "attachment; filename=LeaveAttachment.jpg");
Response.TransmitFile(employeeLeaveDays.Attachment);
Response.End();
break;
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
}
}
protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName.ToLower())
{
case "approve":
{
EmployeeLeaveDays.UpdateEmployeeLeaveDaysIsApprovalByEmployeeLeaveDaysId((Convert.ToInt32(e.CommandArgument)), 3 /*Approved*/, this.Master.LoggedOnAccount);
EmployeeLeave.UpdateEmloyeeLeaveCurrentDaysByEmployeeLeaveDaysId(Convert.ToInt32(e.CommandArgument), 1 /*Approve*/, this.Master.LoggedOnAccount);
SendEmployeeLeaveReportsToDecisionNotification((Convert.ToInt32(e.CommandArgument)));
break;
}
case "decline":
{
EmployeeLeaveDays.UpdateEmployeeLeaveDaysIsApprovalByEmployeeLeaveDaysId((Convert.ToInt32(e.CommandArgument)), 1 /*Decline*/, this.Master.LoggedOnAccount);
SendEmployeeLeaveReportsToDecisionNotification((Convert.ToInt32(e.CommandArgument)));
break;
}
}
GridViewResult.DataSource = EmployeeLeaveDays.GetEmployeeListFilterByReportsToId(ViewState["Search"].ToString(), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId, Convert.ToInt32(DropDownListFinancialPeriod.SelectedValue));
GridViewResult.DataBind();
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
//LabelError.Text = "";
//for (int i = 0; i < sqlEx.Errors.Count; i++)
//{
// LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
//}
//PanelError.Visible = true;
}
}
