//protected void txtsalemanCode_TextChanged(object sender, EventArgs e) //{ // string ECode = txtsalemanCode.Text.ToString().Split(':')[0].Trim(); // DataTable dt = new DataTable(); // dt = DCMaster.Get_Name(ECode, "Employee").Tables[0]; // if (dt.Rows.Count != 0) // { // txtsalemanCode.Text = ECode; // lblSalesManName.Text = dt.Rows[0]["FirstName"] + " " + dt.Rows[0]["MiddleName"] + " " + dt.Rows[0]["LastName"]; // txtpIncharge.Focus(); // } // else // { // lblSalesManName.Text = "No such salesman code"; // txtsalemanCode.Focus(); // txtsalemanCode.Text = ""; // } //} protected void txtcustomer_TextChanged(object sender, EventArgs e) { string CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); if (dt.Rows[0]["State"].ToString().ToLower() == "maharashtra") { srate = "l"; } else { srate = "m"; } //txtsalemanCode.Focus(); ACExttransporter.ContextKey = CustCode; DDlemployee.DataSource = DCMaster.Get_Employee_By_Customer_Code(CustCode, "Employee"); DDlemployee.DataBind(); DDlemployee.Items.Insert(0, new ListItem("-Select-", "0")); DDlemployee.Focus(); // Bind_DDL_Transport(); } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; srate = ""; } }
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; } }