public void Update(IList <M_Dictionary> entities) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.Int), new SqlParameter("@Name", SqlDbType.VarChar, 100), new SqlParameter("@ValuesJson", SqlDbType.NText), new SqlParameter("@ValuesBinary", SqlDbType.Image), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; using (var conn = new SqlConnection(this._databaseConnectionString)) { if (conn.State != ConnectionState.Open) { conn.Open(); } var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { foreach (var entity in entities) { parms[0].Value = SqlTypeConverter.DBNullInt32Checker(entity.Id); parms[1].Value = SqlTypeConverter.DBNullStringChecker(entity.Name); parms[2].Value = SqlTypeConverter.DBNullStringChecker(entity.ValuesJson); parms[3].Value = SqlTypeConverter.DBNullBytesChecker(entity.ValuesBinary); parms[4].Value = SqlTypeConverter.DBNullDateTimeChecker(entity.LastUpdatedDate); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Sc.Sql_M_Dictionary_Repository_Update, parms); } trans.Commit(); } catch { trans.Rollback(); throw; } } }
public void Update(IList <G_Image> entities) { SqlParameter[] parms = { new SqlParameter("@Name", SqlDbType.VarChar, 200), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@Content", SqlDbType.Image), new SqlParameter("@Thumbnail", SqlDbType.Image), new SqlParameter("@UpdateMark", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 512) }; using (var conn = new SqlConnection(this._databaseConnectionString)) { if (conn.State != ConnectionState.Open) { conn.Open(); } var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { foreach (var entity in entities) { parms[0].Value = SqlTypeConverter.DBNullStringChecker(entity.Name); parms[1].Value = SqlTypeConverter.DBNullInt32Checker(entity.Type); parms[2].Value = SqlTypeConverter.DBNullBytesChecker(entity.Content); parms[3].Value = SqlTypeConverter.DBNullBytesChecker(entity.Thumbnail); parms[4].Value = SqlTypeConverter.DBNullStringChecker(entity.UpdateMark); parms[5].Value = SqlTypeConverter.DBNullStringChecker(entity.Remark); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Sc.Sql_G_Image_Repository_Update, parms); } trans.Commit(); } catch { trans.Rollback(); throw; } } }
public void Save(U_Profile entity) { SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.VarChar, 100), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@ValuesJson", SqlDbType.NText), new SqlParameter("@ValuesBinary", SqlDbType.Image), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; using (var conn = new SqlConnection(this._databaseConnectionString)) { if (conn.State != ConnectionState.Open) { conn.Open(); } var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { parms[0].Value = SqlTypeConverter.DBNullStringChecker(entity.UserId); parms[1].Value = (int)entity.Type; parms[2].Value = SqlTypeConverter.DBNullStringChecker(entity.ValuesJson); parms[3].Value = SqlTypeConverter.DBNullBytesChecker(entity.ValuesBinary); parms[4].Value = SqlTypeConverter.DBNullDateTimeChecker(entity.LastUpdatedDate); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Sc.Sql_U_Profile_Repository_Save, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } }