public bool Insert()
{
bool Successful = false;
using (new Impersonator()) {
SqlConnection conn = DataSource.Conn();
try {
DateTime timeStamp = DateTime.UtcNow;
string sql = @"Insert INTO dbo.TrngModules
(Name
,Description
,Directory
,URL
,AdminURL
,ImageURL
,DBVersion
,DisplayIndex
,IsActive
,CreatedBy
,CreatedOn
,ModifiedBy
,ModifiedOn)
Values
(@Name
,@Description
,@Directory
,@URL
,@AdminURL
,@ImageURL
,@DBVersion
,@DisplayIndex
,@IsActive
,@CreatedBy
,@CreatedOn
,@ModifiedBy
,@ModifiedOn)
SELECT @ID = SCOPE_IDENTITY()" ;
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Name", _Name);
cmd.Parameters.AddWithValue("@Description", _Description);
cmd.Parameters.AddWithValue("@Directory", _Directory);
cmd.Parameters.AddWithValue("@URL", _URL);
cmd.Parameters.AddWithValue("@AdminURL", _AdminURL);
cmd.Parameters.AddWithValue("@ImageURL", _ImageURL);
cmd.Parameters.AddWithValue("@DBVersion", _DBVersion);
cmd.Parameters.AddWithValue("@DisplayIndex", _DisplayIndex);
cmd.Parameters.AddWithValue("@IsActive", _IsActive);
cmd.Parameters.AddWithValue("@CreatedBy", _CreatedBy);
cmd.Parameters.AddWithValue("@CreatedOn", _CreatedOn);
cmd.Parameters.AddWithValue("@ModifiedBy", _ModifiedBy);
cmd.Parameters.AddWithValue("@ModifiedOn", _ModifiedOn);
SqlParameter prmID = cmd.Parameters.Add("@ID", SqlDbType.Int);
prmID.Direction = ParameterDirection.Output;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
_ID = int.Parse(prmID.Value.ToString());
Successful = true;
} catch (SqlException sqlex) {
Error.WriteError(sqlex);
_ErrorMessage = sqlex.Message;
} catch (Exception ex) {
Error.WriteError(ex);
_ErrorMessage = ex.Message;
} finally {
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
return(Successful);
}
public bool Insert()
{
bool Successful = false;
using (new Impersonator()) {
SqlConnection conn = DataSource.Conn();
try {
DateTime TimeStamp = DateTime.UtcNow;
string sql = @"INSERT INTO dbo.TrngSets
(Name,
Description,
OrgGroupID,
IsDefault,
CreatedBy,
CreatedOn,
ModifiedBy,
ModifiedOn)
VALUES
(@Name,
@Description,
@OrgGroupID,
@IsDefault,
@CreatedBy,
@CreatedOn,
@ModifiedBy,
@ModifiedOn)
SELECT @ID = SCOPE_IDENTITY()" ;
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Name", _Name);
cmd.Parameters.AddWithValue("@Description", _Description);
cmd.Parameters.AddWithValue("@OrgGroupID", _OrgGroupID);
cmd.Parameters.AddWithValue("@IsDefault", _IsDefault);
cmd.Parameters.AddWithValue("@CreatedBy", _CreatedBy);
cmd.Parameters.AddWithValue("@CreatedOn", TimeStamp);
cmd.Parameters.AddWithValue("@ModifiedBy", _ModifiedBy);
cmd.Parameters.AddWithValue("@ModifiedOn", TimeStamp);
SqlParameter prmID = cmd.Parameters.Add("@ID", SqlDbType.Int);
prmID.Direction = ParameterDirection.Output;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
_ID = int.Parse(prmID.Value.ToString());
_CreatedOn = TimeStamp;
_ModifiedOn = TimeStamp;
Successful = true;
} catch (SqlException sqlex) {
Error.WriteError(sqlex);
_ErrorMessage = sqlex.Message;
} catch (Exception ex) {
Error.WriteError(ex);
_ErrorMessage = ex.Message;
} finally {
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
return(Successful);
}
