private void FillCatagoryRepeater() { DataTable dt = NumberSeriesManager.getAllCatagory(); repeaterCatagory.DataSource = dt; repeaterCatagory.DataBind(); }
private void FillJobCatagory() { DataTable dt = NumberSeriesManager.getAllCatagory(); dropdownJobCatagory.DataSource = dt; dropdownJobCatagory.DataTextField = "SeriesName"; dropdownJobCatagory.DataValueField = "SeriesName"; dropdownJobCatagory.DataBind(); }
private void FillDeptDorpDown() { DataTable dt = NumberSeriesManager.getAllCatagory(); DeptDorpDown.DataSource = dt; DeptDorpDown.DataTextField = "SeriesName"; DeptDorpDown.DataValueField = "SeriesName"; DeptDorpDown.DataBind(); DeptDorpDown.Items.Insert(0, "All"); }
private void UpdateCode() { seriesName = dropdownJobCatagory.SelectedValue; string companyName = ""; DataTable seriesDT = NumberSeriesManager.GetDataBySeriesName(seriesName, companyName); int lastGenNumber = int.Parse(seriesDT.Rows[0]["LastGeneratedNo"].ToString()); currentNo = lastGenNumber + 1; NumberSeriesManager.UpdateSerialNo(seriesName, currentNo, companyName); }
private void GenerateCode() { preFix = ""; prefixHF = SKprefixHF.Value; curNoHF = SKcurNoHF.Value; string companyName = ""; DataTable seriesDT = NumberSeriesManager.GetDataBySeriesName(seriesName, companyName); for (int i = 0; i < seriesDT.Rows.Count; i++) { preFix = seriesDT.Rows[i]["PreFix"].ToString(); } lblJobCode.Text = NumberSeriesManager.GenerateNumberSeries(companyName, seriesName, preFix, prefixHF, curNoHF); }
protected void btnNewCatagory_Click(object sender, EventArgs e) { string SeriesName = txtNwCatagory.Text; int SeriesLength = 5; string Prefix = SeriesName.Substring(0, 2); int LastGeneratedNo = 0; string CatIcon = txtCatagoryIcon.Text; int insert = NumberSeriesManager.InsertNewCatagory(SeriesName, SeriesLength, Prefix, LastGeneratedNo, CatIcon); if (insert != 0) { txtNwCatagory.Text = ""; FillJobCatagory(); } }