134 lines
3.6 KiB
C#
134 lines
3.6 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using Roblox.Common;
|
|
using Roblox.Common.Persistence;
|
|
|
|
namespace <NAMESPACE>
|
|
{
|
|
internal class <DALCLASSNAME>
|
|
{
|
|
private <IDTYPE> _ID = default(<IDTYPE>);
|
|
<DALFIELDS>
|
|
internal <IDTYPE> ID
|
|
{
|
|
get { return _ID; }
|
|
set { _ID = value; }
|
|
}
|
|
<DALPROPERTIES>
|
|
private static string <CONNECTIONSTRING>
|
|
{
|
|
get { return <CONNECTIONSTRINGVALUE>; }
|
|
}
|
|
|
|
internal <DALCLASSNAME>()
|
|
{
|
|
}
|
|
|
|
internal void Delete()
|
|
{
|
|
if (_ID == default(<IDTYPE>))
|
|
throw new ApplicationException("Required value not specified: ID.");
|
|
|
|
var queryParameters = new List<SqlParameter>
|
|
{
|
|
new SqlParameter("@ID", _ID)
|
|
};
|
|
|
|
var dbInfo = new dbInfo(
|
|
<CONNECTIONSTRING>,
|
|
"<DELETEPROCEDURE>",
|
|
queryParameters
|
|
);
|
|
|
|
EntityHelper.DoEntityDALDelete(dbInfo);
|
|
}
|
|
internal void Insert()
|
|
{
|
|
var queryParameters = new List<SqlParameter>
|
|
{
|
|
<QUERYPARAMETERS>
|
|
};
|
|
|
|
var dbInfo = new dbInfo(
|
|
<CONNECTIONSTRING>,
|
|
"<INSERTPROCEDURE>",
|
|
new SqlParameter("@ID", <IDSQLDBTYPE>),
|
|
queryParameters
|
|
);
|
|
|
|
_ID = EntityHelper.DoEntityDALInsert<<IDTYPE>>(dbInfo);
|
|
}
|
|
internal void Update()
|
|
{
|
|
var queryParameters = new List<SqlParameter>
|
|
{
|
|
new SqlParameter("@ID", _ID),
|
|
<QUERYPARAMETERS>
|
|
};
|
|
|
|
var dbInfo = new dbInfo(
|
|
<CONNECTIONSTRING>,
|
|
"<UPDATEPROCEDURE>",
|
|
queryParameters
|
|
);
|
|
|
|
EntityHelper.DoEntityDALUpdate(dbInfo);
|
|
}
|
|
|
|
private static <DALCLASSNAME> BuildDAL(SqlDataReader reader)
|
|
{
|
|
var dal = new <DALCLASSNAME>();
|
|
|
|
while (reader.Read())
|
|
{
|
|
dal.ID = (<IDTYPE>)reader["ID"];
|
|
<READERPARAMETERS>
|
|
}
|
|
|
|
if (dal.ID == default(<IDTYPE>))
|
|
return null;
|
|
|
|
return dal;
|
|
}
|
|
|
|
internal static <DALCLASSNAME> Get(<IDTYPE> id)
|
|
{
|
|
if (id == default(<IDTYPE>))
|
|
return null;
|
|
|
|
var queryParameters = new List<SqlParameter>
|
|
{
|
|
new SqlParameter("@ID", id)
|
|
};
|
|
|
|
var dbInfo = new dbInfo(
|
|
<CONNECTIONSTRING>,
|
|
"<GETPROCEDURE>",
|
|
queryParameters
|
|
);
|
|
|
|
return EntityHelper.GetEntityDAL(dbInfo, BuildDAL);
|
|
}
|
|
#$@#@ - Unique ID used to find this section, don't change it. 599W#%2
|
|
internal static ICollection<<IDTYPE>> Get<CLASSNAME>IDsBy<FKPROPERTYNAME>(<FKIDTYPE> <FKPROPERTYNAME>)
|
|
{
|
|
if (<FKPROPERTYNAME> == default(<FKIDTYPE>))
|
|
throw new ApplicationException("Required value not specified: <FKPROPERTYNAME>.");
|
|
|
|
var queryParameters = new List<SqlParameter>();
|
|
queryParameters.Add(new SqlParameter("@<FKPROPERTYNAME>", <FKPROPERTYNAME>));
|
|
|
|
return EntityHelper.GetDataEntityIDCollection<<IDTYPE>>(
|
|
new dbInfo(
|
|
<CONNECTIONSTRING>,
|
|
"<CLASSNAME>s_Get<CLASSNAME>IDsBy<FKPROPERTYNAME>",
|
|
queryParameters
|
|
)
|
|
);
|
|
}
|
|
#$@#@2 - Unique ID used to find this section, don't change it. 599W#%44
|
|
}
|
|
}
|