protected void Btncalldel_Click(object sender, EventArgs e)
{
try
{
#region DELETE
string str = ATTN_MASLogicLayer.DeleteATTENDANCE_MASDetailsByID(HfTranNo.Value, Convert.ToDateTime(HfTranDate.Value));
if (str.Contains("successfully"))
{
lblmsg.Text = "Record Deleted Successfully";
lblmsg.ForeColor = Color.Green;
}
else if (str.Contains("Cannot"))
{
lblmsg.Text = "Cannot Delete This Record It Used by Other Data";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "Error:Attendance Master Deleted";
lblmsg.ForeColor = Color.Red;
}
clear();
UserRights();
FillATTENDANCE_MasterGrid(Convert.ToString(Session["COMP_CODE"]));
#endregion
}
catch (Exception)
{
throw;
}
}
public void FillATTENDANCE_MasterGrid(string CompCode)
{
DataTable Dt = new DataTable();
Dt = ATTN_MASLogicLayer.GetAllATTENDANCE_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView Dv = new DataView(Dt);
if (CompCode != string.Empty)
{
Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString();
}
GvEmployeeAttendanceMaster.DataSource = Dv.ToTable();
GvEmployeeAttendanceMaster.DataBind();
DtSearch = Dv.ToTable();
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region UPDATE ATTENDANCE TRANSATION DETAILS
#region INSERT INTO ATTENDANCE MASTER
ATTN_MASLogicLayer insert = new ATTN_MASLogicLayer();
insert.COMP_CODE = HfCompCode.Value.Trim();
insert.TRAN_DATE = Convert.ToDateTime(HfTranDate.Value.Trim()).ToString("MM-dd-yyyy");
insert.TRAN_NO = HfTranNo.Value.Trim();
insert.ATTN_DATE = Convert.ToDateTime(TxtAttendanceDate.Text.Trim()).ToString("MM-dd-yyyy");
insert.HOLIDAY = DdlHolidayFlag.SelectedValue.Trim().ToUpper().ToString();
insert.REMARK = TxtRemark.Text.Trim().ToUpper().ToString();
//insert.INS_USERID = Session["USERNAME"].ToString();
//insert.INS_TERMINAL = Session["PC"].ToString();
//insert.INS_DATE = "";
insert.UPD_USERID = Session["USERNAME"].ToString();
insert.UPD_TERMINAL = Session["PC"].ToString();
insert.UPD_DATE = "";
insert.CONF_FLAG = null;
insert.CONF_DATE = null;
insert.CONF_USERID = null;
#endregion
#region INSERT INTO ATTENDANCE TRANSACTION DETAILS
XmlDocument XDoc1 = new XmlDocument();
XmlDeclaration dec1 = XDoc1.CreateXmlDeclaration("1.0", null, null);
XDoc1.AppendChild(dec1);// Create the root element
XmlElement root1 = XDoc1.CreateElement("root");
XDoc1.AppendChild(root1);
foreach (GridViewRow row in GvEmployeeAttendanceTransaction.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
HiddenField HfCompCodeGrid = row.FindControl("HfCompCodeGrid") as HiddenField;
HiddenField HfTranDateGrid = row.FindControl("HfTranDateGrid") as HiddenField;
HiddenField HfTranNoGrid = row.FindControl("HfTranNoGrid") as HiddenField;
HiddenField HfEmployeeCode = row.FindControl("HfEmployeeCode") as HiddenField;
TextBox TxtEmployeeName = row.FindControl("TxtEmployeeName") as TextBox;
TextBox TxtPayableAmount = row.FindControl("TxtPayableAmount") as TextBox;
TextBox TxtOTHours = row.FindControl("TxtOTHours") as TextBox;
DropDownList DdlAttendanceFlag = row.FindControl("DdlAttendanceFlag") as DropDownList;
if (HfEmployeeCode.Value != string.Empty && HfEmployeeCode.Value != null)
{
XmlElement HandleDetail2 = XDoc1.CreateElement("ATTN_TRAN_Details");
HandleDetail2.SetAttribute("COMP_CODE", HfCompCode.Value.Trim());
HandleDetail2.SetAttribute("TRAN_DATE", (Convert.ToDateTime(HfTranDate.Value.Trim())).ToString("yyyy-MM-dd"));
HandleDetail2.SetAttribute("TRAN_NO", HfTranNo.Value.Trim());
HandleDetail2.SetAttribute("EMP_CODE", HfEmployeeCode.Value.Trim());
HandleDetail2.SetAttribute("ATTN_FLAG", DdlAttendanceFlag.SelectedValue.Trim().ToUpper().ToString());
if (TxtPayableAmount.Text != string.Empty)
{
HandleDetail2.SetAttribute("PAY_AMT", TxtPayableAmount.Text.Trim());
}
if (TxtOTHours.Text != string.Empty)
{
HandleDetail2.SetAttribute("OT_HOURS", TxtOTHours.Text.Trim());
}
//else
//{
// HandleDetail2.SetAttribute("OT_HOURS",null);
//}
//HandleDetail2.SetAttribute("INS_USERID", Session["USERNAME"].ToString());
//HandleDetail2.SetAttribute("INS_TERMINAL", Session["PC"].ToString());
//HandleDetail2.SetAttribute("INS_DATE", (""));
HandleDetail2.SetAttribute("UPD_USERID", Session["USERNAME"].ToString());
HandleDetail2.SetAttribute("UPD_TERMINAL", Session["PC"].ToString());
HandleDetail2.SetAttribute("UPD_DATE", (""));
root1.AppendChild(HandleDetail2);
}
}
}
#endregion
string str = ATTN_MASLogicLayer.UpdateATTENDANCE_MASDetail(insert, validation.RSC(XDoc1.OuterXml));
if (str.Contains("successfully"))
{
lblmsg.Text = "ATTENDACE TRANSACTION MASTER UPDATE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillATTENDANCE_MasterGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "ATTENDACE TRANSACTION MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : ATTENDACE TRANSACTION MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
#endregion
}
catch (Exception)
{
throw;
}
}
protected void GvEmployeeAttendanceMaster_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Deletea")
{
#region DELETE
// clear();
int id = int.Parse(e.CommandArgument.ToString());
Control ctrl = e.CommandSource as Control;
if (ctrl != null)
{
GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow;
HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField;
DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()));
DataTable dt = ds.Tables[0];
DataTable DtDetails = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString();
HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString();
TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy");
DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString();
TxtRemark.Text = dt.Rows[0]["REMARK"].ToString();
}
if (DtDetails.Rows.Count > 0)
{
GvEmployeeAttendanceTransaction.DataSource = DtDetails;
GvEmployeeAttendanceTransaction.DataBind();
}
btnSave.Visible = false;
btnDelete.Visible = true;
Btncalldel.Visible = true;
BtncallUpd.Visible = false;
ControllerDisable();
}
#endregion
}
if (e.CommandName == "Edita")
{
#region EDIT
// clear();
int id = int.Parse(e.CommandArgument.ToString());
Control ctrl = e.CommandSource as Control;
if (ctrl != null)
{
GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow;
HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField;
DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()));
DataTable dt = ds.Tables[0];
DataTable DtDetails = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString();
HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString();
TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy");
DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString();
TxtRemark.Text = dt.Rows[0]["REMARK"].ToString();
}
if (DtDetails.Rows.Count > 0)
{
GvEmployeeAttendanceTransaction.DataSource = DtDetails;
GvEmployeeAttendanceTransaction.DataBind();
}
BtncallUpd.Text = "UPDATE";
#endregion
}
#region CHECK UPDATE RIGHTS
if (Session["UPDATE"] != null)
{
if (Session["UPDATE"].ToString() == "Y")
{
ControllerEnable();
}
else
{
ControllerDisable();
}
}
#endregion
Btncalldel.Visible = false;
BtncallUpd.Visible = true;
btnSave.Visible = true;
UserRights();
}
if (e.CommandName == "Viewa")
{
#region SET TEXT ON VIEW
// clear();
int id = int.Parse(e.CommandArgument.ToString());
Control ctrl = e.CommandSource as Control;
if (ctrl != null)
{
GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow;
HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField;
DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()));
DataTable dt = ds.Tables[0];
DataTable DtDetails = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString();
HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString();
TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy");
DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString();
TxtRemark.Text = dt.Rows[0]["REMARK"].ToString();
}
if (DtDetails.Rows.Count > 0)
{
GvEmployeeAttendanceTransaction.DataSource = DtDetails;
GvEmployeeAttendanceTransaction.DataBind();
}
#endregion
ControllerDisable();
btnSave.Visible = false;
Btncalldel.Visible = false;
BtncallUpd.Visible = false;
UserRights();
}
}
}
catch (Exception EX)
{
EX.ToString();
}
}
