protected void btnDeleteAllowance_Click(object sender, EventArgs e)
{
try
{
#region DELETE ALLOWANCE MASTER
string str = GENERAL_MASLogicLayer.DeleteGENERAL_MASDetaislByID(HfCompCode.Value.ToString(), HfTranNo.Value.ToString(), HfTranType.Value.ToString());
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:Allowance Calculate Master Deleted";
lblmsg.ForeColor = Color.Red;
}
clear();
FillGENEARL_MASTERGrid(Convert.ToString(Session["COMP_CODE"]));
#endregion
}
catch (Exception)
{
throw;
}
}
public void FillGENEARL_MASTERGrid(string CompCode)
{
DataTable Dt = new DataTable();
Dt = GENERAL_MASLogicLayer.GetAllGENERAL_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView DvP = new DataView(Dt);
DvP.RowFilter = "TRAN_TYPE='P'";
DataView DvE = new DataView(Dt);
DvE.RowFilter = "TRAN_TYPE='E'";
DataView DvO = new DataView(Dt);
DvO.RowFilter = "TRAN_TYPE='O'";
DataView DvA = new DataView(Dt);
DvA.RowFilter = "TRAN_TYPE='A'";
GvPFCalculateMaster.DataSource = DvP.ToTable();
GvPFCalculateMaster.DataBind();
GvESICCalculateMaster.DataSource = DvE.ToTable();
GvESICCalculateMaster.DataBind();
GvOTCalculateMaster.DataSource = DvO.ToTable();
GvOTCalculateMaster.DataBind();
GvAllowanceClaculateMaster.DataSource = DvA.ToTable();
GvAllowanceClaculateMaster.DataBind();
//DtSearch = Dv.ToTable();
}
protected void GvAllowanceClaculateMaster_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Selecta")
{
#region SELECT ROW
// 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 HfCompCodeGrid = (row.FindControl("HfCompCodeGrid")) as HiddenField;
HiddenField HfTranTypeGrid = (row.FindControl("HfTranTypeGrid")) as HiddenField;
DataTable dt = GENERAL_MASLogicLayer.GetAllIDWiseGENERAL_MASDetials(HfCompCodeGrid.Value.Trim().ToString(), e.CommandArgument.ToString(), HfTranTypeGrid.Value.Trim().ToString());
if (dt.Rows.Count > 0)
{
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString();
HfTranType.Value = dt.Rows[0]["TRAN_TYPE"].ToString();
TxtAllowanceFromDate.Text = dt.Rows[0]["FRDT"].ToString();
TxtAllowanceToDate.Text = dt.Rows[0]["TODT"].ToString();
TxtAllowanceCalculateHours.Text = dt.Rows[0]["CAL_HOURS"].ToString();
TxtAllowanceCalculateRate1.Text = dt.Rows[0]["CAL_RATE1"].ToString();
BtnSaveAllowanceData.Text = "UPDATE";
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModelSaveAllowance", "ShowModelSaveAllowance()", true);
}
#endregion
}
if (e.CommandName == "Deletea")
{
#region SELECT ROW
// 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 HfCompCodeGrid = (row.FindControl("HfCompCodeGrid")) as HiddenField;
HiddenField HfTranTypeGrid = (row.FindControl("HfTranTypeGrid")) as HiddenField;
DataTable dt = GENERAL_MASLogicLayer.GetAllIDWiseGENERAL_MASDetials(HfCompCodeGrid.Value.Trim().ToString(), e.CommandArgument.ToString(), HfTranTypeGrid.Value.Trim().ToString());
if (dt.Rows.Count > 0)
{
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString();
HfTranType.Value = dt.Rows[0]["TRAN_TYPE"].ToString();
TxtAllowanceFromDate.Text = dt.Rows[0]["FRDT"].ToString();
TxtAllowanceToDate.Text = dt.Rows[0]["TODT"].ToString();
TxtAllowanceCalculateHours.Text = dt.Rows[0]["CAL_HOURS"].ToString();
TxtAllowanceCalculateRate1.Text = dt.Rows[0]["CAL_RATE1"].ToString();
}
}
#endregion
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModelDeleteAllowance", "ShowModelDeleteAllowance()", true);
}
}
catch (Exception)
{
throw;
}
}
public void InsertGeneralMaster(string COMP_CODE, string TRAN_TYPE, string FROM_DATE, string TO_DATE, string WORKING_HOURS, string CAL_HOURS, string CAL_RATE1, string CAL_RATE2)
{
//Save COde
#region INSERT DATA INTO GENERAL MASTER
GENERAL_MASLogicLayer insert = new GENERAL_MASLogicLayer();
insert.COMP_CODE = Session["COMP_CODE"].ToString();
insert.TRAN_TYPE = TRAN_TYPE.ToString().ToUpper();
//insert.TRAN_NO = HfTranNo.Value.Trim();
insert.FRDT = Convert.ToDateTime(FROM_DATE.Trim()).ToString("MM-dd-yyyy"); // FROM_DATE.ToString();
insert.TODT = Convert.ToDateTime(TO_DATE.Trim()).ToString("MM-dd-yyyy"); //TO_DATE.ToString();
if (WORKING_HOURS != string.Empty)
{
insert.WRK_HOURS = WORKING_HOURS.Trim();
}
else
{
insert.WRK_HOURS = null;
}
if (CAL_HOURS != string.Empty)
{
insert.CAL_HOURS = CAL_HOURS.Trim();
}
else
{
insert.CAL_HOURS = null;
}
if (CAL_RATE1 != string.Empty)
{
insert.CAL_RATE1 = CAL_RATE1.Trim();
}
else
{
insert.CAL_RATE1 = null;
}
if (CAL_RATE2 != string.Empty)
{
insert.CAL_RATE2 = CAL_RATE2.Trim();
}
else
{
insert.CAL_RATE2 = null;
}
#endregion
if (btnSavePFData.Text == "SAVE")
{
string str = GENERAL_MASLogicLayer.InsertGENERAL_MASDetails(insert, Session["COMP_CODE"].ToString(), TRAN_TYPE.ToString());
if (str.Contains("successfully"))
{
lblmsg.Text = "EMPLOYEE GENERAL MASTER SAVE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGENEARL_MASTERGrid(Session["COMP_CODE"].ToString());
// UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "AEMPLOYEE GENERAL MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : EMPLOYEE GENERAL MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
else
{
insert.TRAN_NO = HfTranNo.Value.Trim();
string str = GENERAL_MASLogicLayer.UpdateGENERAL_MASDetails(insert, HfCompCode.Value.ToString(), HfTranType.Value.ToString());
if (str.Contains("successfully"))
{
lblmsg.Text = "EMPLOYEE GENERAL MASTER UPDATE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGENEARL_MASTERGrid(Session["COMP_CODE"].ToString());
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "AEMPLOYEE GENERAL MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : EMPLOYEE GENERAL MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
