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;
}
}
}
