//public Equipment(string ausstatType,string[] controlValues)
//{
// InitializeComponent();
// AddTypes();
// cbAusstattungstyp.SelectedItem = ausstatType;
// AddChildUserControl(controlValues);
//}
public Equipment(string equipId, string ausstatType)
{
InitializeComponent();
if (Application.Current.Properties["CopyRowStatus"].ToString() == "No")
{
getEquipId = equipId;
}
else
{
getEquipId = null;
}
AddTypes();
cbAusstattungstyp.SelectedItem = ausstatType;
string query = "select * from [as_" + ausstatType + "] where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "' and id=" + equipId + "";
DataTable dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
Application.Current.Properties["CadId"] = dt.Rows[0][2].ToString();
}
else
{
Application.Current.Properties["CadId"] = "";
}
AddChildUserControl(dt);
}
public UserControlSonnenschutz(DataTable controlValues)
{
InitializeComponent();
string query = "select * from code_sonnenschutztyp";
DataTable dt = DataConnection.GetData(query);
cbtype.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbtype.Items.Add(dt.Rows[i][1].ToString());
}
if (cbtype.Items.Count > 0)
{
if (controlValues != null)
{
cbtype.SelectedItem = controlValues.Rows[0][5].ToString();
}
}
query = "select * from code_lage";
dt = DataConnection.GetData(query);
cbLage.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbLage.Items.Add(dt.Rows[i][1].ToString());
}
if (cbLage.Items.Count > 0)
{
if (controlValues != null)
{
cbLage.SelectedItem = controlValues.Rows[0][6].ToString();
}
}
}
private void Cbflachemax_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbflachemax.SelectedItem.ToString().StartsWith("NUF"))
{
string query = "select id,value from DIN277_NUF" + cbflachemax.SelectedItem.ToString().Substring(4, 1);
DataTable dtResult = DataConnection.GetData(query);
cbntzumax.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
cbntzumax.Items.Add(dtResult.Rows[i][0].ToString() + " " + dtResult.Rows[i][1].ToString());
}
}
else if (cbflachemax.SelectedItem.ToString().StartsWith("TF"))
{
string query = "select id,value from DIN277_TF";
DataTable dtResult = DataConnection.GetData(query);
cbntzumax.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
cbntzumax.Items.Add(dtResult.Rows[i][0].ToString() + " " + dtResult.Rows[i][1].ToString());
}
}
else if (cbflachemax.SelectedItem.ToString().StartsWith("VF"))
{
string query = "select id,value from DIN277_VF";
DataTable dtResult = DataConnection.GetData(query);
cbntzumax.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
cbntzumax.Items.Add(dtResult.Rows[i][0].ToString() + " " + dtResult.Rows[i][1].ToString());
}
}
}
private void FillEquipments()
{
lbEquipments.Items.Clear();
string query = "select * from as_bodenbelag where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
DataTable dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "bodenbelag " + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString());
}
query = "select * from as_fenster where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "fenster" + " (" + dt.Rows[0][8].ToString() + "x" + dt.Rows[0][9].ToString() + ")," + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString() + "," + dt.Rows[0][7].ToString() + "," + dt.Rows[0][10].ToString() + "," + dt.Rows[0][11].ToString());
}
query = "select * from as_feuerloescher where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "feuerloescher " + dt.Rows[0][5].ToString());
}
query = "select * from [as_glasbau-element] where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "glasbau-element " + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString() + "," + dt.Rows[0][7].ToString());
}
query = "select * from as_leuchte where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "leuchte " + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString() + "," + dt.Rows[0][7].ToString() + "," + dt.Rows[0][8].ToString());
}
query = "select * from as_oberlicht where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "oberlicht " + "(" + dt.Rows[0][5].ToString() + "x" + dt.Rows[0][6].ToString() + ")");
}
query = "select * from as_sonnenschutz where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "sonnenschutz " + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString());
}
query = "select * from as_tor where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "tor" + " (" + dt.Rows[0][7].ToString() + "x" + dt.Rows[0][6].ToString() + ")," + dt.Rows[0][5].ToString() + "," + dt.Rows[0][8].ToString());
}
query = "select * from as_tuer where gebaeude_id=" + Application.Current.Properties["BuildingId"] + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and raum_id='" + Application.Current.Properties["CadId"] + "'";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
lbEquipments.Items.Add("EquipId " + dt.Rows[0][3].ToString() + ": " + "tuer" + " (" + dt.Rows[0][7].ToString() + "x" + dt.Rows[0][8].ToString() + ")," + dt.Rows[0][5].ToString() + "," + dt.Rows[0][6].ToString() + "," + dt.Rows[0][9].ToString() + "," + dt.Rows[0][10].ToString() + "," + dt.Rows[0][11].ToString());
}
}
private void FillBuildingList()
{
string query = "select geb_id from kl_gebaeude";
DataTable dtResult = DataConnection.GetData(query);
lbDisplayBuilding.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
lbDisplayBuilding.Items.Add(dtResult.Rows[i][0].ToString());
}
}
private void FillRoomsByLevelAndBuilding()
{
info.Content = "";
string query = "select cad_id from kl_raum where geb_id=" + lbDisplayBuilding.SelectedItem + " and geschoss_id='" + lbDisplayLevels.SelectedValue + "'";
DataTable dtResult = DataConnection.GetData(query);
lbDisplayRooms.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
lbDisplayRooms.Items.Add(dtResult.Rows[i][0].ToString());
}
Application.Current.Properties["LevelId"] = lbDisplayLevels.SelectedItem;
}
private void LbDisplayBuilding_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
info.Content = "";
string query = "select geschoss_id,cad_id from kl_raum where geb_id=" + lbDisplayBuilding.SelectedItem + "";
DataTable dtResult = DataConnection.GetData(query);
lbDisplayLevels.Items.Clear();
lbDisplayRooms.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
lbDisplayLevels.Items.Add(dtResult.Rows[i][0].ToString());
}
Application.Current.Properties["BuildingId"] = lbDisplayBuilding.SelectedItem;
}
public UserControlLeuchtentyp(DataTable controlValues)
{
InitializeComponent();
string query = "select * from code_leuchtentyp";
DataTable dt = DataConnection.GetData(query);
cbLeuchtentyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbLeuchtentyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbLeuchtentyp.Items.Count > 0)
{
if (controlValues != null)
{
cbLeuchtentyp.SelectedItem = controlValues.Rows[0][5].ToString();
}
}
query = "select * from code_leuchtmitteltyp";
dt = DataConnection.GetData(query);
cbLeuchtmitteltyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbLeuchtmitteltyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbLeuchtmitteltyp.Items.Count > 0)
{
if (controlValues != null)
{
cbLeuchtmitteltyp.SelectedItem = controlValues.Rows[0][6].ToString();;
}
}
query = "select * from code_montage";
dt = DataConnection.GetData(query);
cbMontage.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbMontage.Items.Add(dt.Rows[i][1].ToString());
}
if (cbMontage.Items.Count > 0)
{
if (controlValues != null)
{
cbMontage.SelectedItem = controlValues.Rows[0][8].ToString();;
txtAnzahlleuchtmittel.Text = controlValues.Rows[0][7].ToString();;
}
}
}
private void LbDisplayRooms_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (lbDisplayRooms.SelectedItem != null)
{
string query = "select * from kl_raum where geb_id=" + lbDisplayBuilding.SelectedItem + " and geschoss_id='" + lbDisplayLevels.SelectedItem + "' and cad_id='" + lbDisplayRooms.SelectedItem + "'";
DataTable dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
info.Content = "Raum-Nr:" + dt.Rows[0][4].ToString() + "\n" + "Flaeche:" + dt.Rows[0][8].ToString() + " m\u00b2" + "\n" + "Lichte Hohe:" + dt.Rows[0][9].ToString() + " m" + "\n" + "Anz. A.P:" + dt.Rows[0][10].ToString() + "\n" + "Anz. M.A:" + dt.Rows[0][11].ToString() + "\n" + "zustand sch:" + dt.Rows[0][12].ToString() + "\n" + "Bemerkung:" + dt.Rows[0][13].ToString() + "\n" + "Umfang [m]:" + dt.Rows[0][14].ToString() + " m" + "\n" + "Anz. Heizho:" + dt.Rows[0][16].ToString() + "\n" + "Anz. Patchsc:" + dt.Rows[0][18].ToString() + "\n" + "Bezeichnug:" + dt.Rows[0][5].ToString() + "\n" + "MAX:" + dt.Rows[0][6].ToString() + "\n" + "IST:" + dt.Rows[0][7].ToString();
}
else
{
info.Content = "\n\n\n" + "No Data Available";
}
}
}
public UserControlFeuerloeschertyp(DataTable controlValues)
{
InitializeComponent();
string query = "select * from code_feuerloeschertyp";
DataTable dt = DataConnection.GetData(query);
cbFeuerloeschertyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFeuerloeschertyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbFeuerloeschertyp.Items.Count > 0)
{
if (controlValues != null)
{
cbFeuerloeschertyp.SelectedItem = controlValues.Rows[0][5].ToString();
}
}
}
public UserControlBodenblagType(string[] controlValues)
{
InitializeComponent();
string query = "select * from code_bodenbelagtyp";
DataTable dt = DataConnection.GetData(query);
cbBodenbelagtyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbBodenbelagtyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbBodenbelagtyp.Items.Count > 0)
{
if (controlValues != null && controlValues.Length == 2)
{
cbBodenbelagtyp.SelectedItem = controlValues[0].ToString().Split(' ')[1];
txtFlaeche.Text = controlValues[1];
}
}
}
private void BtnEditRoom_Click(object sender, RoutedEventArgs e)
{
if (lbDisplayRooms.SelectedItem != null)
{
string query = "select * from kl_raum where geb_id=" + lbDisplayBuilding.SelectedValue + " and geschoss_id='" + Application.Current.Properties["LevelId"] + "' and cad_id='" + lbDisplayRooms.SelectedValue + "'";
DataTable dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
//DataTable selectedTable = dt.AsEnumerable()
// .Where(r => r.Field<int>("gebaeude_id") ==Convert.ToInt32(lbDisplayBuilding.SelectedValue) && r.Field<string>("geschoss_id")==lbDisplayLevels.SelectedValue.ToString() && r.Field<int>("cad_id")==Convert.ToInt32(lbDisplayRooms.SelectedValue))
// .CopyToDataTable();
AddNewRoom newRoom = new AddNewRoom(lbDisplayRooms.SelectedItem.ToString(), dt, "EditRoom");
newRoom.ShowDialog();
info.Content = AddNewRoom.Info;
}
}
else
{
MessageBox.Show("Select room");
}
}
public UserControlBodenblagType(DataTable dtControlValues)
{
InitializeComponent();
string query = "select * from code_bodenbelagtyp";
DataTable dt = DataConnection.GetData(query);
cbBodenbelagtyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbBodenbelagtyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbBodenbelagtyp.Items.Count > 0)
{
if (dtControlValues != null)
{
cbBodenbelagtyp.SelectedItem = dtControlValues.Rows[0][5].ToString();
txtFlaeche.Text = dtControlValues.Rows[0][6].ToString();
getEqupId = dtControlValues.Rows[0][3].ToString();
}
}
}
public AddNewLevel()
{
InitializeComponent();
string query = "select geb_id from kl_gebaeude";
DataTable dtResult = DataConnection.GetData(query);
selectFloorList = new ArrayList();
selectFloorList.Add("UG4:00");
selectFloorList.Add("UG3:01");
selectFloorList.Add("UG2:02");
selectFloorList.Add("UG1:03");
selectFloorList.Add("EG:04");
for (int i = 1; i <= 25; i++)
{
if ((4 + i) <= 9)
{
selectFloorList.Add("OG" + i + ":0" + (4 + i) + "");
}
else
{
selectFloorList.Add("OG" + i + ":" + (4 + i) + "");
}
}
selectFloorList.Add("UG4Z:30");
selectFloorList.Add("UG3Z:31");
selectFloorList.Add("UG2Z:32");
selectFloorList.Add("UG1Z:33");
selectFloorList.Add("EGZ:34");
for (int i = 1; i <= 25; i++)
{
selectFloorList.Add("OG" + i + "Z:" + (34 + i) + "");
}
//for (int i = 0; i < dtResult.Rows.Count; i++)
//{
// selectFloorList.Add(dtResult.Rows[i][0].ToString());
//}
cbSelectYesOrNo.Items.Clear();
cbSelectYesOrNo.Items.Add("Yes");
cbSelectYesOrNo.Items.Add("No");
}
public UserControlGlasbauType(DataTable controlValues)
{
UpdateChildGetSet = false;
InitializeComponent();
string query = "select * from code_glasbauelementtyp";
DataTable dt = DataConnection.GetData(query);
cbGlasbauType.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbGlasbauType.Items.Add(dt.Rows[i][1].ToString());
}
if (cbGlasbauType.Items.Count > 0)
{
if (controlValues != null)
{
cbGlasbauType.SelectedItem = controlValues.Rows[0][5].ToString();
txtGlasflaecheeinseitig.Text = controlValues.Rows[0][6].ToString();
txtReinigungsflaechen.Text = controlValues.Rows[0][7].ToString();
}
}
}
public UserControlTor(DataTable controlValues)
{
InitializeComponent();
string query = "select * from code_tortyp";
DataTable dt = DataConnection.GetData(query);
cbTortyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbTortyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbTortyp.Items.Count > 0)
{
if (controlValues != null)
{
cbTortyp.SelectedItem = controlValues.Rows[0][5].ToString();
}
}
query = "select * from code_antrieb";
dt = DataConnection.GetData(query);
cbAntrieb.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbAntrieb.Items.Add(dt.Rows[i][1].ToString());
}
if (cbTortyp.Items.Count > 0)
{
if (controlValues != null)
{
cbTortyp.SelectedItem = controlValues.Rows[0][8].ToString();
}
}
if (controlValues != null)
{
txtHohe.Text = controlValues.Rows[0][6].ToString();
txtBreite.Text = controlValues.Rows[0][7].ToString();
}
}
private void BtnNewRoom_Click(object sender, RoutedEventArgs e)
{
if (lbDisplayLevels.SelectedItem != null)
{
string level = lbDisplayLevels.SelectedItem.ToString();
string query = "select top 1 cad_id from kl_raum where geb_id=" + lbDisplayBuilding.SelectedItem + " and geschoss_id='" + lbDisplayLevels.SelectedValue + "' order by cad_id desc";
DataTable dtResult = DataConnection.GetData(query);
if (dtResult != null && dtResult.Rows.Count > 0)
{
if (dtResult.Rows[0][0].ToString() != "" || dtResult.Rows[0][0] != null)
{
string getRoom = dtResult.Rows[0][0].ToString().Substring(2, dtResult.Rows[0][0].ToString().Length - 2).ToString();
if (getRoom.StartsWith("000"))
{
getRoom = "001";
}
else if (getRoom.StartsWith("00"))
{
getRoom = getRoom.Substring(2, 1).ToString();
int value = Int32.Parse(getRoom) + 1;
if (value == 10)
{
getRoom = "0" + value.ToString();
}
else
{
getRoom = "00" + value.ToString();
}
}
else if (getRoom.StartsWith("0"))
{
getRoom = getRoom.Substring(1, 2).ToString();
int value = Int32.Parse(getRoom) + 1;
if (value == 100)
{
getRoom = value.ToString();
}
else
{
getRoom = "0" + value.ToString();
}
}
else
{
}
string[] levels = level.Split(':');
if (levels.Length == 2)
{
Application.Current.Properties["CadId"] = levels[1] + getRoom;
AddNewRoom newRoom = new AddNewRoom(lbDisplayBuilding.SelectedItem.ToString(), lbDisplayLevels.SelectedItem.ToString(), levels[1] + getRoom, "NewRoom");
newRoom.ShowDialog();
info.Content = AddNewRoom.Info;
lbDisplayRooms.Items.Add(levels[1] + getRoom);
}
}
}
else
{
string[] levels = level.Split(':');
if (levels.Length == 2)
{
Application.Current.Properties["CadId"] = levels[1] + "000";
AddNewRoom newRoom = new AddNewRoom(lbDisplayBuilding.SelectedItem.ToString(), lbDisplayLevels.SelectedItem.ToString(), levels[1] + "000", "NewRoom");
newRoom.ShowDialog();
info.Content = AddNewRoom.Info;
lbDisplayRooms.Items.Add(levels[1] + "000");
}
}
}
else
{
MessageBox.Show("Select levels");
}
}
private void Btnsaveandclose_Click(object sender, RoutedEventArgs e)
{
string gasabsperrsch = "N";
string heizungabsperr = "N";
string Hydrant = "N";
string schukostdose = "N";
string sprinkler = "N";
string telnetzdose = "N";
string wasserabsperr = "N";
if (chkgasabsperrsch.IsChecked == true)
{
gasabsperrsch = "Y";
}
if (chkheizungabsperr.IsChecked == true)
{
heizungabsperr = "Y";
}
if (chkHydrant.IsChecked == true)
{
Hydrant = "Y";
}
if (chkschukostdose.IsChecked == true)
{
schukostdose = "Y";
}
if (chksprinkler.IsChecked == true)
{
sprinkler = "Y";
}
if (chktelnetzdose.IsChecked == true)
{
telnetzdose = "Y";
}
if (chkwasserabsperr.IsChecked == true)
{
wasserabsperr = "Y";
}
if (EditRoomId == 0)
{
int id = 1;
string query = "select top 1 id from kl_raum order by id desc";
DataTable dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "")
{
id = Int32.Parse(dt.Rows[0][0].ToString()) + 1;
}
}
query = "insert into kl_raum values(" + id + "," + Building + ",'" + Level + "','" + CadId + "','" + txtraum.Text + "','" + Bezeichnug + "','" + Max + "','" + IST + "'," + txtflaeche.Text + "," + txtLichte.Text + "," + txtAnzap.Text + "," + txtAnzma.Text + ",'" + cbzustand.SelectionBoxItem + "','" + txtbemerku.Text + "'," + txtumfang.Text + "," + chkschukostdose.IsChecked + "," + txtanzheizho.Text + "," + chktelnetzdose.IsChecked + "," + txtanzpatchsc.Text + "," + chksprinkler.IsChecked + "," + chkgasabsperrsch.IsChecked + "," + chkwasserabsperr.IsChecked + "," + chkheizungabsperr.IsChecked + "," + chkHydrant.IsChecked + ")";
string msg = DataConnection.ExecuteQuery(query);
if (msg == "Executed")
{
RoomAddOrEdit = "";
saveStatus = "yes";
MessageBox.Show("Saved Successfully");
Info = "Raum-Nr:" + txtraum.Text + "\n" + "Flaeche:" + txtflaeche.Text + " m\u00b2" + "\n" + "Lichte Hohe:" + txtLichte.Text + " m" + "\n" + "Anz. A.P:" + txtAnzap.Text + "\n" + "Anz. M.A:" + txtAnzma.Text + "\n" + "zustand sch:" + cbzustand.SelectedValue + "\n" + "Bemerkung:" + txtbemerku.Text + "\n" + "Umfang [m]:" + txtumfang.Text + " m" + "\n" + "Anz. Heizho:" + txtanzheizho.Text + "\n" + "Anz. Patchsc:" + txtanzpatchsc.Text + "\n" + "Bezeichnug:" + Bezeichnug + "\n" + "MAX:" + Max + "\n" + "IST:" + IST;
this.Close();
}
else
{
MessageBox.Show("Please enter correct input fields");
}
}
else
{
string query = "update kl_raum set raumnummer='" + txtraum.Text + "' , raumbezeichnung='" + Bezeichnug + "' , DIN277_max='" + Max + "' , DIN277_ist='" + IST + "' , raumflaeche=" + txtflaeche.Text + " , lichte_raumhoehe=" + txtLichte.Text + " , anzahl_arbeitsplaetze=" + txtAnzap.Text + " , anzahl_mitarbeiter=" + txtAnzma.Text + " , bemerkung='" + txtbemerku.Text + "' , umfang=" + txtumfang.Text + " , schukosteckdose=" + chkschukostdose.IsChecked + " , anzahl_heizkoerper=" + txtanzheizho.Text + " , telefon_netzwerkdose=" + chktelnetzdose.IsChecked + " , anzahl_patschraenke=" + txtanzpatchsc.Text + " , sprinkler=" + chksprinkler.IsChecked + " , gasabsperrschieber=" + chkgasabsperrsch.IsChecked + " , wasserabsperrschieber=" + chkwasserabsperr.IsChecked + " , heizungsabsperrschieber=" + chkheizungabsperr.IsChecked + " , hydrant=" + chkHydrant.IsChecked + " where id=" + EditRoomId + "";
string msg = DataConnection.ExecuteQuery(query);
if (msg == "Executed")
{
RoomAddOrEdit = "";
saveStatus = "yes";
MessageBox.Show("Saved Successfully");
Info = "Raum-Nr:" + txtraum.Text + "\n" + "Flaeche:" + txtflaeche.Text + " m\u00b2" + "\n" + "Lichte Hohe:" + txtLichte.Text + " m" + "\n" + "Anz. A.P:" + txtAnzap.Text + "\n" + "Anz. M.A:" + txtAnzma.Text + "\n" + "zustand sch:" + cbzustand.SelectedValue + "\n" + "Bemerkung:" + txtbemerku.Text + "\n" + "Umfang [m]:" + txtumfang.Text + " m" + "\n" + "Anz. Heizho:" + txtanzheizho.Text + "\n" + "Anz. Patchsc:" + txtanzpatchsc.Text + "\n" + "Bezeichnug:" + Bezeichnug + "\n" + "MAX:" + Max + "\n" + "IST:" + IST;
this.Close();
}
else
{
MessageBox.Show("Please enter correct input fields");
}
}
}
private void BtnSaveFileExport_Click(object sender, RoutedEventArgs e)
{
//using (var dialog = new System.Windows.Forms.FolderBrowserDialog())
//{
//System.Windows.Forms.DialogResult result = dialog.ShowDialog();
//MessageBox.Show(dialog.SelectedPath);
if (folderPath != "")
{
string query = "select * from kl_raum";
DataTable dt = DataConnection.GetData(query);
string txt = string.Empty;
FileStream fileStream = new FileStream("" + folderPath + "\\raumbuch.txt", FileMode.Create);
TextWriter sw = new StreamWriter(fileStream);
foreach (DataColumn column in dt.Columns)
{
//Add the Header row for Text file.
txt += column.ColumnName + "\t";
}
//Add new line.
txt += "\r\n";
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn column in dt.Columns)
{
//Add the Data rows.
txt += row[column.ColumnName].ToString() + "\t";
}
//Add new line.
txt += "\r\n";
}
sw.Write(txt);
sw.Close();
fileStream.Close();
Process.Start(folderPath + "\\raumbuch.txt", "notepad.exe");
query = "select geb_id,geschoss_id,cad_id from kl_raum";
dt = DataConnection.GetData(query);
int fileRowId = 1;
if (dt != null && dt.Rows.Count > 0)
{
txt = string.Empty;
fileStream = new FileStream("" + folderPath + "\\ausstattungu.txt", FileMode.Create);
sw = new StreamWriter(fileStream);
string[] columns = new string[24];
columns[0] = "Laufende Nr";
columns[1] = "Gebäude";
columns[2] = "Geschoss";
columns[3] = "CAD-ID";
columns[4] = "Ausstattungstyp";
columns[5] = "Att1";
columns[6] = "Att_Typ2";
columns[7] = "Att2";
columns[8] = "Att_Typ3";
columns[9] = "Att3";
columns[10] = "Att_Typ4";
columns[11] = "Att4";
columns[12] = "Att_Typ5";
columns[13] = "Att5";
columns[14] = "Att_Typ6";
columns[15] = "Att6";
columns[16] = "Att_Typ7";
columns[17] = "Att7";
columns[18] = "Att_Typ8";
columns[19] = "Att8";
columns[20] = "Att_Typ9";
columns[21] = "Att9";
columns[22] = "Att_Typ10";
columns[23] = "Att10";
for (int i = 0; i < columns.Length; i++)
{
//Add the Header row for Text file.
txt += columns[i] + "\t";
}
//Add new line.
txt += "\r\n";
//}
sw.Write(txt);
txt = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
//as_bodenbelag
query = "select * from as_bodenbelag where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtBodenbelag = DataConnection.GetData(query);
if (dtBodenbelag != null && dtBodenbelag.Rows.Count > 0)
{
for (int j = 0; j < dtBodenbelag.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "bodenbelag" + "\t" + dtBodenbelag.Rows[j][5].ToString() + "\t" + "flaeche" + "\t" + dtBodenbelag.Rows[j][6].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_fenster
query = "select * from as_fenster where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtfenster = DataConnection.GetData(query);
if (dtfenster != null && dtfenster.Rows.Count > 0)
{
for (int j = 0; j < dtfenster.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "fenster" + "\t" + dtfenster.Rows[j][5].ToString() + "\t" + "fensterrahmenmaterial" + "\t" + dtfenster.Rows[j][6].ToString() + "\t" + "verglasung" + "\t" + dtfenster.Rows[j][7].ToString() + "\t" + "breite" + "\t" + dtfenster.Rows[j][8].ToString() + "\t" + "hoehe" + "\t" + dtfenster.Rows[j][9].ToString() + "\t" + "feststellanlage" + "\t" + dtfenster.Rows[j][10].ToString() + "\t" + "tuernummer" + "\t" + dtfenster.Rows[j][11].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_feuerloescher
query = "select * from as_feuerloescher where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable as_feuerloescher = DataConnection.GetData(query);
if (as_feuerloescher != null && as_feuerloescher.Rows.Count > 0)
{
for (int j = 0; j < as_feuerloescher.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "feuerloescher" + "\t" + as_feuerloescher.Rows[j][5].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_glasbau-element
query = "select * from [as_glasbau-element] where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtglasbauelement = DataConnection.GetData(query);
if (dtglasbauelement != null && dtglasbauelement.Rows.Count > 0)
{
for (int j = 0; j < dtglasbauelement.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "glasbau-element" + "\t" + dtglasbauelement.Rows[j][5].ToString() + "\t" + "glasflaeche einseitig" + "\t" + dtglasbauelement.Rows[j][6].ToString() + "\t" + "reinigungsflaechen" + "\t" + dtglasbauelement.Rows[j][7].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_leuchte
query = "select * from as_leuchte where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtleuchte = DataConnection.GetData(query);
if (dtleuchte != null && dtleuchte.Rows.Count > 0)
{
for (int j = 0; j < dtleuchte.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "leuchte" + "\t" + dtleuchte.Rows[j][5].ToString() + "\t" + "leuchtmitteltyp" + "\t" + dtleuchte.Rows[j][6].ToString() + "\t" + "anzahl leuchtmittel" + "\t" + dtleuchte.Rows[j][7].ToString() + "\t" + "montage" + "\t" + dtleuchte.Rows[j][8].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_oberlicht
query = "select * from as_oberlicht where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtoberlicht = DataConnection.GetData(query);
if (dtoberlicht != null && dtoberlicht.Rows.Count > 0)
{
for (int j = 0; j < dtoberlicht.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "breite" + "\t" + dtoberlicht.Rows[j][5].ToString() + "\t" + "hoehe" + "\t" + dtoberlicht.Rows[j][6].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_sonnenschutz
query = "select * from as_sonnenschutz where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dtsonnenschutz = DataConnection.GetData(query);
if (dtsonnenschutz != null && dtsonnenschutz.Rows.Count > 0)
{
for (int j = 0; j < dtsonnenschutz.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "sonnenschutz" + "\t" + dtsonnenschutz.Rows[j][5].ToString() + "\t" + "lage" + "\t" + dtsonnenschutz.Rows[j][6].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_tor
query = "select * from as_tor where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dttor = DataConnection.GetData(query);
if (dttor != null && dttor.Rows.Count > 0)
{
for (int j = 0; j < dttor.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "tor" + "\t" + dttor.Rows[j][5].ToString() + "\t" + "breite" + "\t" + dttor.Rows[j][6].ToString() + "\t" + "hoehe" + "\t" + dttor.Rows[j][7].ToString() + "\t" + "antrieb" + "\t" + dttor.Rows[j][8].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
//as_bodenbelag
query = "select * from as_tuer where gebaeude_id=" + dt.Rows[i][0].ToString() + " and geschoss_id='" + dt.Rows[i][1].ToString() + "'";
DataTable dttuer = DataConnection.GetData(query);
if (dttuer != null && dttuer.Rows.Count > 0)
{
for (int j = 0; j < dttuer.Rows.Count; j++)
{
txt += fileRowId + "\t" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + "tuer" + "\t" + dttuer.Rows[j][5].ToString() + "\t" + "türblattmaterial" + "\t" + dttuer.Rows[j][6].ToString() + "\t" + "hoehe" + "\t" + dttuer.Rows[j][7].ToString() + "\t" + "breite" + "\t" + dttuer.Rows[j][8].ToString() + "\t" + "glasflaeche einseitig" + "\t" + dttuer.Rows[j][9].ToString() + "\t" + "antrieb" + "\t" + dttuer.Rows[j][10].ToString();
txt += "\r\n";
sw.Write(txt);
fileRowId = fileRowId + 1;
txt = "";
}
}
}
sw.Close();
fileStream.Close();
Process.Start(folderPath + "\\ausstattungu.txt", "notepad.exe");
}
//File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\file2.txt", "" + folderPath + "\\file2.txt");
//Process.Start(folderPath + "\\file1.txt", "notepad.exe");
//Process.Start(folderPath + "\\file2.txt", "notepad.exe");
}
else
{
MessageBox.Show("Select folder to save file");
}
//}
}
public UserControlFensterType(string[] controlValues)
{
InitializeComponent();
//cbFeststellanlage.Items.Clear();
//cbFeststellanlage.Items.Add("Test");
string query = "select * from code_fenstertyp";
DataTable dt = DataConnection.GetData(query);
cbFenstertyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFenstertyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbFenstertyp.Items.Count > 0)
{
if (controlValues != null)
{
cbFenstertyp.SelectedItem = controlValues[1];
}
}
query = "select * from code_fensterrahmenmaterial";
dt = DataConnection.GetData(query);
cbFensterrahmenmaterial.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFensterrahmenmaterial.Items.Add(dt.Rows[i][1].ToString());
}
if (cbFensterrahmenmaterial.Items.Count > 0)
{
if (controlValues != null)
{
cbFensterrahmenmaterial.SelectedItem = controlValues[2];
}
}
query = "select * from code_verglasung";
dt = DataConnection.GetData(query);
cbVerglasung.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbVerglasung.Items.Add(dt.Rows[i][1].ToString());
}
if (cbVerglasung.Items.Count > 0)
{
if (controlValues != null)
{
cbVerglasung.SelectedItem = controlValues[3];
}
}
if (controlValues != null)
{
string[] heightwidth = controlValues[0].ToString().Split(' ')[1].ToString().Split('x');
txtHohe.Text = heightwidth[0].ToString().Replace("(", "");
txtBreite.Text = heightwidth[1].ToString().Replace(")", "");
//cbFeststellanlage.SelectedItem = controlValues[4];
if (controlValues[4].ToString() != "")
{
if (controlValues[4].ToString() == "Y")
{
rbYes.IsChecked = true;
rbNo.IsChecked = false;
}
else
{
rbNo.IsChecked = true;
rbYes.IsChecked = false;
}
}
txtTuernummer.Text = controlValues[5];
}
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
string msg = string.Empty;
if (Equipment.getEquipId == null)
{
string query = "select top 1 id from as_tuer order by id desc";
DataTable dt = DataConnection.GetData(query);
int id = 1;
if (dt != null && dt.Rows.Count > 0)
{
id = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
query = "insert into as_tuer values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbTürtyp.SelectedValue + "','" + cbTürblattmaterial.SelectedValue + "','" + txtBreite.Text + "','" + txtHohe.Text + "','" + cbTuerzargenmaterial.SelectedValue + "','" + cbAntrieb.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
else if (dt != null && dt.Rows.Count >= 1)
{
int status = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() != "")
{
id = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
query = "insert into as_tuer values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbTürtyp.SelectedValue + "','" + cbTürblattmaterial.SelectedValue + "','" + txtBreite.Text + "','" + txtHohe.Text + "','" + cbTuerzargenmaterial.SelectedValue + "','" + cbAntrieb.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
status = 1;
break;
}
}
if (status == 0)
{
query = "insert into as_tuer values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbTürtyp.SelectedValue + "','" + cbTürblattmaterial.SelectedValue + "','" + txtBreite.Text + "','" + txtHohe.Text + "','" + cbTuerzargenmaterial.SelectedValue + "','" + cbAntrieb.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
}
else
{
query = "insert into as_tuer values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbTürtyp.SelectedValue + "','" + cbTürblattmaterial.SelectedValue + "','" + txtBreite.Text + "','" + txtHohe.Text + "','" + cbTuerzargenmaterial.SelectedValue + "','" + cbAntrieb.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
if (msg == "Executed")
{
query = "select top 1 id from as_tuer order by id desc";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
UpdateChildGetSet = true;
SelectChildTypeValues = "EquipId " + dt.Rows[0][0].ToString() + ": " + "tuer" + " (" + txtHohe.Text + "x" + txtBreite.Text + ")," + cbTürtyp.SelectedValue + "," + cbTürblattmaterial.SelectedValue + "," + cbTuerzargenmaterial.SelectedValue + "," + txtGlasflaeche.Text + "," + cbAntrieb.SelectedValue;
//var myWindow =
Window.GetWindow(this).Close();
}
}
else
{
MessageBox.Show("Please enter correct input values");
}
}
else
{
string updatedcolumns = "türtyp='" + cbTürtyp.SelectedValue + "' , breite='" + txtBreite.Text + "' , hoehe='" + txtHohe.Text + "' , türblattmaterial='" + cbTürblattmaterial.SelectedValue + "' , [glasflaeche einseitig]='" + txtGlasflaeche.Text + "' , antrieb='" + cbAntrieb.SelectedValue + "'";
msg = EquipmentData.UpdateEquipment("as_tuer", updatedcolumns, Equipment.getEquipId);
if (msg == "Executed")
{
UpdateChildGetSet = true;
SelectChildTypeValues = "EquipId " + Equipment.getEquipId + ": " + "tuer" + " (" + txtHohe.Text + "x" + txtBreite.Text + ")," + cbTürtyp.SelectedValue + "," + cbTürblattmaterial.SelectedValue + "," + cbTuerzargenmaterial.SelectedValue + "," + txtGlasflaeche.Text + "," + cbAntrieb.SelectedValue;
Window.GetWindow(this).Close();
}
else
{
MessageBox.Show("Please enter correct input values");
}
}
}
public UserControlTuer(DataTable controlValues)
{
InitializeComponent();
string query = "select * from code_tuertyp";
DataTable dt = DataConnection.GetData(query);
cbTürtyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbTürtyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbTürtyp.Items.Count > 0)
{
if (controlValues != null)
{
cbTürtyp.SelectedItem = controlValues.Rows[0][5].ToString();
}
}
query = "select * from code_tuerblattmaterial";
dt = DataConnection.GetData(query);
cbTürblattmaterial.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbTürblattmaterial.Items.Add(dt.Rows[i][1].ToString());
}
if (cbTürblattmaterial.Items.Count > 0)
{
if (controlValues != null)
{
cbTürblattmaterial.SelectedItem = controlValues.Rows[0][6].ToString();
}
}
query = "select * from code_tuerzargenmaterial";
dt = DataConnection.GetData(query);
cbTuerzargenmaterial.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbTuerzargenmaterial.Items.Add(dt.Rows[i][1].ToString());
}
//if (cbTuerzargenmaterial.Items.Count > 0)
//{
// if (controlValues != null)
// cbTuerzargenmaterial.SelectedItem = controlValues[3];
//}
query = "select * from code_antrieb";
dt = DataConnection.GetData(query);
cbAntrieb.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbAntrieb.Items.Add(dt.Rows[i][1].ToString());
}
if (cbAntrieb.Items.Count > 0)
{
if (controlValues != null)
{
cbAntrieb.SelectedItem = controlValues.Rows[0][10].ToString();
txtGlasflaeche.Text = controlValues.Rows[0][9].ToString();
txtHohe.Text = controlValues.Rows[0][7].ToString();
txtBreite.Text = controlValues.Rows[0][8].ToString();
}
}
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
string msg = string.Empty;
if (Equipment.getEquipId == null)
{
string query = "select top 1 id from as_sonnenschutz order by id desc";
DataTable dt = DataConnection.GetData(query);
int id = 1;
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "")
{
id = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
}
query = "insert into as_sonnenschutz values(" + Application.Current.Properties["BuildingId"] + ",'" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbtype.SelectedValue + "','" + cbLage.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
else if (dt != null && dt.Rows.Count >= 1)
{
int status = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() != "")
{
id = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
query = "insert into as_sonnenschutz values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbtype.SelectedValue + "','" + cbLage.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
status = 1;
break;
}
}
if (status == 0)
{
query = "insert into as_sonnenschutz values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbtype.SelectedValue + "','" + cbLage.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
}
else
{
query = "insert into as_sonnenschutz values('" + Application.Current.Properties["BuildingId"] + "','" + Application.Current.Properties["LevelId"] + "','" + Application.Current.Properties["CadId"] + "'," + id + ",'','" + cbtype.SelectedValue + "','" + cbLage.SelectedValue + "')";
msg = DataConnection.ExecuteQuery(query);
}
if (msg == "Executed")
{
query = "select top 1 id from as_sonnenschutz order by id desc";
dt = DataConnection.GetData(query);
if (dt != null && dt.Rows.Count > 0)
{
UpdateChildGetSet = true;
SelectChildTypeValues = "EquipId " + dt.Rows[0][0].ToString() + ": " + "sonnenschutz " + cbtype.SelectedValue + "," + cbLage.SelectedValue;
//var myWindow =
Window.GetWindow(this).Close();
}
}
else
{
MessageBox.Show("Please enter correct input values");
}
}
else
{
string updatedcolumns = "sonnenschutztyp='" + cbtype.SelectedValue + "' , lage='" + cbLage.SelectedValue + "'";
msg = EquipmentData.UpdateEquipment("as_sonnenschutz", updatedcolumns, Equipment.getEquipId);
if (msg == "Executed")
{
UpdateChildGetSet = true;
SelectChildTypeValues = "EquipId " + Equipment.getEquipId + ": " + "sonnenschutz " + cbtype.SelectedValue + "," + cbLage.SelectedValue;
Window.GetWindow(this).Close();
}
else
{
MessageBox.Show("Please enter correct input values");
}
}
}
public UserControlFensterType(DataTable dtControlValues)
{
InitializeComponent();
//cbFeststellanlage.Items.Clear();
//cbFeststellanlage.Items.Add("Test");
string query = "select * from code_fenstertyp";
DataTable dt = DataConnection.GetData(query);
cbFenstertyp.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFenstertyp.Items.Add(dt.Rows[i][1].ToString());
}
if (cbFenstertyp.Items.Count > 0)
{
if (dtControlValues != null)
{
cbFenstertyp.SelectedItem = dtControlValues.Rows[0][5].ToString();
}
}
query = "select * from code_fensterrahmenmaterial";
dt = DataConnection.GetData(query);
cbFensterrahmenmaterial.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbFensterrahmenmaterial.Items.Add(dt.Rows[i][1].ToString());
}
if (cbFensterrahmenmaterial.Items.Count > 0)
{
if (dtControlValues != null)
{
cbFensterrahmenmaterial.SelectedItem = dtControlValues.Rows[0][6].ToString();
}
}
query = "select * from code_verglasung";
dt = DataConnection.GetData(query);
cbVerglasung.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbVerglasung.Items.Add(dt.Rows[i][1].ToString());
}
if (cbVerglasung.Items.Count > 0)
{
if (dtControlValues != null)
{
cbVerglasung.SelectedItem = dtControlValues.Rows[0][7].ToString();
}
}
if (dtControlValues != null)
{
txtHohe.Text = dtControlValues.Rows[0][8].ToString();
txtBreite.Text = dtControlValues.Rows[0][9].ToString();
//cbFeststellanlage.SelectedItem = controlValues[4];
//if (controlValues[4].ToString() != "")
//{
// if (controlValues[4].ToString() == "Y")
// {
// rbYes.IsChecked = true;
// rbNo.IsChecked = false;
// }
// else
// {
// rbNo.IsChecked = true;
// rbYes.IsChecked = false;
// }
//}
txtTuernummer.Text = dtControlValues.Rows[0][11].ToString();
}
}