public bool Create(
int siteId,
string loginProvider,
string providerKey,
string providerDisplayName,
string userId)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_UserLogins (");
sqlCommand.Append("LoginProvider ,");
sqlCommand.Append("ProviderKey, ");
sqlCommand.Append("UserId, ");
sqlCommand.Append("SiteId, ");
sqlCommand.Append("ProviderDisplayName ");
sqlCommand.Append(") ");
sqlCommand.Append("VALUES (");
sqlCommand.Append("@LoginProvider, ");
sqlCommand.Append("@ProviderKey, ");
sqlCommand.Append("@UserId, ");
sqlCommand.Append("@SiteId, ");
sqlCommand.Append("@ProviderDisplayName ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[5];
arParams[0] = new SqlCeParameter("@LoginProvider", SqlDbType.NVarChar, 128);
arParams[0].Value = loginProvider;
arParams[1] = new SqlCeParameter("@ProviderKey", SqlDbType.NVarChar, 128);
arParams[1].Value = providerKey;
arParams[2] = new SqlCeParameter("@UserId", SqlDbType.NVarChar, 128);
arParams[2].Value = userId;
arParams[3] = new SqlCeParameter("@SiteId", SqlDbType.Int);
arParams[3].Value = siteId;
arParams[4] = new SqlCeParameter("@ProviderDisplayName", SqlDbType.NVarChar, 100);
arParams[4].Value = providerDisplayName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public void EnsureSettings()
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_SiteSettingsEx ");
sqlCommand.Append("(");
sqlCommand.Append("SiteID, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("KeyName,");
sqlCommand.Append("KeyValue, ");
sqlCommand.Append("GroupName ");
sqlCommand.Append(")");
sqlCommand.Append("SELECT ");
sqlCommand.Append("t.SiteID,");
sqlCommand.Append("t.SiteGuid, ");
sqlCommand.Append("t.[KeyName], ");
sqlCommand.Append("t.[DefaultValue], ");
sqlCommand.Append("t.[GroupName] ");
sqlCommand.Append("FROM ");
sqlCommand.Append("( ");
sqlCommand.Append("SELECT ");
sqlCommand.Append("s.SiteID, ");
sqlCommand.Append("s.SiteGuid, ");
sqlCommand.Append("d.[KeyName], ");
sqlCommand.Append("d.[DefaultValue], ");
sqlCommand.Append("d.[GroupName] ");
sqlCommand.Append("FROM ");
sqlCommand.Append("mp_Sites s, ");
sqlCommand.Append("mp_SiteSettingsExDef d ");
sqlCommand.Append(") t ");
sqlCommand.Append("LEFT OUTER JOIN ");
sqlCommand.Append("mp_SiteSettingsEx e ");
sqlCommand.Append("ON ");
sqlCommand.Append("e.SiteID = t.SiteID ");
sqlCommand.Append("AND e.[KeyName] = t.[KeyName] ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("e.SiteID IS NULL ");
sqlCommand.Append(";");
AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
null);
}
public bool Update(int roleId, string roleName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_Roles ");
sqlCommand.Append("SET ");
sqlCommand.Append("DisplayName = @DisplayName ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("RoleID = @RoleID ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[2];
arParams[0] = new SqlCeParameter("@RoleID", SqlDbType.Int);
arParams[0].Value = roleId;
arParams[1] = new SqlCeParameter("@DisplayName", SqlDbType.NVarChar, 50);
arParams[1].Value = roleName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public static void Save(string xm, string mobile, string picture)
{
var sql = "INSERT INTO [UserPhotoSnap] (XM,Mobile,PhotoSnapPath, SnapTime) VALUES ('" + xm.Replace("'", "\'") +
"', '" + mobile + "','" + picture + "','" + DateTime.Now + "')";
SqlCeHelper.ExecuteNonQuery(CONNECTION_STRING, CommandType.Text, sql);
}
/// <summary>
/// Adds the patient.
/// </summary>
/// <param name="ConnectionString">The connection string.</param>
/// <param name="AETitle">The AE title.</param>
/// <param name="dataset">The dataset.</param>
/// <returns></returns>
private static string AddPatient(string ConnectionString, string AETitle, DicomDataSet dataset)
{
string pid = dataset.GetValue <string>(DicomTag.PatientID, string.Empty);
if (string.IsNullOrEmpty(pid))
{
throw new ArgumentException("Missing dicom tag", "Patient ID");
}
if (!RecordExists(ConnectionString, "Patients", "PatientID = '" + pid + "'"))
{
DateTime?bd = dataset.GetValue <DateTime?>(DicomTag.PatientBirthDate, null, GetDate);
DateTime?bt = dataset.GetValue <DateTime?>(DicomTag.PatientBirthTime, null, GetDate);
string sql = string.Format(PatientInsert, pid,
dataset.GetValue <string>(DicomTag.PatientName, string.Empty),
GetDateString(bd, bt),
dataset.GetValue <string>(DicomTag.PatientSex, string.Empty),
dataset.GetValue <string>(DicomTag.EthnicGroup, string.Empty),
dataset.GetValue <string>(DicomTag.PatientComments, string.Empty),
AETitle);
SqlCeHelper.ExecuteNonQuery(ConnectionString, sql);
}
return(pid);
}
/// <summary>
/// Inserts a row in the mp_GeoZone table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="countryGuid"> countryGuid </param>
/// <param name="name"> name </param>
/// <param name="code"> code </param>
/// <returns>bool</returns>
public bool Create(
Guid guid,
Guid countryGuid,
string name,
string code)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_GeoZone ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("CountryGuid, ");
sqlCommand.Append("Name, ");
sqlCommand.Append("Code ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@CountryGuid, ");
sqlCommand.Append("@Name, ");
sqlCommand.Append("@Code ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@CountryGuid", SqlDbType.UniqueIdentifier);
arParams[1].Value = countryGuid;
arParams[2] = new SqlCeParameter("@Name", SqlDbType.NVarChar, 255);
arParams[2].Value = name;
arParams[3] = new SqlCeParameter("@Code", SqlDbType.NVarChar, 255);
arParams[3].Value = code;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
public bool Add(
Guid guid,
Guid siteGuid,
string folderName)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_SiteFolders ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("FolderName ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@FolderName ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[3];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[1].Value = siteGuid;
arParams[2] = new SqlCeParameter("@FolderName", SqlDbType.NVarChar, 255);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = folderName;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
/// <summary>
/// Deletes rows from the mp_SystemLog table. Returns true if rows deleted.
/// </summary>
public bool DeleteAll()
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("DELETE FROM mp_SystemLog ");
//sqlCommand.Append("WHERE ");
//sqlCommand.Append("ID = @ID ");
sqlCommand.Append(";");
//SqlCeParameter[] arParams = new SqlCeParameter[1];
//arParams[0] = new SqlCeParameter("@ID", SqlDbType.Int);
//arParams[0].Value = id;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
null);
return(rowsAffected > 0);
}
private static void DeleteImage(string sopInstanceUid, string ConnectionString)
{
if (sopInstanceUid.Length > 0)
{
string query = "DELETE FROM Images WHERE SOPInstanceUID = '" + sopInstanceUid + "';";
try
{
SqlCeHelper.ExecuteNonQuery(ConnectionString, query);
}
catch (Exception)
{
}
}
}
private static void DeletePatient(string patientId, string ConnectionString)
{
if (patientId.Length > 0)
{
string query = "DELETE FROM Patients WHERE PatientID = '" + patientId + "';";
try
{
SqlCeHelper.ExecuteNonQuery(ConnectionString, query);
}
catch (Exception)
{
}
}
}
internal void Delete(Entity entity)
{
SqlStatement sql = new SqlStatement();
// delete...
StringBuilder builder = new StringBuilder();
builder.Append("delete from ");
builder.Append(this.EntityType.NativeName);
builder.Append(" where ");
AppendSelectConstraint(builder, sql, entity);
// run...
sql.CommandText = builder.ToString();
// run...
SqlCeHelper db = new SqlCeHelper();
db.EnsureTableExists(entity.EntityType);
db.ExecuteNonQuery(sql);
}
internal void Update(Entity entity)
{
SqlStatement sql = new SqlStatement();
// create...
StringBuilder builder = new StringBuilder();
builder.Append("update ");
builder.Append(this.EntityType.NativeName);
builder.Append(" set ");
bool first = true;
foreach (EntityField field in this.EntityType.Fields)
{
if (entity.IsModified(field))
{
if (first)
first = false;
else
builder.Append(", ");
builder.Append(field.NativeName);
builder.Append("=@");
// value...
object value = entity.GetValue(field);
builder.Append(sql.AddParameter(value).Name);
}
}
builder.Append(" where ");
this.AppendSelectConstraint(builder, sql, entity);
// run...
sql.CommandText = builder.ToString();
// run...
SqlCeHelper db = new SqlCeHelper();
db.EnsureTableExists(entity.EntityType);
db.ExecuteNonQuery(sql);
}
public bool Update(
int id,
string userId,
string claimType,
string claimValue)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_UserClaims ");
sqlCommand.Append("SET ");
sqlCommand.Append("UserId = @UserId, ");
sqlCommand.Append("ClaimType = @ClaimType, ");
sqlCommand.Append("ClaimValue = @ClaimValue ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Id = @Id ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[4];
arParams[0] = new SqlCeParameter("@Id", SqlDbType.Int);
arParams[0].Value = id;
arParams[1] = new SqlCeParameter("@UserId", SqlDbType.NVarChar, 128);
arParams[1].Value = userId;
arParams[2] = new SqlCeParameter("@ClaimType", SqlDbType.NVarChar);
arParams[2].Value = claimType;
arParams[3] = new SqlCeParameter("@ClaimValue", SqlDbType.NVarChar);
arParams[3].Value = claimValue;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
public static void Remove(string id)
{
var sql = "DELETE FROM [UserPhotoSnap] WHERE Id=" + id;
SqlCeHelper.ExecuteNonQuery(CONNECTION_STRING, CommandType.Text, sql);
}
internal void Insert(Entity entity)
{
SqlStatement sql = new SqlStatement();
// create...
StringBuilder builder = new StringBuilder();
builder.Append("insert into ");
builder.Append(this.EntityType.NativeName);
builder.Append(" (");
bool first = true;
foreach (EntityField field in this.EntityType.Fields)
{
if (entity.IsModified(field))
{
if (first)
first = false;
else
builder.Append(", ");
builder.Append(field.NativeName);
}
}
builder.Append(") values (");
first = true;
foreach (EntityField field in this.EntityType.Fields)
{
if (entity.IsModified(field))
{
if (first)
first = false;
else
builder.Append(", ");
// param...
object value = entity.GetValue(field);
SqlStatementParameter param = sql.AddParameter(value);
builder.Append("@");
builder.Append(param.Name);
}
}
builder.Append(")");
// run...
sql.CommandText = builder.ToString();
// run...
SqlCeHelper db = new SqlCeHelper();
db.EnsureTableExists(entity.EntityType);
db.ExecuteNonQuery(sql);
}
/// <summary>
/// Inserts a row in the mp_UserLocation table. Returns rows affected count.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="iPAddress"> iPAddress </param>
/// <param name="iPAddressLong"> iPAddressLong </param>
/// <param name="hostname"> hostname </param>
/// <param name="longitude"> longitude </param>
/// <param name="latitude"> latitude </param>
/// <param name="iSP"> iSP </param>
/// <param name="continent"> continent </param>
/// <param name="country"> country </param>
/// <param name="region"> region </param>
/// <param name="city"> city </param>
/// <param name="timeZone"> timeZone </param>
/// <param name="captureCount"> captureCount </param>
/// <param name="firstCaptureUTC"> firstCaptureUTC </param>
/// <param name="lastCaptureUTC"> lastCaptureUTC </param>
/// <returns>int</returns>
public int Create(
Guid rowID,
Guid userGuid,
Guid siteGuid,
string iPAddress,
long iPAddressLong,
string hostname,
double longitude,
double latitude,
string iSP,
string continent,
string country,
string region,
string city,
string timeZone,
int captureCount,
DateTime firstCaptureUTC,
DateTime lastCaptureUTC)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_UserLocation ");
sqlCommand.Append("(");
sqlCommand.Append("RowID, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("IPAddress, ");
sqlCommand.Append("IPAddressLong, ");
sqlCommand.Append("Hostname, ");
sqlCommand.Append("Longitude, ");
sqlCommand.Append("Latitude, ");
sqlCommand.Append("ISP, ");
sqlCommand.Append("Continent, ");
sqlCommand.Append("Country, ");
sqlCommand.Append("Region, ");
sqlCommand.Append("City, ");
sqlCommand.Append("TimeZone, ");
sqlCommand.Append("CaptureCount, ");
sqlCommand.Append("FirstCaptureUTC, ");
sqlCommand.Append("LastCaptureUTC ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@RowID, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@IPAddress, ");
sqlCommand.Append("@IPAddressLong, ");
sqlCommand.Append("@Hostname, ");
sqlCommand.Append("@Longitude, ");
sqlCommand.Append("@Latitude, ");
sqlCommand.Append("@ISP, ");
sqlCommand.Append("@Continent, ");
sqlCommand.Append("@Country, ");
sqlCommand.Append("@Region, ");
sqlCommand.Append("@City, ");
sqlCommand.Append("@TimeZone, ");
sqlCommand.Append("@CaptureCount, ");
sqlCommand.Append("@FirstCaptureUTC, ");
sqlCommand.Append("@LastCaptureUTC ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[17];
arParams[0] = new SqlCeParameter("@RowID", SqlDbType.UniqueIdentifier);
arParams[0].Value = rowID;
arParams[1] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[1].Value = userGuid;
arParams[2] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[2].Value = siteGuid;
arParams[3] = new SqlCeParameter("@IPAddress", SqlDbType.NVarChar, 50);
arParams[3].Value = iPAddress;
arParams[4] = new SqlCeParameter("@IPAddressLong", SqlDbType.BigInt);
arParams[4].Value = iPAddressLong;
arParams[5] = new SqlCeParameter("@Hostname", SqlDbType.NVarChar, 255);
arParams[5].Value = hostname;
arParams[6] = new SqlCeParameter("@Longitude", SqlDbType.Float);
arParams[6].Value = longitude;
arParams[7] = new SqlCeParameter("@Latitude", SqlDbType.Float);
arParams[7].Value = latitude;
arParams[8] = new SqlCeParameter("@ISP", SqlDbType.NVarChar, 255);
arParams[8].Value = iSP;
arParams[9] = new SqlCeParameter("@Continent", SqlDbType.NVarChar, 255);
arParams[9].Value = continent;
arParams[10] = new SqlCeParameter("@Country", SqlDbType.NVarChar, 255);
arParams[10].Value = country;
arParams[11] = new SqlCeParameter("@Region", SqlDbType.NVarChar, 255);
arParams[11].Value = region;
arParams[12] = new SqlCeParameter("@City", SqlDbType.NVarChar, 255);
arParams[12].Value = city;
arParams[13] = new SqlCeParameter("@TimeZone", SqlDbType.NVarChar, 255);
arParams[13].Value = timeZone;
arParams[14] = new SqlCeParameter("@CaptureCount", SqlDbType.Int);
arParams[14].Value = captureCount;
arParams[15] = new SqlCeParameter("@FirstCaptureUTC", SqlDbType.DateTime);
arParams[15].Value = firstCaptureUTC;
arParams[16] = new SqlCeParameter("@LastCaptureUTC", SqlDbType.DateTime);
arParams[16].Value = lastCaptureUTC;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
public bool RunScript(string script, string overrideConnectionInfo)
{
if ((script == null) || (script.Length == 0))
{
return(true);
}
bool result = false;
SqlCeConnection connection;
if (
(overrideConnectionInfo != null) &&
(overrideConnectionInfo.Length > 0)
)
{
connection = new SqlCeConnection(overrideConnectionInfo);
}
else
{
connection = new SqlCeConnection(connectionString);
}
string[] delimiter = new string[] { "GO\r\n" };
script = script.Replace("GO", "GO\r\n");
string[] arrSqlStatements = script.Split(delimiter, StringSplitOptions.RemoveEmptyEntries);
connection.Open();
//string[] subdelimiter = new string[] { ";" };
SqlCeTransaction transaction = connection.BeginTransaction();
string currentStatement = string.Empty;
try
{
foreach (string sqlStatement in arrSqlStatements)
{
//string[] subStatements = s.Split(subdelimiter, StringSplitOptions.RemoveEmptyEntries);
//foreach (string sqlStatement in subStatements)
//{
if (sqlStatement.Trim().Length > 0)
{
currentStatement = sqlStatement;
AdoHelper.ExecuteNonQuery(
transaction,
CommandType.Text,
sqlStatement,
null);
}
// }
}
transaction.Commit();
result = true;
}
catch (SqlCeException ex)
{
transaction.Rollback();
log.LogError("db.RunScript failed", ex);
log.LogInformation("last script statement was " + currentStatement);
throw;
}
finally
{
connection.Close();
}
return(result);
}
public static void DeleteAllTableItems(string ConnectionString, string sTable)
{
string sQuery = string.Format(sQueryDeleteAllTableItems, sTable);
SqlCeHelper.ExecuteNonQuery(ConnectionString, sQuery);
}
public static void DeleteTableItem(string ConnectionString, string sTable, string sUniqueId, string sValue)
{
string sQuery = string.Format(sQueryDeleteTableItem, sTable, sUniqueId, sValue);
SqlCeHelper.ExecuteNonQuery(ConnectionString, sQuery);
}
internal static void DeleteAll()
{
SqlCeHelper db = new SqlCeHelper();
// ensure...
EntityType et = EntityType.GetEntityType(typeof(Bookmark));
db.EnsureTableExists(et);
// delete...
db.ExecuteNonQuery(new SqlStatement("delete from " + et.NativeName));
}
/// <summary>
/// Inserts a row in the mp_Currency table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="title"> title </param>
/// <param name="code"> code </param>
/// <param name="symbolLeft"> symbolLeft </param>
/// <param name="symbolRight"> symbolRight </param>
/// <param name="decimalPointChar"> decimalPointChar </param>
/// <param name="thousandsPointChar"> thousandsPointChar </param>
/// <param name="decimalPlaces"> decimalPlaces </param>
/// <param name="value"> value </param>
/// <param name="lastModified"> lastModified </param>
/// <param name="created"> created </param>
/// <returns>bool</returns>
public bool Create(
Guid guid,
string title,
string code,
string symbolLeft,
string symbolRight,
string decimalPointChar,
string thousandsPointChar,
string decimalPlaces,
decimal value,
DateTime lastModified,
DateTime created)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_Currency ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("Title, ");
sqlCommand.Append("Code, ");
sqlCommand.Append("SymbolLeft, ");
sqlCommand.Append("SymbolRight, ");
sqlCommand.Append("DecimalPointChar, ");
sqlCommand.Append("ThousandsPointChar, ");
sqlCommand.Append("DecimalPlaces, ");
sqlCommand.Append("Value, ");
sqlCommand.Append("LastModified, ");
sqlCommand.Append("Created ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@Title, ");
sqlCommand.Append("@Code, ");
sqlCommand.Append("@SymbolLeft, ");
sqlCommand.Append("@SymbolRight, ");
sqlCommand.Append("@DecimalPointChar, ");
sqlCommand.Append("@ThousandsPointChar, ");
sqlCommand.Append("@DecimalPlaces, ");
sqlCommand.Append("@Value, ");
sqlCommand.Append("@LastModified, ");
sqlCommand.Append("@Created ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[11];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@Title", SqlDbType.NVarChar, 50);
arParams[1].Value = title;
arParams[2] = new SqlCeParameter("@Code", SqlDbType.NChar, 3);
arParams[2].Value = code;
arParams[3] = new SqlCeParameter("@SymbolLeft", SqlDbType.NVarChar, 15);
arParams[3].Value = symbolLeft;
arParams[4] = new SqlCeParameter("@SymbolRight", SqlDbType.NVarChar, 15);
arParams[4].Value = symbolRight;
arParams[5] = new SqlCeParameter("@DecimalPointChar", SqlDbType.NChar, 1);
arParams[5].Value = decimalPointChar;
arParams[6] = new SqlCeParameter("@ThousandsPointChar", SqlDbType.NChar, 1);
arParams[6].Value = thousandsPointChar;
arParams[7] = new SqlCeParameter("@DecimalPlaces", SqlDbType.NChar, 1);
arParams[7].Value = decimalPlaces;
arParams[8] = new SqlCeParameter("@Value", SqlDbType.Decimal);
arParams[8].Value = value;
arParams[9] = new SqlCeParameter("@LastModified", SqlDbType.DateTime);
arParams[9].Value = lastModified;
arParams[10] = new SqlCeParameter("@Created", SqlDbType.DateTime);
arParams[10].Value = created;
int rowsAffected = AdoHelper.ExecuteNonQuery(
connectionString,
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > 0);
}
