//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;
}
}
