protected void gridViewConsignment_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView gvChildGrid = (GridView)e.Row.FindControl("gvChildGrid"); ConsignmentBusinessAccess conbal = new ConsignmentBusinessAccess(); Label lblConsignmentId = (Label)e.Row.FindControl("lblConsignmentId"); int ConsignmentId = Convert.ToInt32(lblConsignmentId.Text); int locationId = 0; if (basePage.LoggedInUser.UserLocation != null) { locationId = basePage.LoggedInUser.UserLocation.LocationId; } int usertype = basePage.LoggedInUser.UserTypeId; List <Pax> lstpax = null; if (usertype == Convert.ToInt32(UserType.Admin) || usertype == Convert.ToInt32(UserType.SuperAdmin)) { locationId = 0; lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId); } else { lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId); } gvChildGrid.DataSource = lstpax; gvChildGrid.DataBind(); // gridViewConsignment.Columns[1].Visible = false; } }
protected void gridViewConsignment_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView gvChildGrid = (GridView)e.Row.FindControl("gvChildGrid"); ConsignmentBusinessAccess conbal = new ConsignmentBusinessAccess(); Label lblConsignmentId = (Label)e.Row.FindControl("lblConsignmentId"); int ConsignmentId = Convert.ToInt32(lblConsignmentId.Text); int locationId = LoggedInUser.UserLocation.LocationId; int usertype = LoggedInUser.UserTypeId; List <Pax> lstpax = null; if (usertype == Convert.ToInt32(UserType.Admin) || usertype == Convert.ToInt32(UserType.SuperAdmin)) { locationId = 0; lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId); } else { lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId); } var lst = lstpax.Select(a => new { a.PaxName }).Distinct(); gvChildGrid.DataSource = lst; gvChildGrid.DataBind(); gvChildGrid.ShowHeader = false; UserDom user = new UserDom(); user = userBal.ReadUserByLoginId(LoggedInUser.LoginId); LinkButton lnkEdit = (LinkButton)e.Row.FindControl("btnEdit"); LinkButton lnkDelete = (LinkButton)e.Row.FindControl("btnDelete"); lnkEdit.Visible = false; lnkDelete.Visible = false; if (LoggedInUser.UserTypeId == Convert.ToInt32(UserType.Admin) || LoggedInUser.UserTypeId == Convert.ToInt32(UserType.SuperAdmin)) { lnkEdit.Visible = true; lnkDelete.Visible = true; } else if (LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && user.UserTask.Count > 0) { for (int i = 0; i < user.UserTask.Count; i++) { if (LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EditConsignment)))) { if (lnkEdit != null) { lnkEdit.Visible = true; } } if (LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.DeleteConsignment)))) { if (lnkDelete != null) { lnkDelete.Visible = true; } } } } } }
public void BindConsignmentGrid() { if (txtfrmdate.Text == "" && txttodate.Text == "" && txtConsignmentNosearch.Text == "" && ddlAgent.SelectedIndex == 0 && ddlcountry.SelectedIndex == 0) { Response.Write("<script LANGUAGE='JavaScript' >alert('Please Select Any Option To Search. ')</script>"); } else { int locationId = LoggedInUser.UserLocation.LocationId; int usertype = LoggedInUser.UserTypeId; string PaxName = null; string PaxPassportNo = null; int consignmentNo = 0; ResetViewState(); ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); List <Consignment> lstConsignment; if (!string.IsNullOrEmpty(txtfrmdate.Text)) { FromDate = Convert.ToDateTime(txtfrmdate.Text); } if (!string.IsNullOrEmpty(txttodate.Text)) { ToDate = Convert.ToDateTime(txttodate.Text); } if (!string.IsNullOrEmpty(txtConsignmentNosearch.Text)) { consignmentNo = Convert.ToInt32(txtConsignmentNosearch.Text); } countryId = Convert.ToInt32(ddlcountry.SelectedValue); agentId = Convert.ToInt32(ddlAgent.SelectedValue); string deliveryStatus = null; if (usertype == Convert.ToInt32(UserType.Admin)) { locationId = 0; // lstConsignment = consignmentBal.ReadConsignmentDataByDates(FromDate, ToDate, countryId, agentId, locationId, deliveryStatus, consignmentNo); } else { // lstConsignment = consignmentBal.ReadConsignmentDataByDates(FromDate, ToDate, countryId, agentId, locationId, deliveryStatus, consignmentNo); } //if (lstConsignment.Count > 0) //{ // gridViewConsignment.DataSource = lstConsignment; // gridViewConsignment.DataBind(); // gridViewConsignment.Visible = true; //} //else //{ // ShowMessageWithUpdatePanel("No Record Found"); // gridViewConsignment.Visible = false; // clear(); //} } }
public void repeaterbind() { ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); List <Consignment> lstcon = (List <Consignment>)Session["listconsign"]; ReptrMailRemarks.DataSource = lstcon; ReptrMailRemarks.DataBind(); }
public void MailRemarkGridBind() { ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); Consignment lstcon = (Consignment)Session["listconsign"]; if (lstcon != null && lstcon.MailRemarksDetails != null) { GridViewMailRemark.DataSource = lstcon.MailRemarksDetails; GridViewMailRemark.DataBind(); } }
protected void gridViewConsignment_RowCommand(object sender, GridViewCommandEventArgs e) { ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); int id = Convert.ToInt32(e.CommandArgument); Session["consignmentId"] = id; if (e.CommandName == "cmdViewCon") { string Id1 = "view"; Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&cons=" + Id1); } }
protected void gridViewConsignment_RowUpdating(object sender, GridViewUpdateEventArgs e) { int consignmentId = Convert.ToInt32(Session["consignmentId"]); DropDownList drpdwnStatus = (DropDownList)gridViewConsignment.Rows[e.RowIndex].FindControl("DrpdnConsignStatus"); DropDownList drpdwndocumntStatus = (DropDownList)gridViewConsignment.Rows[e.RowIndex].FindControl("DDlConsignDocumntStatus"); Consignment consignment = new Consignment(); ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); consignment.ConsignmentVisaStatusId = Convert.ToInt32(drpdwnStatus.SelectedItem.Value); consignment.ConsignmentDocumnetStatusId = Convert.ToInt32(drpdwndocumntStatus.SelectedItem.Value); consignmentBal.UpdateConsignmentStatus(consignment, consignmentId); gridViewConsignment.EditIndex = -1; BindConsignmentGrid(); }
protected void gridViewConsignment_RowCommand(object sender, GridViewCommandEventArgs e) { ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); if (e.CommandName == "Find") { FindRecordByPassprtNo(); } // int id = Convert.ToInt32(e.CommandArgument); //ViewState["Id"] = id; //if (e.CommandName == "cmdEdit") //{ // string Id1 = "cons"; // Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&cons=" + Id1); //} //else if (e.CommandName == "cmdViewCon") //{ // string Id1 = "view"; // Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&cons=" + Id1); //} //else if (e.CommandName == "cmdEditPax") //{ // string Id1 = "pax"; // Response.Redirect("AddConsignment.aspx?PaxId=" + id + "&cons=" + Id1); //} //else if (e.CommandName == "cmdEditMailremark") //{ // string Id1 = "mail"; // Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&cons=" + Id1); //} //else if (e.CommandName == "cmdDelete") //{ // consignmentBal.DeleteConsignment(id); //} BindConsignmentGrid(); // Clear(); }
public void BindConsignmentGrid() { int locationId = basePage.LoggedInUser.UserLocation.LocationId; int userType = basePage.LoggedInUser.UserTypeId; DateTime fromDate = Convert.ToDateTime(txtfrmdate.Text); DateTime toDate = Convert.ToDateTime(txttodate.Text); ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); if (fromDate <= toDate) { List <Consignment> lstconsignment; if (userType == Convert.ToInt32(UserType.Admin) || userType == Convert.ToInt32(UserType.SuperAdmin)) { locationId = 0; // lstconsignment = consignmentBal.ReadConsignmentDataByDates(fromDate, toDate,0,0,locationId,null,0,null); } else { // lstconsignment = consignmentBal.ReadConsignmentDataByDates(fromDate, toDate,0,0,locationId,null,0, null); } //if (lstconsignment.Count > 0) //{ // gridViewConsignment.DataSource = lstconsignment; // gridViewConsignment.DataBind(); //} //else //{ // ShowMessageWithUpdatePanel("Record Not Found"); //} } else { //txtfrmdate.Text = ""; txttodate.Text = ""; ShowMessageWithUpdatePanel("ToDate Can Not be Less Then FromDate"); } }
protected void gridViewConsignment_RowCommand(object sender, GridViewCommandEventArgs e) { ConsignmentBusinessAccess consignmentBal = new ConsignmentBusinessAccess(); int id = Convert.ToInt32(e.CommandArgument); ViewState["Id"] = id; if (e.CommandName == "cmdEdit") { string Id1 = "EditConsignment"; Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&consignment=" + Id1); } else if (e.CommandName == "cmdViewCon") { string Id1 = "view"; Response.Redirect("AddConsignment.aspx?ConsignmentId=" + id + "&cons=" + Id1); } else if (e.CommandName == "cmdDelete") { consignmentBal.DeleteConsignment(id); } BindConsignmentGrid(); }
protected void BtnConsignmentUpdate_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["ConsignmentId"]); ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); Consignment consignment = new Consignment(); consignment.FkAgentId = 0; consignment.Country_Id = Convert.ToInt32(DrpdnVisaCountry.SelectedItem.Value); consignment.CgSubmissionDate = (txtSubmDate.Text); consignment.CgCheckOnDate = (txtChkDate.Text); consignment.CgTravelDates = (txtTravlDate.Text); consignment.CG_COLLECTION_DATE = (txtTravlDate.Text); consignment.CgGroupRep = txtGroup.Text; consignment.CgInstruction = TxtInstruction.Text; consignment.CgRemarks = txtRemark.Text; consignment.CG_COLLECTED = ChckbxCollctd.Text = ""; consignment.CG_BLANK_COLLECTION_DATE = ChckbxBlnkColDate.Text = ""; consignment.CG_DISABLE = ChckbxDisabl.Text = ""; consignment.CG_BLANK_SUBMISSION_DATE = ChckbxBlankSubDate.Text = ""; consignment.CgAreaCode = txtAreaCod.Text; //consignment.CG_TRANSFER_TO = DrpdnTransfer.SelectedItem.Text; consignment.CgNoOfPass = Convert.ToInt32(txtNoPassport.Text); consignment.CgNoOfDD = Convert.ToInt32(txtNoDD.Text); consignment.CgEnteredBy = txtEnterdBy.Text; consignment.CG_SENTBY_NAME = txtSntName.Text; consignment.CgCorporate = txtCorporate.Text; consignment.CgMobNo = txtmob.Text; consignment.CG_EMAIL = txtEmail.Text; consignBal.UpdateConsignment(consignment, id); ScriptManager.RegisterClientScriptBlock(BtnConsignmentUpdate, GetType(), "test", "alert('Consignment updated successfully!!!')", true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillDropDown(); if (Request.QueryString["AgentID"] != null) { LblAgentName.Text = Request.QueryString["AgentName"]; //lblPAXAgent.Text = Request.QueryString["AgentName"]; } if (Session["ConsignmentId"] != null) { LblRefNo.Text = Session["ConsignmentId"].ToString(); Lblrefno1.Text = Session["ConsignmentId"].ToString(); } BindCountryList(); MailRemarkGridBind(); FillPaxGrid(); BtnConsignmentUpdate.Visible = false; if (Request.QueryString["ConsignmentId"] != null) { BtnConsignmentUpdate.Visible = true; BtnConsignmentSave.Visible = false; ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); //Btnupdate.Visible = true; int id = Convert.ToInt32(Request.QueryString["ConsignmentId"]); List <Consignment> lst = consignBal.ReadDataByConsignmentId(id); //DrpdnVisaCountry.SelectedItem.Text = lst[0].CountryName.ToString(); //txtSubmDate.Text = lst[0].CgSubmissionDate.ToString(); // txtChkDate.Text = lst[0].CgCheckOnDate.ToString(); //txtTravlDate.Text = lst[0].CgTravelDates.ToString(); txtGroup.Text = lst[0].CgGroupRep.ToString(); TxtInstruction.Text = lst[0].CgInstruction.ToString(); txtRemark.Text = lst[0].CgRemarks.ToString(); //ChckbxCollctd.Text = lst[0].CG_COLLECTED; // ChckbxBlnkColDate.Text = lst[0].CG_BLANK_COLLECTION_DATE; // ChckbxDisabl.Text = lst[0].CG_DISABLE; // ChckbxBlankSubDate.Text = lst[0].CG_BLANK_SUBMISSION_DATE; txtAreaCod.Text = lst[0].CgAreaCode; //consignment.CG_TRANSFER_TO = DrpdnTransfer.SelectedItem.Text; txtNoPassport.Text = lst[0].CgNoOfPass.ToString(); txtNoDD.Text = lst[0].CgNoOfDD.ToString(); txtEnterdBy.Text = lst[0].CgEnteredBy; txtSntName.Text = lst[0].CgSentBy; txtCorporate.Text = lst[0].CgCorporate; txtmob.Text = lst[0].CgMobNo; txtEmail.Text = lst[0].CgAspMail; //showTable.Visible = true; } } }
protected void Wizard1_NextButtonClick(object sender, WizardNavigationEventArgs e) { ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); Consignment consignment = new Consignment(); string othrCountry = null; consignment.FkAgentId = Convert.ToInt32(Request.QueryString["AgentID"]); consignment.CgVisaCountry = Convert.ToInt32(DrpdnVisaCountry.SelectedItem.Value); Session["CountryId"] = Convert.ToInt32(DrpdnVisaCountry.SelectedItem.Value); foreach (ListItem item in LstSelectedCountry.Items) { othrCountry += item.Text + ","; } consignment.CgOtherCountries = othrCountry; consignment.CgSubmissionDate = (txtSubmDate.Text); consignment.CgCheckOnDate = (txtChkDate.Text); consignment.CgTravelDates = (txtTravlDate.Text); consignment.CG_COLLECTION_DATE = (txtTravlDate.Text); consignment.CgGroupRep = txtGroup.Text; consignment.CgInstruction = TxtInstruction.Text; consignment.CgRemarks = txtRemark.Text; consignment.CG_COLLECTED = ChckbxCollctd.Text = ""; consignment.CG_BLANK_COLLECTION_DATE = ChckbxBlnkColDate.Text = ""; if (ChckbxDisabl.Checked == true) { consignment.CG_DISABLE = ChckbxDisabl.Text = "Y"; } else { consignment.CG_DISABLE = ChckbxDisabl.Text = "N"; } consignment.CG_BLANK_SUBMISSION_DATE = ChckbxBlankSubDate.Text = ""; consignment.CgAreaCode = txtAreaCod.Text; //consignment.CG_TRANSFER_TO = DrpdnTransfer.SelectedItem.Text; consignment.CgNoOfPass = Convert.ToInt32(txtNoPassport.Text); consignment.CgNoOfDD = Convert.ToInt32(txtNoDD.Text); consignment.CgEnteredBy = txtEnterdBy.Text; consignment.CgSentBy = txtSntName.Text; consignment.CgCorporate = txtCorporate.Text; consignment.CgMobNo = txtmob.Text; consignment.CG_EMAIL = txtEmail.Text; // Session["ObjConsinment"] = consignment; //int ID = consignBal.CreateConsignment(consignment); //Consignment lstConsign = new Consignment(); List <MailRemark> lstMailRemarks = new List <MailRemark>(); foreach (ListItem item in LstSelectedCountry.Items) { //int consignmentId = Convert.ToInt32(Session["ConsignmentId"]); MailRemark mailRemark = new MailRemark(); //mailRemark.ConsignmentId = consignmentId; mailRemark.CountryName = item.Text; mailRemark.CountryId = Convert.ToInt32(item.Value); mailRemark.SubmissionDate = DateTime.Now; mailRemark.CollectionDate = DateTime.Now; mailRemark.CheckOnDate = DateTime.Now; lstMailRemarks.Add(mailRemark); } // lstMailRemark = lstMailRemarks; consignment.MailRemarksDetails = lstMailRemarks; Session["listconsign"] = consignment; if (Session["listconsign"] != null) { MailRemarkGridBind(); } List <Pax> lstPaxDetails = new List <Pax>(); // lstConsign.PaxDetails = lstPaxDetails; //Session["Pax"]= // ScriptManager.RegisterClientScriptBlock(BtnConsignmentSave, GetType(), "test", "alert('Consignment Add successfully!!!')", true); }
protected void BtnConsignmentSave_Click(object sender, EventArgs e) { ConsignmentBusinessAccess consignBal = new ConsignmentBusinessAccess(); Consignment consignment = new Consignment(); string othrCountry = null; consignment.FkAgentId = Convert.ToInt32(Request.QueryString["AgentID"]); consignment.CgVisaCountry = Convert.ToInt32(DrpdnVisaCountry.SelectedItem.Value); Session["CountryId"] = Convert.ToInt32(DrpdnVisaCountry.SelectedItem.Value); foreach (ListItem item in LstSelectedCountry.Items) { othrCountry += item.Text + ","; } consignment.CgOtherCountries = othrCountry; consignment.CgSubmissionDate = (txtSubmDate.Text); consignment.CgCheckOnDate = (txtChkDate.Text); consignment.CgTravelDates = (txtTravlDate.Text); consignment.CG_COLLECTION_DATE = (txtTravlDate.Text); consignment.CgGroupRep = txtGroup.Text; consignment.CgInstruction = TxtInstruction.Text; consignment.CgRemarks = txtRemark.Text; consignment.CG_COLLECTED = ChckbxCollctd.Text = ""; consignment.CG_BLANK_COLLECTION_DATE = ChckbxBlnkColDate.Text = ""; if (ChckbxDisabl.Checked == true) { consignment.CG_DISABLE = ChckbxDisabl.Text = "Y"; } else { consignment.CG_DISABLE = ChckbxDisabl.Text = "N"; } consignment.CG_BLANK_SUBMISSION_DATE = ChckbxBlankSubDate.Text = ""; consignment.CgAreaCode = txtAreaCod.Text; consignment.CgNoOfPass = Convert.ToInt32(txtNoPassport.Text); consignment.CgNoOfDD = Convert.ToInt32(txtNoDD.Text); consignment.CgEnteredBy = txtEnterdBy.Text; consignment.CgSentBy = txtSntName.Text; consignment.CgCorporate = txtCorporate.Text; consignment.CgMobNo = txtmob.Text; consignment.CG_EMAIL = txtEmail.Text; //Session["ObjConsinment"] = consignment; int consgnmentId = consignBal.CreateConsignment(consignment); Session["ConsignmentId"] = consgnmentId; List <Consignment> lstConsign = new List <Consignment>(); foreach (ListItem item in LstSelectedCountry.Items) { int consignmentId = Convert.ToInt32(Session["ConsignmentId"]); Consignment consign = new Consignment(); consign.ConsignmentId = consignmentId; consign.CountryName = item.Text; consign.Country_Id = Convert.ToInt32(item.Value); consign.CgSubmissionDate = DateTime.Now.ToString("dd/MM/yyyy"); consign.CG_COLLECTION_DATE = DateTime.Now.ToString("dd/MM/yyyy"); consign.CgCheckOnDate = DateTime.Now.ToString("dd/MM/yyyy"); lstConsign.Add(consign); } Session["listconsign"] = lstConsign; ScriptManager.RegisterClientScriptBlock(BtnConsignmentSave, GetType(), "test", "alert('Consignment Add successfully!!!')", true); Response.Redirect("AddConsignment.aspx"); }