Example #1
0
        public void SaveOldDetailRow(TblPostingProfileDetailViewModel oldRow)
        {
            if (oldRow != null)
            {
                var valiationCollection = new List <ValidationResult>();

                var isvalid = Validator.TryValidateObject(oldRow,
                                                          new ValidationContext(oldRow, null, null), valiationCollection, true);

                if (isvalid)
                {
                    var save = oldRow.Iserial == 0;
                    if (AllowUpdate != true && !save)
                    {
                        MessageBox.Show(strings.AllowUpdateMsg);
                        return;
                    }
                    var saveRow = new TblPostingProfileDetail();
                    saveRow.InjectFrom(oldRow);

                    if (!Loading)
                    {
                        Loading = true;
                        Glclient.UpdateOrInsertTblPostingProfileDetailsAsync(saveRow, save, SelectedMainRow.DetailsList.IndexOf(oldRow),
                                                                             LoggedUserInfo.DatabasEname);
                    }
                }
            }
        }
Example #2
0
        private int DeleteTblPostingProfileDetail(TblPostingProfileDetail row, int index, string company)
        {
            using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
            {
                var query = (from e in entity.TblPostingProfileDetails
                             where e.Iserial == row.Iserial
                             select e).SingleOrDefault();
                if (query != null)
                {
                    entity.DeleteObject(query);
                }

                entity.SaveChanges();
            }
            return(row.Iserial);
        }
Example #3
0
 private TblPostingProfileDetail UpdateOrInsertTblPostingProfileDetails(TblPostingProfileDetail newRow, bool save, int index, out int outindex, string company)
 {
     outindex = index;
     using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
     {
         if (save)
         {
             entity.TblPostingProfileDetails.AddObject(newRow);
         }
         else
         {
             var oldRow = (from e in entity.TblPostingProfileDetails
                           where e.Iserial == newRow.Iserial
                           select e).SingleOrDefault();
             if (oldRow != null)
             {
                 GenericUpdate(oldRow, newRow, entity);
             }
         }
         entity.SaveChanges();
         return(newRow);
     }
 }