public AlarmTarihce()
{
Cihaz = new Cihaz();
alarm = new CihazAlarmTanimi();
}
public virtual void NewAlarmTarihce(CihazAlarmTanimi tanim, CihazAdres alarmadres)
{
AlarmTarihce = new mymodel.AlarmTarihce();
AlarmTarihce.Cihaz.Id = this.Cihaz.Id;
AlarmTarihce.Alarm.Id = tanim.Id;
AlarmTarihce.AlarmAdres = alarmadres;
}
protected override void Save()
{
UpdateEntityData();
Transaction.Instance.Join(delegate()
{
base.Save();
string cihaztagadresId = string.Empty;
string alarmtanimId = string.Empty;
long Id = 0;
foreach (DataRow rw in Adresler.Rows)
{
if(rw["Id"]!=null && rw["Id"]!=System.DBNull.Value)
Id = Convert.ToInt64(rw["Id"]);
else
Id = 0;
CihazAdres chz;
if (Id == 0)
{
chz = new CihazAdres();
chz.Cihaz.Id = infoformentity.Id;
chz.Adres.Id = Convert.ToInt64(Current.IsNull(rw["Adres_Id"],0));
chz.AdresTipi = (mymodel.myenum.AdresTipi)Enum.Parse(typeof(mymodel.myenum.AdresTipi), Current.IsNull(rw["AdresTipi"],"").ToString());
chz.Davranis = (mymodel.myenum.Davranis)Enum.Parse(typeof(mymodel.myenum.Davranis),Current.IsNull(rw["Davranis"],"").ToString());
chz.Formul = Current.IsNull(rw["Formul"],"").ToString();
chz.IsLogTutulsun = bool.Parse(Current.IsNull(rw["IsLogTutulsun"],false).ToString());
chz.Insert();
}
else
{
chz = Persistence.Read<CihazAdres>(Id);
chz.Cihaz.Id = infoformentity.Id;
chz.Adres.Id = Convert.ToInt64(Current.IsNull(rw["Adres_Id"],0));
chz.AdresTipi = (mymodel.myenum.AdresTipi)Enum.Parse(typeof(mymodel.myenum.AdresTipi), Current.IsNull(rw["AdresTipi"],"").ToString());
chz.Davranis = (mymodel.myenum.Davranis)Enum.Parse(typeof(mymodel.myenum.Davranis), Current.IsNull(rw["Davranis"],"").ToString());
chz.Formul = Current.IsNull(rw["Formul"],"").ToString();
chz.IsLogTutulsun = bool.Parse(Current.IsNull(rw["IsLogTutulsun"],false).ToString());
chz.Update();
}
cihaztagadresId += chz.Id + ",";
}
foreach (DataRow rw1 in AlarmAdresleri.Rows)
{
if(rw1["Id"]!=null && rw1["Id"]!=System.DBNull.Value)
Id = Convert.ToInt64(rw1["Id"]);
else
Id = 0;
CihazAdres chz = null;
if (Id == 0)
{
chz = new CihazAdres();
chz.Cihaz.Id = infoformentity.Id;
chz.Adres.Id = Convert.ToInt64(Current.IsNull(rw1["Adres_Id"],0));
chz.AdresTipi = myenum.AdresTipi.AlarmAdresi; ;
chz.Davranis = myenum.Davranis.Oku;
chz.Formul = Current.IsNull(rw1["Formul"],"").ToString();
chz.IsLogTutulsun = bool.Parse(Current.IsNull(rw1["IsLogTutulsun"],false).ToString());
chz.Insert();
}
else
{
chz = Persistence.Read<CihazAdres>(Id);
chz.Cihaz.Id = infoformentity.Id;
chz.Adres.Id = Convert.ToInt64(Current.IsNull(rw1["Adres_Id"],0));
chz.AdresTipi = myenum.AdresTipi.AlarmAdresi; ;
chz.Davranis = myenum.Davranis.Oku;
chz.Formul = Current.IsNull(rw1["Formul"],"").ToString();
chz.IsLogTutulsun = bool.Parse(Current.IsNull(rw1["IsLogTutulsun"],false).ToString());
chz.Update();
}
cihaztagadresId += chz.Id + ",";
Id = 0;
if (rw1["Id1"] != null && rw1["Id1"] != System.DBNull.Value)
Id = Convert.ToInt64(rw1["Id1"]);
else
Id = 0;
CihazAlarmTanimi alarmtanimi;
if (Id == 0)
{
alarmtanimi = new CihazAlarmTanimi();
alarmtanimi.Cihaz.Id = infoformentity.Id;
alarmtanimi.CihazAdres.Id = chz.Id;
alarmtanimi.AlarmTipi = (mymodel.myenum.AlarmTipi)Enum.Parse(typeof(mymodel.myenum.AlarmTipi), Current.IsNull(rw1["AlarmTipi"],false).ToString());
alarmtanimi.AlarmMesaji = rw1["AlarmMesaji"].ToString();
alarmtanimi.DataTipi = (mymodel.myenum.MappedFieldType)Enum.Parse(typeof(mymodel.myenum.MappedFieldType), Current.IsNull(rw1["DataTipi1"],false).ToString());
alarmtanimi.IsLogTutulsun = bool.Parse(Current.IsNull(rw1["IsLogTutulsun1"],false).ToString());
alarmtanimi.SesAcik = bool.Parse(Current.IsNull(rw1["SesAcik"], false).ToString());
alarmtanimi.SesDosyasiAdresi = rw1["SesDosyasiAdresi"].ToString();
alarmtanimi.RSKodu.Id = Convert.ToInt64(Current.IsNull(rw1["RSKodu_Id"], 0));
alarmtanimi.Insert();
}
else
{
alarmtanimi = Persistence.Read<CihazAlarmTanimi>(Id);
alarmtanimi.Cihaz.Id = infoformentity.Id;
alarmtanimi.CihazAdres.Id = chz.Id;
alarmtanimi.AlarmTipi = (mymodel.myenum.AlarmTipi)Enum.Parse(typeof(mymodel.myenum.AlarmTipi),Current.IsNull(rw1["AlarmTipi"].ToString(),"").ToString());
alarmtanimi.AlarmMesaji = rw1["AlarmMesaji"].ToString();
alarmtanimi.DataTipi = (mymodel.myenum.MappedFieldType)Enum.Parse(typeof(mymodel.myenum.MappedFieldType), Current.IsNull(rw1["DataTipi1"].ToString(),"").ToString());
alarmtanimi.IsLogTutulsun = bool.Parse(Current.IsNull(rw1["IsLogTutulsun1"].ToString(), false).ToString());
alarmtanimi.SesAcik = bool.Parse(Current.IsNull(rw1["SesAcik"], false).ToString());
alarmtanimi.SesDosyasiAdresi = Current.IsNull(rw1["SesDosyasiAdresi"], "").ToString();
alarmtanimi.RSKodu.Id = Convert.ToInt64(Current.IsNull(rw1["RSKodu_Id"], 0));
alarmtanimi.Update();
}
alarmtanimId += alarmtanimi.Id + ",";
}
try
{
if (cihaztagadresId.Length > 0)
{
cihaztagadresId = cihaztagadresId.Remove(cihaztagadresId.Length - 1, 1);
}
else
cihaztagadresId = "0";
if (alarmtanimId.Length > 0)
{
alarmtanimId = alarmtanimId.Remove(alarmtanimId.Length - 1, 1);
}
else
alarmtanimId = "0";
int i = Transaction.Instance.ExecuteNonQuery(" delete from CihazAdres where Cihaz_Id=@prm0 and Id Not in ("+cihaztagadresId+")", new object[] { infoformentity.Id });
i = Transaction.Instance.ExecuteNonQuery(" delete from CihazAlarmTanimi where Cihaz_Id=@prm0 and Id Not in("+alarmtanimId+")", new object[] { infoformentity.Id });
}
catch (Exception ex)
{
throw new Exception("Cihaz ait adresler silinemedi" + ex.Message);
}
});
}
public AlarmTarihce()
{
Cihaz = new Cihaz();
alarm = new CihazAlarmTanimi();
}