public List <OrganizeUnit> GetUnit()
{
List <OrganizeUnit> OU = new List <OrganizeUnit>();
SqlConnection con = null;
try
{
con = connect("DBConnectionString");
String selectSTR = "SELECT * FROM OrganizeUnit_2020";
SqlCommand cmd = new SqlCommand(selectSTR, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
OrganizeUnit Unit = new OrganizeUnit();
Unit.Id = Convert.ToInt32(dr["UnitId"]);
Unit.Unitname = (string)dr["UnitName"];
OU.Add(Unit);
}
return(OU);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void GetApartmentId(OrganizeUnit unit)
{
int id = 0;
SqlConnection con = null;
try
{
con = connect("DBConnectionString");
String selectSTR = "select * from Apartment_2020 where ApartmentTypeId is null";
SqlCommand cmd1 = new SqlCommand(selectSTR, con);
SqlDataReader dr = cmd1.ExecuteReader(CommandBehavior.CloseConnection);
dr.Read();
id = Convert.ToInt32(dr["UnitId"]);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
UpdateApartmentType(unit.ApartmentType1, id);
}
private String BuildInsertCommand(OrganizeUnit unit)
{
String command;
StringBuilder sb = new StringBuilder();
string G = unit.Numofguides.ToString();
string R = unit.Numofresidents.ToString();
sb.AppendFormat("Values('{0}', '{1}','{2}', '{3}','{4}','{5}')", unit.Unitname, unit.Numofresidents, unit.Numofguides, unit.City, unit.Street_hnumber, unit.Unittype);
String prefix = "INSERT INTO OrganizeUnit_2020" + "(UnitName,NumOfResidents,NumOfGuides,City,Street_HNumber,UnitType)";
command = prefix + sb.ToString();
return(command);
}
public void PostUnit(OrganizeUnit unit)
{
SqlConnection con;
SqlCommand cmd;
try
{
con = connect("DBConnectionString"); // create the connection
}
catch (Exception ex)
{
throw (ex);
}
String cStr = BuildInsertCommand(unit);
cmd = CreateCommand(cStr, con);
try
{
int numEffected = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
if (unit.Unittype == "דירה")
{
GetApartmentId(unit);
}
}
// POST api/<controller>
public void Post([FromBody] OrganizeUnit unit)
{
unit.PostUnit();
}
// GET api/<controller>
public List <OrganizeUnit> Get()
{
OrganizeUnit OU = new OrganizeUnit();
return(OU.GetOrganizeUnit());
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] OrganizeUnit unit)
{
OrganizeUnit u = new OrganizeUnit();
u.PutOrganizeUnit(unit);
}
