Beispiel #1
0
 public bool AddCriminal(CriminalInfoTable criminalInfo)
 {
     try
     {
         context.CriminalInfoTables.InsertOnSubmit(criminalInfo);
         context.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Beispiel #2
0
        public static CriminalInfoTable ConvertCriminalCriminalInfo(CriminalInfo criminalInfoBean)
        {
            if (criminalInfoBean == null)
            {
                return(null);
            }
            CriminalInfoTable criminalInfoDB = new CriminalInfoTable()
            {
                Id          = criminalInfoBean.Id,
                Name        = criminalInfoBean.Name,
                Age         = criminalInfoBean.Age,
                Gender      = criminalInfoBean.Gender,
                Height      = (float)criminalInfoBean.Height,
                Nationality = criminalInfoBean.Nationality,
                Weight      = (float)criminalInfoBean.Weight,
            };

            return(criminalInfoDB);
        }
Beispiel #3
0
 public bool UpdateCriminal(CriminalInfoTable criminal)
 {
     try
     {
         CriminalInfoTable selectedCriminal = (from r in context.CriminalInfoTables
                                               where r.Id.Equals(criminal.Id)
                                               select r).First();
         selectedCriminal.Name        = criminal.Name;
         selectedCriminal.Nationality = criminal.Nationality;
         selectedCriminal.Height      = criminal.Height;
         selectedCriminal.Weight      = criminal.Weight;
         selectedCriminal.Age         = criminal.Age;
         selectedCriminal.Gender      = criminal.Gender;
         context.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Beispiel #4
0
 public bool DeleteCriminal(long id)
 {
     try
     {
         CriminalInfoTable obj = (from r in context.CriminalInfoTables
                                  where r.Id.Equals(id)
                                  select r).First();
         if (obj != null)
         {
             context.CriminalInfoTables.DeleteOnSubmit(obj);
             context.SubmitChanges();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch
     {
         return(false);
     }
 }
 partial void DeleteCriminalInfoTable(CriminalInfoTable instance);
 partial void UpdateCriminalInfoTable(CriminalInfoTable instance);
 partial void InsertCriminalInfoTable(CriminalInfoTable instance);