//MODIFY
public int mMember(string pMemcoCd, string pMemcoNm, string pUsingFlag, string pSortNo, string pMemo)
{
int reCnt = 0;
DbMember db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMember(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.mMember(pMemcoCd, pMemcoNm, pUsingFlag, pSortNo, pMemo);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::mMember (Detail)::pMemcoCd=[" + pMemcoCd + "], pMemcoNm=[" + pMemcoNm + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::mMember (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
//SELECT -> GridView1
public DataSet sMember(string pMemcoCd)
{
DataSet ds = null;
DbMember db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMember(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sMember(pMemcoCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::sMember (Detail)::pMemcoCd=[" + pMemcoCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::sMember (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public async Task <DbMember> Create(DbMember member)
{
const string memberQuery = @"INSERT INTO Members (SSN, FirstName, LastName, Type, PhoneNr, Email)
VALUES (@ssn, @firstName, @lastName, @type, @phoneNr, @email)";
const string addressQuery = @"INSERT INTO MemberAddresses (Street, Number, AddressType, Country, ZipCode, City, Member_SSN)
OUTPUT INSERTED.Id
VALUES (@street, @number, @addressType, @country, @zipCode, @city, @memberSsn";
var addresses = new List <DbAddress>();
using (var conn = new SqlConnection(_connectionString))
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
await conn.ExecuteAsync(memberQuery, new
{
ssn = member.SSN,
firstName = member.FirstName,
lastName = member.LastName,
type = member.Type,
phoneNr = member.PhoneNr,
email = member.Email
}, trans);
foreach (var address in member.Addresses)
{
var addressId = await conn.ExecuteScalarAsync <int>(addressQuery, new
{
street = address.Street,
number = address.Number,
addressType = address.Type,
country = address.Country,
zipCode = address.ZipCode,
city = address.City,
memberSsn = member.SSN
}, trans);
addresses.Add(GetAddressWithId(addressId, address));
}
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
}
}
member.Addresses = addresses;
return(member);
}
public static DbMember ToDbModel(this MemberDto dto)
{
var dbMember = new DbMember()
{
SSN = dto.SSN,
FirstName = dto.FirstName,
MiddleName = dto.MiddleName,
LastName = dto.LastName,
Type = (EDbMemberType)(int)dto.Type,
PhoneNr = dto.PhoneNr,
Email = dto.Email,
Addresses = dto.Addresses.Select(x => x.ToDbModel())
};
return(dbMember);
}
public static MemberDto ToDto(this DbMember dbMember)
{
var dto = new MemberDto()
{
SSN = dbMember.SSN,
FirstName = dbMember.FirstName,
MiddleName = dbMember.MiddleName,
LastName = dbMember.LastName,
Type = (EMemberTypeDto)(int)dbMember.Type,
PhoneNr = dbMember.PhoneNr,
Email = dbMember.Email,
Addresses = dbMember.Addresses.Select(x => x.ToDto())
};
return(dto);
}
