public Assetconfig CreateAssetconfig(Assetconfig info)
{
try
{
Management.BeginTransaction();
Management.CreateAssetconfig(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Assetconfig CreateAssetconfig(Assetconfig info)
{
try
{
string sqlCommand = @"INSERT INTO ""ASSET_CONFIG"" (""CONFIGID"",""CATEGORYID"",""CATEGORYNAME"",""CONFIGNAME"",""CONFIGVALUE"",""CREATEDDATE"",""CREATOR"") VALUES (:Configid,:Categoryid,:Categoryname,:Configname,:Configvalue,:Createddate,:Creator)";
this.Database.AddInParameter(":Configid", info.Configid);//DBType:VARCHAR2
this.Database.AddInParameter(":Categoryid", info.Categoryid);//DBType:VARCHAR2
this.Database.AddInParameter(":Categoryname", info.Categoryname);//DBType:VARCHAR2
this.Database.AddInParameter(":Configname", info.Configname);//DBType:VARCHAR2
this.Database.AddInParameter(":Configvalue", info.Configvalue);//DBType:VARCHAR2
this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE
this.Database.AddInParameter(":Creator", info.Creator);//DBType:NVARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}