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);
}
