protected void btn_delete_Click(object sender, EventArgs e)
{
try
{
if (SysFunc.IsExist("RefundPayment", txtRefundCode.Text, "PaymentReceiptMaster", Session["DealerCode"].ToString()))
{
SysFuncs.UserMsg(success_add_item, Color.Red, "You Can Not Delete it exist in PaymentReceipt");
return;
}
if (SysFunc.CheckVoucherPostFlag(Session["DealerCode"].ToString(), txtVoucherNo.Text))
{
SysFuncs.UserMsg(success_add_item, Color.Red, "Can't Edit or Delete the Voucher '" + txtVoucherNo.Text + "' is already Posted");
return;
}
SqlParameter[] PmtRecMaster_param = { /*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@ReceiptNo", SqlDbType.Char, 8) };
PmtRecMaster_param[0].Value = Session["DealerCode"].ToString();
PmtRecMaster_param[1].Value = txtRefundCode.Text;
if (SysFuncs.ExecuteSP_NonQuery("[sp_W2_PaymentRefund_Master_Delete]", PmtRecMaster_param))
{
SysFunc.UpdateJV(Session["DealerCode"].ToString(), txtVoucherNo.Text);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Deletealert()", true);
}
}
catch (Exception ex)
{
SysFuncs.UserMsg(success_add_item, Color.Red, ex.Message);
return;
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2544", "004"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (SysFunc.CheckVoucherPostFlag(Session["DealerCode"].ToString(), txtVoucherNo.Text))
{
SysFunc.UserMsg(LbErr, Color.Red, "Can't Edit or Delete the Voucher '" + txtVoucherNo.Text + "' is already Posted");
return;
}
SysFunc.UpdateJV(Session["DealerCode"].ToString(), txtVoucherNo.Text);
string ItemCode = string.Empty;
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
ItemCode = gvr.Cells[1].Text;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10), //0
new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //1
new SqlParameter("@GRNNo", SqlDbType.Char, 8), //2
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPayInvNo.SelectedValue.ToString();
param[2].Value = ddlGRN.SelectedValue.ToString().Trim();
param[3].Value = ItemCode;
if (SysFunc.ExecuteSP_NonQuery("sp_PurInvMasterDetail_Delete", param))
{
SysFunc.UserMsg(LbErr, Color.Green, "Deleted Successfully");
btnClear_Click(BtnDelete, EventArgs.Empty);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Deletealert()", true);
}
else
{
SysFunc.UserMsg(LbErr, Color.Red, "Record not delete Try again");
}
}
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
