public void Bind_DDL_Zone() { DDLZone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), "Zone"); DDLZone.DataBind(); DDLZone.Items.Insert(0, new ListItem("-Select Zone-", "0")); }
protected void BtnGetDCDetails_Click(object sender, EventArgs e) { String cd = ""; ModalPopUpDocNum.Hide(); Session["tempDCData"] = null; int DocNum = Convert.ToInt32(ddldocno.SelectedValue); // bool condition = false; cd = "1"; DataSet ds = DCMaster.Get_DCMasterBy_DocNum(DocNum, "1"); DataTable dt = ds.Tables[0]; DataTable dtzone = ds.Tables[2]; cd = "2"; if (dt.Rows.Count > 0) { txtdocnew.Text = dt.Rows[0]["DocumentNo_New"].ToString(); txtdoc.Text = dt.Rows[0]["DocumentNo"].ToString(); txtchalan.Text = dt.Rows[0]["ChallanNo"].ToString(); txtChalDate.Text = dt.Rows[0]["ChallanDate"].ToString(); txtorder.Text = dt.Rows[0]["OrderNo"].ToString(); txtcustomer.Text = dt.Rows[0]["CustCode"].ToString(); lblCustName.Text = dt.Rows[0]["CustName"].ToString(); DDlemployee.Items.Clear(); cd = "3"; try { DDlemployee.DataSource = DCMaster.Get_Employee_By_Customer_Code(txtcustomer.Text.ToString(), "Employee"); DDlemployee.DataBind(); cd = "4"; if (DDlemployee.Items.Count > 0) { DDlemployee.SelectedValue = dt.Rows[0]["SalesmanCode"].ToString(); cd = "5"; DDlemployee.SelectedItem.Text = dt.Rows[0]["SalesmanName"].ToString(); cd = "6"; } txtOrdDate.Text = dt.Rows[0]["OrderDate"].ToString(); txtdocDate.Text = dt.Rows[0]["DocumentDate"].ToString(); txtpIncharge.Text = dt.Rows[0]["PIncharge"].ToString(); txtspInstruct.Text = dt.Rows[0]["SpInstruction"].ToString(); txtbankdet.Text = dt.Rows[0]["BankCode"].ToString(); lblbankname.Text = dt.Rows[0]["BankName"].ToString(); cd = "7"; //Extra Zone Code Bind if (dtzone.Rows.Count > 0) { lblZoneCode.Visible = true; DDLZone.Visible = true; DDLZone.Items.Clear(); DDLZone.DataSource = ds.Tables[2]; DDLZone.DataBind(); if (dt.Rows[0]["ExtraZoneCode"].ToString() != "") { //DDLZone.SelectedValue = dt.Rows[0]["ExtraZoneCode"].ToString(); } } else { DDLZone.Items.Clear(); lblZoneCode.Visible = false; DDLZone.Visible = false; } txtDeliverydte.Text = Convert.ToDateTime(DCMaster.Get_DCMasterBy_DocNum(DocNum, "0").Tables[1].Rows[0]["DeliveryDate"].ToString()).ToString("dd/MM/yyyy"); UpdatePanel14.Update(); } catch (Exception ex) { MessageBox(cd); //Response.Write(ex.Message.ToString()); } // Bind_DDL_Transport(); // Ddltransport.SelectedValue = dt.Rows[0]["TransportID"].ToString(); if (dt.Rows[0]["TransporterCode"].ToString() == "Trans") { lbltransporter.Visible = false; lbltransporter.Text = dt.Rows[0]["TransporterCode"].ToString(); txttransporter.Text = dt.Rows[0]["Transporter"].ToString(); } else { txttransporter.Text = dt.Rows[0]["TransporterCode"].ToString(); lbltransporter.Visible = true; lbltransporter.Text = dt.Rows[0]["Transporter"].ToString(); } //DataSet ds = new DataSet(); // ds = SpecimanDetails.GetSpecimenDatilsByEmpCode(Convert.ToString(DocNum), "documentno"); DataTable dt1 = new DataTable(); if (Session["tempDCData"] != null) { Session["tempDCData"] = fillTempBookData(DocNum.ToString(), "get"); dt1 = (DataTable)Session["tempDCData"]; } else { Session["tempDCData"] = fillTempBookData(DocNum.ToString(), "get"); dt1 = (DataTable)Session["tempDCData"]; } grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); grdBookDetails.Columns[5].Visible = true; grdBookDetails.Columns[4].Visible = true; btn_Save.Visible = true; //DataTable dt3 = new DataTable(); //dt3 = ds.Tables[0]; //Session["tempDCData"] = dt3; grdBookDetails.Visible = true; // btn_Save.Visible = false; } else { message("Record not found for document no. " + TxtDocNo.Text); ModalPopUpDocNum.Show(); TxtDocNo.Text = ""; TxtDocNo.Focus(); btn_Save.Visible = false; } }