protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         lblMessage.Text = "";
         string DeptCode = ddlDepartment.SelectedValue.ToString();
         LoadEmployeeList(DeptCode);
         DateTime date = DateTime.Today;
         date             = DateTime.Parse(txtDate.Text);
         txtChalanNo.Text = ic.GetNewReturnChalanNo(DeptCode, date, "DPT");
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
     }
 }
        //private void FillSupplierToReturn(string storeCode)
        //{
        //    var supplierList = ic.GetSupplierListToReturnStoreWise(storeCode);

        //    if (supplierList.Rows.Count > 0)
        //    {
        //        ddlSupplierTo.DataSource = supplierList;
        //        ddlSupplierTo.DataValueField = "SupplierCode";
        //        ddlSupplierTo.DataTextField = "SupplierName";
        //        ddlSupplierTo.DataBind();
        //        ddlSupplierTo.Items.Insert(0, new ListItem("Select One", "0"));
        //    }
        //    else
        //    {
        //        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No supplier found!')", true);
        //    }
        //}

        private void GetNewChallanNo(DateTime day)
        {
            txtChalanNoReturn.Text = ic.GetNewReturnChalanNo(((SessionUser)Session["SessionUser"]).OCode, day, "DPT");
        }