public int Update(Spartane.Core.Classes.Spartan_Format.Spartan_Format entity) { int rta; try { var paramUpdFormatId = _dataProvider.GetParameter(); paramUpdFormatId.ParameterName = "FormatId"; paramUpdFormatId.DbType = DbType.Int32; paramUpdFormatId.Value = (object)entity.FormatId ?? DBNull.Value; var paramUpdRegistration_Date = _dataProvider.GetParameter(); paramUpdRegistration_Date.ParameterName = "Registration_Date"; paramUpdRegistration_Date.DbType = DbType.DateTime; paramUpdRegistration_Date.Value = (object)entity.Registration_Date ?? DBNull.Value; var paramUpdRegistration_Hour = _dataProvider.GetParameter(); paramUpdRegistration_Hour.ParameterName = "Registration_Hour"; paramUpdRegistration_Hour.DbType = DbType.String; paramUpdRegistration_Hour.Value = (object)entity.Registration_Hour ?? DBNull.Value; var paramUpdRegistration_User = _dataProvider.GetParameter(); paramUpdRegistration_User.ParameterName = "Registration_User"; paramUpdRegistration_User.DbType = DbType.Int32; paramUpdRegistration_User.Value = (object)entity.Registration_User ?? DBNull.Value; var paramUpdFormat_Name = _dataProvider.GetParameter(); paramUpdFormat_Name.ParameterName = "Format_Name"; paramUpdFormat_Name.DbType = DbType.String; paramUpdFormat_Name.Value = (object)entity.Format_Name ?? DBNull.Value; var paramUpdFormat_Type = _dataProvider.GetParameter(); paramUpdFormat_Type.ParameterName = "Format_Type"; paramUpdFormat_Type.DbType = DbType.Int16; paramUpdFormat_Type.Value = (object)entity.Format_Type ?? DBNull.Value; var paramUpdSearch = _dataProvider.GetParameter(); paramUpdSearch.ParameterName = "Search"; paramUpdSearch.DbType = DbType.String; paramUpdSearch.Value = (object)entity.Search ?? DBNull.Value; var paramUpdObject = _dataProvider.GetParameter(); paramUpdObject.ParameterName = "Object"; paramUpdObject.DbType = DbType.Int32; paramUpdObject.Value = (object)entity.Object ?? DBNull.Value; var paramUpdHeader = _dataProvider.GetParameter(); paramUpdHeader.ParameterName = "Header"; paramUpdHeader.DbType = DbType.String; paramUpdHeader.Value = (object)entity.Header ?? DBNull.Value; var paramUpdBody = _dataProvider.GetParameter(); paramUpdBody.ParameterName = "Body"; paramUpdBody.DbType = DbType.String; paramUpdBody.Value = (object)entity.Body ?? DBNull.Value; var paramUpdFooter = _dataProvider.GetParameter(); paramUpdFooter.ParameterName = "Footer"; paramUpdFooter.DbType = DbType.String; paramUpdFooter.Value = (object)entity.Footer ?? DBNull.Value; var paramUpdFilter = _dataProvider.GetParameter(); paramUpdFilter.ParameterName = "Filter"; paramUpdFilter.DbType = DbType.String; paramUpdFilter.Value = (object)entity.Filter ?? DBNull.Value; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_Format>("sp_UpdSpartan_Format", paramUpdFormatId, paramUpdRegistration_Date, paramUpdRegistration_Hour, paramUpdRegistration_User, paramUpdFormat_Name, paramUpdFormat_Type, paramUpdSearch, paramUpdObject, paramUpdHeader, paramUpdBody, paramUpdFooter, paramUpdFilter).FirstOrDefault(); rta = Convert.ToInt32(empEntity.FormatId); var listFormatField = _ISpartan_Format_FieldService.SelAll(false, "Format=" + rta, string.Empty); //Borro todos los fields foreach (var field in listFormatField) { _ISpartan_Format_FieldService.Delete(field.FormatFieldId); } //Los inserto nuevamente foreach (var field in entity.Format_Field_Spartan_Format_Field) { field.Format = rta; _ISpartan_Format_FieldService.Insert(field); } } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }
public int Insert(Spartane.Core.Classes.Spartan_Format.Spartan_Format entity) { int rta; try { var padreRegistration_Date = _dataProvider.GetParameter(); padreRegistration_Date.ParameterName = "Registration_Date"; padreRegistration_Date.DbType = DbType.DateTime; padreRegistration_Date.Value = (object)entity.Registration_Date ?? DBNull.Value; var padreRegistration_Hour = _dataProvider.GetParameter(); padreRegistration_Hour.ParameterName = "Registration_Hour"; padreRegistration_Hour.DbType = DbType.String; padreRegistration_Hour.Value = (object)entity.Registration_Hour ?? DBNull.Value; var padreRegistration_User = _dataProvider.GetParameter(); padreRegistration_User.ParameterName = "Registration_User"; padreRegistration_User.DbType = DbType.Int32; padreRegistration_User.Value = (object)entity.Registration_User ?? DBNull.Value; var padreFormat_Name = _dataProvider.GetParameter(); padreFormat_Name.ParameterName = "Format_Name"; padreFormat_Name.DbType = DbType.String; padreFormat_Name.Value = (object)entity.Format_Name ?? DBNull.Value; var padreFormat_Type = _dataProvider.GetParameter(); padreFormat_Type.ParameterName = "Format_Type"; padreFormat_Type.DbType = DbType.Int16; padreFormat_Type.Value = (object)entity.Format_Type ?? DBNull.Value; var padreSearch = _dataProvider.GetParameter(); padreSearch.ParameterName = "Search"; padreSearch.DbType = DbType.String; padreSearch.Value = (object)entity.Search ?? DBNull.Value; var padreObject = _dataProvider.GetParameter(); padreObject.ParameterName = "Object"; padreObject.DbType = DbType.Int32; padreObject.Value = (object)entity.Object ?? DBNull.Value; var padreHeader = _dataProvider.GetParameter(); padreHeader.ParameterName = "Header"; padreHeader.DbType = DbType.String; padreHeader.Value = (object)entity.Header ?? DBNull.Value; var padreBody = _dataProvider.GetParameter(); padreBody.ParameterName = "Body"; padreBody.DbType = DbType.String; padreBody.Value = (object)entity.Body ?? DBNull.Value; var padreFooter = _dataProvider.GetParameter(); padreFooter.ParameterName = "Footer"; padreFooter.DbType = DbType.String; padreFooter.Value = (object)entity.Footer ?? DBNull.Value; var padreFilter = _dataProvider.GetParameter(); padreFilter.ParameterName = "Filter"; padreFilter.DbType = DbType.String; padreFilter.Value = (object)entity.Filter ?? DBNull.Value; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_Format>("sp_InsSpartan_Format", padreRegistration_Date , padreRegistration_Hour , padreRegistration_User , padreFormat_Name , padreFormat_Type , padreSearch , padreObject , padreHeader , padreBody , padreFooter , padreFilter ).FirstOrDefault(); rta = Convert.ToInt32(empEntity.FormatId); foreach (var field in entity.Format_Field_Spartan_Format_Field) { field.Format = rta; _ISpartan_Format_FieldService.Insert(field); } } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }