public string GetNetworkpath(string drivename) { objmst = new MasterData(); DataTable dt = new DataTable(); dt = objmst.GetLookupList("folderpath"); if (dt.Rows.Count > 1) { dt = dt.Select("lkup_desc like '" + drivename + "%'").CopyToDataTable(); } return dt.Rows[0]["lkup_desc"].ToString().Split('|').GetValue(1).ToString(); }
public void grdfill() { try { string id = this.ID; vslist.ValidationGroup = id; switch (id) { case "lst_scheduletype": group = "scheduletype"; break; case "lst_pricescalestatus": group = "pricescalestatus"; break; case "lst_contractstatus": group = "contractstatus"; break; case "lst_offerstatus": group = "offerstatus"; break; case "lst_expensestatus": group = "expensestatus"; break; case "lst_memostatus": group = "memostatus"; break; case "lst_engagementstatus": group = "engagementstatus"; break; case "lst_employeetype": group = "employeetype"; break; case "lst_employeestatus": group = "employeestatus"; break; case "lst_Dealothers": group = "DealOthers"; break; case "lst_LocalOthers": group = "localdocumentedothers"; break; //case "lst_DocumentOthers": // group = "localdocumentedothers"; // break; } dtlookup.Clear(); dtlookup = new DataTable(); objData = new MasterData(); dtlookup = objData.GetLookupList(group); if (dtlookup.Rows.Count > 0) { grdLookup.DataSource = dtlookup; grdLookup.DataBind(); } else { foreach (DataColumn cl in dtlookup.Columns) { cl.AllowDBNull = true; } dtlookup.Rows.Add(dtlookup.NewRow()); grdLookup.DataSource = dtlookup; grdLookup.DataBind(); int columncount = grdLookup.Rows[0].Cells.Count; grdLookup.Rows[0].Cells.Clear(); grdLookup.Rows[0].Cells.Add(new TableCell()); grdLookup.Rows[0].Cells[0].ColumnSpan = columncount - 2; grdLookup.Rows[0].Cells[0].Text = "No Records Found"; grdLookup.Columns[columncount - 2].Visible = false; } DropDownList ddltype = grdLookup.FooterRow.FindControl("ddllkup_group") as DropDownList; switchddl(ddltype); //<asp:ListItem Value="scheduletype|30" Text="Engagement Schedule Type"></asp:ListItem> // <asp:ListItem Value="pricescalestatus|10" Text="Engagement Pricescale Status"></asp:ListItem> // <asp:ListItem Value="contractstatus|10" Text="Engagement Contract Status"></asp:ListItem> // <asp:ListItem Value="offerstatus|10" Text="Engagement Offer Status"></asp:ListItem> // <asp:ListItem Value="expensestatus|15" Text="Engagement Expense Status"></asp:ListItem> // <asp:ListItem Value="memostatus|10" Text="Engagement Memo Status"></asp:ListItem> // <asp:ListItem Value="engagementstatus|10" Text="Engagement Engagement Status"></asp:ListItem> grdLookup.FooterRow.Visible = true; } catch (Exception ex) { throw ex; } }
protected void RepDetails_ItemDataBound(object sender, RepeaterItemEventArgs e) { CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; TextInfo textInfo = cultureInfo.TextInfo; if (e.Item.ItemType == ListItemType.Footer) { MasterData objmst = new MasterData(); ddlscheduletype.DataSource = objmst.GetLookupList("scheduletype"); ddlscheduletype.DataTextField = "lkup_desc"; ddlscheduletype.DataBind(); int CurrentIndex = ddlscheduletype.Items.IndexOf(ddlscheduletype.Items.FindByText(hdfPerf.Value)); ddlscheduletype.Items.Insert(0, new ListItem { Value = "0", Text = "--Select--", Selected = true }); if ((CurrentIndex + 2) != ddlscheduletype.Items.Count) { ddlscheduletype.SelectedIndex = CurrentIndex + 2; } string schdate = System.DateTime.Now.ToString("MM/dd/yyyy"); if (!string.IsNullOrEmpty(hdn_schnextdate.Value)) { schdate = Convert.ToDateTime(hdn_schnextdate.Value, CultureInfo.CurrentUICulture.DateTimeFormat).AddDays(1).ToString("MM/dd/yyyy"); } txtscheduedate.Text = schdate; lblscheduleday.Text = textInfo.ToTitleCase(Convert.ToDateTime(txtscheduedate.Text, CultureInfo.CurrentUICulture.DateTimeFormat).DayOfWeek.ToString().Substring(0, 3)); } }
protected void RepDetails_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.ToLower() == "cancel") { bindScheduleDetails(engagementid); } if (e.CommandName.ToLower() == "edit") { e.Item.FindControl("tredit").Visible = true; DropDownList ddlscheduletypeE = (DropDownList)e.Item.FindControl("ddlscheduletypeE"); HiddenField hdnscheduletypeE = (HiddenField)e.Item.FindControl("hdnscheduletypeE"); MasterData objmst = new MasterData(); ddlscheduletypeE.DataSource = objmst.GetLookupList("scheduletype"); ddlscheduletypeE.DataTextField = "lkup_desc"; ddlscheduletypeE.DataBind(); ddlscheduletypeE.SelectedIndex = ddlscheduletypeE.Items.IndexOf(ddlscheduletypeE.Items.FindByText(hdnscheduletypeE.Value)); e.Item.FindControl("tr_crow").Visible = false; } if (e.CommandName.ToLower() == "update") { UpdateSchedule(e.Item); } trfooter.Visible = false; }
protected void fillemployeetype() { MasterData objmsd = new MasterData(); DataTable dt = new DataTable(); dt = objmsd.GetLookupList("employeetype"); objcf.Fillddl_noselect(ddlemployeetype, dt, "lkup_desc", "lkup_id"); dt = objmsd.GetLookupList("employeestatus"); objcf.Fillddl_noselect(ddlemployeestatus, dt, "lkup_desc", "lkup_id"); string def_status = ""; if (dt.Select("lkup_desc='active'").Length > 0) { def_status = dt.Select("lkup_desc='active'").CopyToDataTable().Rows[0]["lkup_desc"].ToString(); } ddlemployeestatus.SelectedIndex = ddlemployeestatus.Items.IndexOf(ddlemployeestatus.Items.FindByText(def_status)); }