protected void Btncalldel_Click(object sender, EventArgs e)
{
try
{
#region DELETE
string str = LOAN_MASLogicLayer.DeleteLOAN_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:Loan Master Deleted";
lblmsg.ForeColor = Color.Red;
}
clear();
UserRights();
FillLOAN_MasterGrid(Convert.ToString(Session["COMP_CODE"]));
#endregion
}
catch (Exception)
{
throw;
}
}
public void FillLOAN_MasterGrid(string CompCode)
{
DataTable Dt = new DataTable();
Dt = LOAN_MASLogicLayer.GetAllLOAN_MASTERDetail(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()), HfLoanType.Value.ToString());
DataView Dv = new DataView(Dt);
if (CompCode != string.Empty)
{
Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString();
}
GvLoanAdvanceMaster.DataSource = Dv.ToTable();
GvLoanAdvanceMaster.DataBind();
DtSearch = Dv.ToTable();
}
protected void BtncallUpd_Click(object sender, EventArgs e)
{
try
{
if (BtncallUpd.Text == "UPDATE")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
}
else
{
#region INSERT INTO LOAN MASTER DETAILS
LOAN_MASLogicLayer insert = new LOAN_MASLogicLayer();
insert.COMP_CODE = Session["COMP_CODE"].ToString();
//insert.TRAN_DATE = HfTranDate.Value.Trim();
//insert.TRAN_NO = HfTranNo.Value.Trim();
insert.LOAN_TYPE = HfLoanType.Value.Trim().ToString().ToUpper();
insert.LOAN_DATE = Convert.ToDateTime(TxtLoanDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
if (TxtEmployeeName.Text != string.Empty)
{
insert.EMP_CODE = HfEmployeeCode.Value.Trim();
}
insert.FRDT = Convert.ToDateTime(TxtPaidFromDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
insert.TODT = Convert.ToDateTime(TxtPaidToDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
//if(TxtInstallMonth.Text!= string.Empty)
//{
// insert.INSTALL_MONTHS = TxtInstallMonth.Text.Trim();
//}
//else
//{
// insert.INSTALL_MONTHS = null;
//}
insert.INSTALL_MONTHS = null;
if (TxtLoanAmount.Text != string.Empty)
{
insert.LOAN_AMT = TxtLoanAmount.Text.Trim();
}
else
{
insert.LOAN_AMT = null;
}
if (TxtPaidAmount.Text != string.Empty)
{
insert.PAID_AMT = TxtPaidAmount.Text.Trim();
}
else
{
insert.PAID_AMT = null;
}
//if(TxtInstallAmount.Text!=string.Empty)
//{
// insert.INSTALL_AMT = TxtInstallAmount.Text.Trim();
//}
//else
//{
// insert.INSTALL_AMT = null;
//}
insert.INSTALL_AMT = null;
insert.REMARK = TxtRemark.Text.Trim();
insert.STATUS = "O";
#endregion
string str = LOAN_MASLogicLayer.InsertLOAN_MASDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "LOAN MASTER SAVE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillLOAN_MasterGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "LOAN MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : LOAN MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
catch (Exception)
{
throw;
}
}
protected void GvLoanAdvanceMaster_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;
DataTable Dt = LOAN_MASLogicLayer.GetAllIDWiseLOAN_MASTERDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()), HfLoanType.Value.ToString());
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();
HfLoanType.Value = Dt.Rows[0]["LOAN_TYPE"].ToString();
TxtLoanDate.Text = Convert.ToDateTime(Dt.Rows[0]["LOAN_DATE"].ToString()).ToString("dd-MM-yyyy");
HfEmployeeCode.Value = Dt.Rows[0]["EMP_CODE"].ToString();
FillEmployeeNameOnUpdate(Dt.Rows[0]["EMP_CODE"].ToString());
// TxtInstallMonth.Text = Dt.Rows[0]["INSTALL_MONTHS"].ToString();
TxtPaidFromDate.Text = Convert.ToDateTime(Dt.Rows[0]["FRDT"].ToString()).ToString("dd-MM-yyyy");
TxtPaidToDate.Text = Convert.ToDateTime(Dt.Rows[0]["TODT"].ToString()).ToString("dd-MM-yyyy");
TxtLoanAmount.Text = Dt.Rows[0]["LOAN_AMT"].ToString();
// TxtInstallAmount.Text = Dt.Rows[0]["INSTALL_AMT"].ToString();
TxtPaidAmount.Text = Dt.Rows[0]["PAID_AMT"].ToString();
TxtRemark.Text = Dt.Rows[0]["REMARK"].ToString();
}
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;
DataTable Dt = LOAN_MASLogicLayer.GetAllIDWiseLOAN_MASTERDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()), HfLoanType.Value.ToString());
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();
HfLoanType.Value = Dt.Rows[0]["LOAN_TYPE"].ToString();
TxtLoanDate.Text = Convert.ToDateTime(Dt.Rows[0]["LOAN_DATE"].ToString()).ToString("dd-MM-yyyy");
HfEmployeeCode.Value = Dt.Rows[0]["EMP_CODE"].ToString();
FillEmployeeNameOnUpdate(Dt.Rows[0]["EMP_CODE"].ToString());
//TxtInstallMonth.Text = Dt.Rows[0]["INSTALL_MONTHS"].ToString();
TxtPaidFromDate.Text = Convert.ToDateTime(Dt.Rows[0]["FRDT"].ToString()).ToString("dd-MM-yyyy");
TxtPaidToDate.Text = Convert.ToDateTime(Dt.Rows[0]["TODT"].ToString()).ToString("dd-MM-yyyy");
TxtLoanAmount.Text = Dt.Rows[0]["LOAN_AMT"].ToString();
//TxtInstallAmount.Text = Dt.Rows[0]["INSTALL_AMT"].ToString();
TxtPaidAmount.Text = Dt.Rows[0]["PAID_AMT"].ToString();
TxtRemark.Text = Dt.Rows[0]["REMARK"].ToString();
}
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();
Control ctrl = e.CommandSource as Control;
if (ctrl != null)
{
GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow;
HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField;
DataTable Dt = LOAN_MASLogicLayer.GetAllIDWiseLOAN_MASTERDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString()), HfLoanType.Value.ToString());
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();
HfLoanType.Value = Dt.Rows[0]["LOAN_TYPE"].ToString();
TxtLoanDate.Text = Convert.ToDateTime(Dt.Rows[0]["LOAN_DATE"].ToString()).ToString("dd-MM-yyyy");
HfEmployeeCode.Value = Dt.Rows[0]["EMP_CODE"].ToString();
FillEmployeeNameOnUpdate(Dt.Rows[0]["EMP_CODE"].ToString());
// TxtInstallMonth.Text = Dt.Rows[0]["INSTALL_MONTHS"].ToString();
TxtPaidFromDate.Text = Convert.ToDateTime(Dt.Rows[0]["FRDT"].ToString()).ToString("dd-MM-yyyy");
TxtPaidToDate.Text = Convert.ToDateTime(Dt.Rows[0]["TODT"].ToString()).ToString("dd-MM-yyyy");
TxtLoanAmount.Text = Dt.Rows[0]["LOAN_AMT"].ToString();
// TxtInstallAmount.Text = Dt.Rows[0]["INSTALL_AMT"].ToString();
TxtPaidAmount.Text = Dt.Rows[0]["PAID_AMT"].ToString();
TxtRemark.Text = Dt.Rows[0]["REMARK"].ToString();
}
#endregion
ControllerDisable();
btnSave.Visible = false;
Btncalldel.Visible = false;
BtncallUpd.Visible = false;
UserRights();
}
}
}
catch (Exception Ex)
{
Ex.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region UPDATE LOAN MASTER DETAILS
LOAN_MASLogicLayer insert = new LOAN_MASLogicLayer();
insert.COMP_CODE = Session["COMP_CODE"].ToString();
insert.TRAN_DATE = Convert.ToDateTime(HfTranDate.Value.Trim()).ToString("MM-dd-yyyy");
insert.TRAN_NO = HfTranNo.Value.Trim();
insert.LOAN_TYPE = HfLoanType.Value.Trim().ToString().ToUpper();
insert.LOAN_DATE = Convert.ToDateTime(TxtLoanDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
if (TxtEmployeeName.Text != string.Empty)
{
insert.EMP_CODE = HfEmployeeCode.Value.Trim();
}
insert.FRDT = Convert.ToDateTime(TxtPaidFromDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
insert.TODT = Convert.ToDateTime(TxtPaidToDate.Text.Trim().ToString()).ToString("MM-dd-yyyy");
if (TxtInstallMonth.Text != string.Empty)
{
insert.INSTALL_MONTHS = TxtInstallMonth.Text.Trim();
}
else
{
insert.INSTALL_MONTHS = null;
}
if (TxtLoanAmount.Text != string.Empty)
{
insert.LOAN_AMT = TxtLoanAmount.Text.Trim();
}
else
{
insert.LOAN_AMT = null;
}
if (TxtPaidAmount.Text != string.Empty)
{
insert.PAID_AMT = TxtPaidAmount.Text.Trim();
}
else
{
insert.PAID_AMT = null;
}
if (TxtInstallAmount.Text != string.Empty)
{
insert.INSTALL_AMT = TxtInstallAmount.Text.Trim();
}
else
{
insert.INSTALL_AMT = null;
}
insert.REMARK = TxtRemark.Text.Trim();
insert.STATUS = "O";
#endregion
string str = LOAN_MASLogicLayer.UpdateLOAN_MASDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "LOAN MASTER UPDATE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillLOAN_MasterGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "LOAN MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : LOAN MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
catch (Exception)
{
throw;
}
}
