public void ImportMember(Models.CreateMemberForImportDo criteria)
{
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Import_Member]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(string), "ImportTransactionID", criteria.ImportTransactionID);
command.AddParameter(typeof(DateTime), "CreateDate", criteria.CreateDate);
command.AddParameter(typeof(string), "CreateUser", criteria.CreateUser);
command.ExecuteNonQuery();
}));
}
public void CreateMemberImport(Models.CreateMemberForImportDo entity)
{
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Create_MemberImport]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(string), "ImportTransactionID", entity.ImportTransactionID);
string memberXml = Utils.ConvertUtil.ConvertToXml_Store <Models.MemberImportDo>(entity.Members);
command.AddParameter(typeof(string), "MemberImportXML", memberXml);
command.AddParameter(typeof(bool), "FlagClear", entity.FlagClear);
command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate);
command.AddParameter(typeof(string), "CreateUser", entity.CreateUser);
command.ExecuteNonQuery();
}));
}
