public async Task <int> UpdateBasicMemberAsync(Member member, int memberNo)
{
var updateMember = await(from a in CreditContext.Member
where a.MemberNo == memberNo
select a).SingleOrDefaultAsync();
if (updateMember != null)
{
updateMember.MemberNo = member.MemberNo;
updateMember.RegionNo = member.RegionNo;
updateMember.LastName = member.LastName;
updateMember.Middleinitial = member.Middleinitial;
updateMember.FirstName = member.FirstName;
updateMember.Street = member.Street;
updateMember.City = member.City;
updateMember.StateProv = member.StateProv;
updateMember.PhoneNo = member.PhoneNo;
updateMember.IssueDt = DateTime.Now;
member.MailCode = "33333";
member.Country = "US";
updateMember.ExprDt = DateTime.Now.AddYears(3);
CreditContext.Update(updateMember);
return(1);
}
else
{
return(-1);
}
}
public async Task <int> UpdateRegionAsync(Region region, int regionNo)
{
var updateRegion = await(from a in CreditContext.Region
where a.RegionNo == regionNo
select a).SingleOrDefaultAsync();
if (updateRegion != null)
{
updateRegion.RegionNo = region.RegionNo;
updateRegion.RegionName = region.RegionName;
updateRegion.Street = region.Street;
updateRegion.City = region.City;
updateRegion.StateProv = region.StateProv;
updateRegion.PhoneNo = region.PhoneNo;
updateRegion.MailCode = "33333";
updateRegion.Country = region.Country;
CreditContext.Update(updateRegion);
return(1);
}
else
{
return(-1);
}
}
public async Task <int> UpdateProviderAsync(Provider provider, int providerNo)
{
var updateProvider = await(from a in CreditContext.Provider
where a.ProviderNo == providerNo
select a).SingleOrDefaultAsync();
if (updateProvider != null)
{
updateProvider.RegionNo = provider.RegionNo;
updateProvider.ProviderNo = provider.ProviderNo;
updateProvider.ProviderName = provider.ProviderName;
updateProvider.Street = provider.Street;
updateProvider.City = provider.City;
updateProvider.StateProv = provider.StateProv;
updateProvider.PhoneNo = provider.PhoneNo;
updateProvider.MailCode = "33333";
updateProvider.IssueDt = DateTime.Now;
updateProvider.Country = provider.Country;
updateProvider.ProviderCode = provider.ProviderCode;
CreditContext.Update(updateProvider);
return(1);
}
else
{
return(-1);
}
}
public async Task <int> UpdateCorporationAsync(Corporation corp, int corpNo)
{
var updateCorp = await(from a in CreditContext.Corporation
where a.CorpNo == corpNo
select a).SingleOrDefaultAsync();
if (updateCorp != null)
{
updateCorp.CorpNo = corp.CorpNo;
updateCorp.CorpName = corp.CorpName;
updateCorp.RegionNo = corp.RegionNo;
updateCorp.Street = corp.Street;
updateCorp.City = corp.City;
updateCorp.StateProv = corp.StateProv;
updateCorp.PhoneNo = corp.PhoneNo;
updateCorp.MailCode = "33333";
updateCorp.Country = corp.Country;
updateCorp.ExprDt = DateTime.Now.AddYears(5);
CreditContext.Update(updateCorp);
return(1);
}
else
{
return(-1);
}
}
public async Task <int> UpdateCategoryAsync(Category category, int categoryNo)
{
var updateCategory = await CreditContext.Category.SingleOrDefaultAsync(m => m.CategoryNo == categoryNo);
if (updateCategory != null)
{
updateCategory.CategoryNo = category.CategoryNo;
updateCategory.CategoryDesc = category.CategoryDesc;
updateCategory.CategoryCode = category.CategoryCode;
CreditContext.Update(updateCategory);
return(1);
}
else
{
return(-1);
}
}