Example #1
0
        private void GetDateSIR()
        {
            DataSet dsSIR = new DataSet();

            try
            {
                if (ddlSirNo.SelectedIndex != 0)
                {
                    SqlParameter[] param =
                    {
                        new SqlParameter("@DealerCode", SqlDbType.Char),
                        new SqlParameter("@SIRNO",      SqlDbType.Char)
                    };

                    param[0].Value = Session["DealerCode"].ToString();
                    param[1].Value = ddlSirNo.SelectedValue.ToString();
                    dsSIR          = SysFunc.SP_Parts_Get_SIRDataGetForStockIssue(param);

                    if (Convert.ToString(dsSIR.Tables[0].Rows[0]["Requsitioner"]) == "J")
                    {
                        lblSource.Text   = "Job Card #";
                        txtJC_CS_No.Text = dsSIR.Tables[0].Rows[0]["JobCardNO"].ToString();
                    }
                    else if (Convert.ToString(dsSIR.Tables[0].Rows[0]["Requsitioner"]) == "C")
                    {
                        lblSource.Text   = "Counter Sale #";
                        txtJC_CS_No.Text = dsSIR.Tables[0].Rows[0]["InvoiceNO"].ToString();
                    }
                    txtSource.Text  = dsSIR.Tables[0].Rows[0]["Requsitioner"].ToString();
                    txtSIRDate.Text = dsSIR.Tables[0].Rows[0]["SIRDate"].ToString();
                    txtRemarks.Focus();
                }
            }
            catch (Exception ex)
            {
                LbErr.Text = ex.Message;
            }
        }