protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
txtReceiptNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtReceiptDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtReceiptDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
if (!Page.IsPostBack)
{
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindFromCity();
}
else
{
this.BindFromCity(Convert.ToInt64(Session["UserIdno"]));
}
drpCityFrom.SelectedValue = Convert.ToString(base.UserFromCity);
this.BindDateRange();
ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlDateRange_SelectedIndexChanged(null, null);
this.BindCity();
this.BindSenderReceiverAgent();
ReceiptGoodsReceivedDAL Obj = new ReceiptGoodsReceivedDAL();
lblTotalRecord.Text = "T. Record (s): " + Obj.Select_ReceiptGoodsCount();
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("RcptGoodsReceived.aspx?q=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
Int64 UserIdno = Convert.ToInt64(Session["UserIdno"]);
ReceiptGoodsReceivedDAL obj = new ReceiptGoodsReceivedDAL();
Int32 intValue = obj.DeleteReceiptGoods(Convert.ToInt32(e.CommandArgument), UserIdno, ApplicationFunction.ConnectionString());
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtReceiptNo.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);
}
}
private void BindSenderReceiverAgentPopulate()
{
ReceiptGoodsReceivedDAL obj = new ReceiptGoodsReceivedDAL();
var SenderReceiver = obj.SelectAcntMastByTypePopulate(2);
BindDropdownDAL objagent = new BindDropdownDAL();
var Agent = objagent.BindAgent();
obj = null;
drpSender.DataSource = SenderReceiver;
drpSender.DataTextField = "Acnt_Name";
drpSender.DataValueField = "Acnt_Idno";
drpSender.DataBind();
drpSender.Items.Insert(0, new ListItem("--Select--", "0"));
drpReceiver.DataSource = SenderReceiver;
drpReceiver.DataTextField = "Acnt_Name";
drpReceiver.DataValueField = "Acnt_Idno";
drpReceiver.DataBind();
drpReceiver.Items.Insert(0, new ListItem("--Select--", "0"));
drpAgentName.DataSource = Agent;
drpAgentName.DataTextField = "Acnt_Name";
drpAgentName.DataValueField = "Acnt_Idno";
drpAgentName.DataBind();
drpAgentName.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
string Idno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "RcptGoodHead_Idno"));
if (Idno != "")
{
ReceiptGoodsReceivedDAL obj = new ReceiptGoodsReceivedDAL();
var ItemExist = obj.CheckItemExistInOtherMaster(Convert.ToString(Idno));
if (ItemExist != null && ItemExist.Count > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
}
}
}
private void BindGrid()
{
ReceiptGoodsReceivedDAL objclsCityMaster = new ReceiptGoodsReceivedDAL();
DateTime?dtfrom = null;
DateTime?dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int recptno = string.IsNullOrEmpty(Convert.ToString(txtReceiptNo.Text)) ? 0 : Convert.ToInt32(txtReceiptNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
int citto = Convert.ToInt32(drpCityTo.SelectedValue);
int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue);
int citydel = Convert.ToInt32(drpCityDelivery.SelectedValue);
int sender = Convert.ToInt32(drpSender.SelectedValue);
int receiver = Convert.ToInt32(drpReceiver.SelectedValue);
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = objclsCityMaster.SelectReceiptGoods(recptno, dtfrom, dtto, cityfrom, citydel, citto, sender, receiver, yearidno, UserIdno);
objclsCityMaster = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("RcptNo", typeof(string));
dt.Columns.Add("RcptDate", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("ToCity", typeof(string));
dt.Columns.Add("DelvCity", typeof(string));
dt.Columns.Add("Sender", typeof(string));
dt.Columns.Add("Receiver", 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["RcptNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "RcptGoodHead_No"));
dr["RcptDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "RcptGoodHead_Date")).ToString("dd-MM-yyyy");
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityFrom"));
dr["ToCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityTo"));
dr["DelvCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityDely"));
dr["Sender"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Sender"));
dr["Receiver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Receiver"));
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
grdprint.DataSource = lstGridData;
grdprint.DataBind();
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;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
grdprint.DataSource = null;
grdprint.DataBind();
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
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;
}
txtReceiptDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
this.GetAllItems();
this.BindCity();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obj1 = new ReceiptGoodsReceivedDAL();
var lst = obj1.SelectCityCombo();
obj1 = null;
drpBaseCity.DataSource = lst;
drpBaseCity.DataTextField = "City_Name";
drpBaseCity.DataValueField = "City_Idno";
drpBaseCity.DataBind();
drpBaseCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ReceiptGoodsReceivedDAL objChlnBookingDAL = new ReceiptGoodsReceivedDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
if (obj != null)
{
drpBaseCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
}
drpBaseCity.SelectedValue = Convert.ToString(base.UserFromCity);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obja = new ReceiptGoodsReceivedDAL();
var SenderReceiver = obja.SelectAcntMastByType(2);
BindDropdownDAL objagent = new BindDropdownDAL();
var Agent = objagent.BindAgent();
obj = null;
drpSender.DataSource = SenderReceiver;
drpSender.DataTextField = "Acnt_Name";
drpSender.DataValueField = "Acnt_Idno";
drpSender.DataBind();
drpSender.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindSenderReceiverAgent();
}
drpSender.SelectedValue = Convert.ToString(base.Sender);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ItemMasterDAL obja = new ItemMasterDAL();
var lst = obja.GetItems();
obj = null;
drpItemName.DataSource = lst;
drpItemName.DataTextField = "ItemName";
drpItemName.DataValueField = "ItemId";
drpItemName.DataBind();
drpItemName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllItems();
}
drpItemName.SelectedValue = Convert.ToString(base.ItemName);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
UOMMasterDAL obja = new UOMMasterDAL();
var lst = obja.GetUnit();
obj = null;
drpUnitName.DataSource = lst;
drpUnitName.DataTextField = "UOMName";
drpUnitName.DataValueField = "UOMId";
drpUnitName.DataBind();
drpUnitName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllUnit();
}
drpUnitName.SelectedValue = Convert.ToString(base.Unit);
//this.GetAllUnit();
this.BindDateRange();
ddlDateRange_SelectedIndexChanged(null, null);
ddlDateRange.SelectedIndex = 0;
drpBaseCity.Enabled = true;
this.GetReceiptNo();
if (Request.QueryString["q"] != null)
{
this.BindSenderReceiverAgentPopulate();
Populate(Convert.ToInt64(Request.QueryString["q"]));
hidgoodsreceivedid.Value = Convert.ToString(Request.QueryString["q"]);
btnNew.Visible = true;
lnkbtnNew.Visible = true;
ddlDateRange.Enabled = false; imgPrint.Visible = true;
}
else
{
lnkbtnNew.Visible = false;
ddlDateRange.Enabled = true;
imgPrint.Visible = false;
//this.BindSenderReceiverAgent();
}
txtWeight.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);");
txtQty.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtSenderNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtReceiptDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtRemark.Attributes.Add("onkeypress", "return notAllowSpecialCharacters_Spaceallow(event);");
}
Int32 intYearIdno = Convert.ToInt32(ddlDateRange.SelectedValue);
}
