public static SqlDataBaseOjectHandler GlobalPerformQuery(string query) { SqlDataBaseOjectHandler handler = new SqlDataBaseOjectHandler(); try { SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn()); SqlConnectionClass.getConn().Open(); System.Data.ConnectionState state = SqlConnectionClass.getConn().State; if (!(state == System.Data.ConnectionState.Open)) { Helper_Classes_namespace.ErrorMessages.setErrorMessage(" Sorry no Db Connection !!!!!!! ", true); handler.hasErrors = true; return(handler); } command.ExecuteNonQuery(); handler.reader = command.ExecuteReader(); } catch (System.Exception em) { Helper_Classes_namespace.ErrorMessages.setErrorMessage(em.ToString(), true); handler.hasErrors = true; } return(handler); }
public void Delete(int id) { const string sql = "delete from [dbo].Model where Id = @Id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@Id", id); SqlConnectionClass.ExecuteNonQuery(sql, parameters, System.Data.CommandType.Text); }
public List <Model> GetModelsByMakerId(int Id) { const string sql = "select * from [dbo].Model where MakeId = @Id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@Id", Id); var result = SqlConnectionClass.GetList <Model>(sql, parameters, dr => MapModelObject(dr)); return(result); }
public Object Insert(Model model) { const string sql = "Insert into [dbo].Model (ModelName, MakeId) values (@modelName, @makeId)SELECT SCOPE_IDENTITY()"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@modelName", model.ModelName); parameters.Add("@makeId", model.MakeId); var result = SqlConnectionClass.ExecuteScalar(sql, parameters); return(result); }
public SqlCommand PerformQuery(string query) { SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn()); SqlConnectionClass.getConn().Open(); System.Data.ConnectionState state = SqlConnectionClass.getConn().State; if (!(state == System.Data.ConnectionState.Open)) { MessageBox.Show(" Sorry no Db Connection !!!!!!! "); return(null); } return(command); }
public static void ClosePerformQuery() { SqlConnectionClass.getConn().Close(); }
public static void SettingDbConnection(String connectionString) { SqlConnectionClass.setConn(connectionString); }
public void Post([FromBody] DataHandler data) { repo = new SqlConnectionClass(); repo.AddToTable(data); }
public ActionResult <List <AppointmentSlot> > Get(int id) { repo = new SqlConnectionClass(); repo.Read(); return(repo.data); }