Example #1
0
 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;
 }
Example #2
0
        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);
                }
            });
        }