public static List <string> invoicenumber(string prefixText2) { DataLayer.DAL dl = new DataLayer.DAL(); string queryfetchconsul2 = "Select distinct inv_no from mis_lumpsum_milestones_fin_progress where inv_no ilike '%" + prefixText2 + "%' "; DataTable dt2 = dl.executeGetData(queryfetchconsul2); List <string> CountryNames2 = new List <string>(); for (int i = 0; i < dt2.Rows.Count; i++) { CountryNames2.Add(dt2.Rows[i]["inv_no"].ToString()); } return(CountryNames2); }
public static List <string> GetListofCountries(string prefixText) { DataLayer.DAL dl = new DataLayer.DAL(); string queryfetchconsul = "Select distinct project_name from mis_projects_master where project_name ilike '%" + prefixText + "%' "; DataTable dt = dl.executeGetData(queryfetchconsul); List <string> CountryNames = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { CountryNames.Add(dt.Rows[i]["project_name"].ToString()); } return(CountryNames); }
public static List <string> refrencenumber(string prefixText1) { DataLayer.DAL dl = new DataLayer.DAL(); string queryfetchconsul1 = "Select distinct ref_number from mis_project_details where ref_number ilike '%" + prefixText1 + "%' "; DataTable dt1 = dl.executeGetData(queryfetchconsul1); List <string> CountryNames1 = new List <string>(); for (int i = 0; i < dt1.Rows.Count; i++) { CountryNames1.Add(dt1.Rows[i]["ref_number"].ToString()); } return(CountryNames1); }