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(); })); }