protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("AmntAgainstGr.aspx?q=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
Int64 UserIdno = Convert.ToInt64(Session["UserIdno"]);
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument), UserIdno, ApplicationFunction.ConnectionString());
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtRcptNo.Focus();
}
else
{
if (intValue == -1)
{
strMsg = "Record can not be deleted. It is in use.";
}
else
{
strMsg = "Record not deleted.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
protected void lnkbtnSearch_Click(object sender, EventArgs e)
{
try
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
Int64 iPRTYIDNO = (ddlPartyName.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlPartyName.SelectedValue));
Int32 iFromcity = (ddlFromCity.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue));
string strGrFrm = "";
strGrFrm = "BK";
DataTable DsGrdetail = obj.SelectGRPaymentDetail("SelectGRPaymentDetail", Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iPRTYIDNO, strGrFrm, iFromcity, ApplicationFunction.ConnectionString());
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
grdGrdetals.DataSource = DsGrdetail;
grdGrdetals.DataBind();
lnkbtnsubmit.Visible = true;
lblTotalRecord.Text = "T. Record(s) : " + Convert.ToString(DsGrdetail.Rows.Count);
}
else
{
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
lnkbtnsubmit.Visible = false;
lblTotalRecord.Text = "T. Record(s) : 0";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
private void GetReceiptNo()
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
Int64 max = obj.GetMaxNo();
obj = null;
txtRcptNo.Text = Convert.ToInt64(max) <= 0 ? "1" : Convert.ToString(max);
}
protected void lnkbtnsubmit_Click(object sender, EventArgs e)
{
try
{
if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0))
{
string strchkValue = string.Empty; string sAllItemIdnos = string.Empty;
string strchkDetlValue = string.Empty;
for (int count = 0; count < grdGrdetals.Rows.Count; count++)
{
CheckBox ChkGr = (CheckBox)grdGrdetals.Rows[count].FindControl("chkId");
if ((ChkGr != null) && (ChkGr.Checked == true))
{
HiddenField hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno");
strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ",";
}
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
if (strchkDetlValue == "")
{
ShowMessageErr("Please check atleast one Gr.");
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
else
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
string strSbillNo = String.Empty;
DataTable dtRcptDetl = new DataTable(); DataRow Dr;
dtRcptDetl = obj.SelectGRDetail(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToString(strchkDetlValue));
ViewState["dt"] = dtRcptDetl;
BindGrid();
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
}
ddlRcptTyp.Focus();
}
else
{
ShowMessageErr("Gr Details not found.");
grdMain.DataSource = null;
grdMain.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
#endregion
#region Page Load...
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
txtRcptNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
txtGrDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtGrDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
if (!Page.IsPostBack)
{
this.BindDateRange();
ddldateRange.SelectedIndex = 0;
ddldateRange_SelectedIndexChanged(null, null);
this.BindCity();
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex != -1) ? "0" : drpCityFrom.SelectedValue);
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
}
}
}
private void BindGrid()
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex == 0) ? "0" : drpCityFrom.SelectedValue);
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("RecpNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0; double TAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["RecpNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Rcpt_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Rcpt_date")).ToString("dd-MM-yyyy");
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity"));
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Party"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
lblNetTotalAmount.Text = TNet.ToString("N2");
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
// con ApplicationFunction.ConnectionString() ;//ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.ADD == false)
{
lnkbtnSave.Visible = false;
}
if (base.View == false)
{
lblViewList.Visible = false;
}
this.BindReceiptType();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
this.BindDateRange();
this.BindPartName();
this.BindCustBank();
this.BindPartName();
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddldateRange.SelectedIndex = 0; txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtGRDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtInstDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtRcptNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
ddldateRange_SelectedIndexChanged(null, null);
RcvdAmntAgnstGRDAL objChlnBookingDAL = new RcvdAmntAgnstGRDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
// ddlFromCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
ddlFromCity.SelectedValue = Convert.ToString(base.UserFromCity);
lnkimgSearch.Enabled = true;
ddlRcptType_SelectedIndexChanged(null, null);
GetRcptNo(Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(ddlFromCity.SelectedValue));
ddlFromCity.Enabled = true;
ddlFromCity_SelectedIndexChanged(null, null);
if (Request.QueryString["q"] != null)
{
Populate(Convert.ToInt64(Request.QueryString["q"]));
hidid.Value = Convert.ToString(Request.QueryString["q"]);
lnkbtnPrint.Visible = true;
lnkbtnNew.Visible = true;
}
else
{
lnkbtnPrint.Visible = false;
lnkbtnNew.Visible = false;
}
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
//DtTemp = (DataTable)ViewState["dt"];
//BindGrid();
//if (DtTemp != null && DtTemp.Rows.Count <= 0)
//{
// if (DtTemp.Rows.Count <= 0)
// {
// ShowMessage("Please enter details");
// return;
// }
//}
if (Convert.ToDouble(txtNetAmnt.Text) <= 0)
{
ShowMessageErr("Net Amount Must be Greater Than Zero.");
grdMain.Focus();
return;
}
if (grdMain.Rows.Count > 0)
{
DtTemp = CreateDt();
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGrIdno");
Label lblGrno = (Label)row.FindControl("lblGrno");
Label lblGrDate = (Label)row.FindControl("lblGrDate");
HiddenField hidRecivrIdno = (HiddenField)row.FindControl("hidRecivrIdno");
Label lblGrFrom = (Label)row.FindControl("lblGrFrom");
HiddenField hidToCityIdno = (HiddenField)row.FindControl("hidToCityIdno");
HiddenField hidFromCityIdno = (HiddenField)row.FindControl("hidFromCityIdno");
Label lblAmount = (Label)row.FindControl("lblAmount");
Label lblTotRecvd = (Label)row.FindControl("lblTotRecvd");
Label lblCurBal = (Label)row.FindControl("lblCurBal");
TextBox txtRcvdAmnt = (TextBox)row.FindControl("txtRcvdAmnt");
ApplicationFunction.DatatableAddRow(DtTemp, hidGrIdno.Value, lblGrno.Text, (ApplicationFunction.mmddyyyy(lblGrDate.Text)), hidRecivrIdno.Value, "BK", hidToCityIdno.Value, hidFromCityIdno.Value, lblAmount.Text, lblTotRecvd.Text, lblCurBal.Text, txtRcvdAmnt.Text);
}
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
tblAmntRecvdGR_Head objRGH = new tblAmntRecvdGR_Head();
objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text);
objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue);
objRGH.FromCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue);
objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGRDate.Text));
objRGH.Party_IdNo = Convert.ToInt64(ddlPartyName.SelectedValue);
objRGH.Inst_No = Convert.ToString(txtInstNo.Text);
objRGH.Date_Added = System.DateTime.Now;
objRGH.Date_Modified = null;
objRGH.CustBank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue);
objRGH.RcptTyp_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue);
objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]);
if (txtInstDate.Text == "")
{
objRGH.Inst_Date = null;
}
else
{
objRGH.Inst_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
}
objRGH.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objRGH.Remark = Convert.ToString(TxtRemark.Text);
objRGH.status = true;
objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue);
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
value = obj.Insert(objRGH, DtTemp);
obj = null;
}
else
{
value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value))), DtTemp);
obj = null;
}
if (value > 0)
{
if (this.PostIntoAccounts(Convert.ToDouble(txtNetAmnt.Text), value, "ARGR", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true)
{
if (string.IsNullOrEmpty(hidid.Value) == false)
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
this.Clear();
}
else if (value == -1)
{
ShowMessageErr("Rcpt No Already Exist");
}
else if (string.IsNullOrEmpty(hidid.Value) == false)
{
ShowMessageErr("Record Not Update");
}
}
else
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record Saved successfully");
this.Clear();
}
else if (value == -1)
{
ShowMessageErr("Rcpt No Already Exist");
}
else if ((string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessageErr("Record Not Saved successfully");
}
}
tScope.Complete();
}
else
{
if (string.IsNullOrEmpty(hidpostingmsg.Value) == true)
{
if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false)
{
hidpostingmsg.Value = "Record(s) not updated.";
}
else
{
hidpostingmsg.Value = "Record(s) not saved.";
}
tScope.Dispose();
}
tScope.Dispose();
ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidpostingmsg.Value) + "')", true);
return;
}
}
}
}
else
{
ShowMessageErr("Please Enter Detais");
return;
}
}
