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");
}
