public static DataTable ExecuteReader(Model mdl) { DataTable dt = new DataTable(); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString())) { cn.Open(); SqlCommand cm = new SqlCommand(mdl.StoreProcedureName.ToString(), cn); cm.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in cm.Parameters) { if (p.Direction == ParameterDirection.Input || p.Direction == ParameterDirection.InputOutput) { foreach (PropertyInfo pi in mdl.GetType().GetProperties()) { if (p.ParameterName.ToLower().Replace("@", "") == pi.Name.ToLower()) { p.Value = FormatObject(p, pi.GetValue(mdl, null)); break; } } } } dt.Load(cm.ExecuteReader()); } return dt; }
public DataTable InsertUser(object JobID) { Model mdl = new Model(); mdl.StoreProcedureName = "InsertUser"; mdl.JobID = JobID; return SqlServer.ExecuteReader(mdl); }
public DataTable JobDetails1(Object JobID) { Model mdl = new Model(); mdl.StoreProcedureName = "JobDetails"; mdl.JobID = JobID; return SqlServer.ExecuteReader(mdl); }
public DataTable FillSearch(object JobTitle, object JobDescription, object FirstName, object LastName) { Model mdl = new Model(); mdl.StoreProcedureName = "FillSearch"; mdl.JobTitle = JobTitle; mdl.JobDescription = JobDescription; mdl.FirstName = FirstName; mdl.LastName = LastName; return SqlServer.ExecuteReader(mdl); }
public DataTable SearchUsers(object JobID, object FirstName, object LastName, object JobTitle, object JobDescription) { Model mdl = new Model(); mdl.StoreProcedureName = "SearchUsers"; mdl.JobID = JobID; mdl.FirstName = FirstName; mdl.LastName = LastName; mdl.JobTitle = JobTitle; mdl.JobDescription = JobDescription; return SqlServer.ExecuteReader(mdl); }