public ReturnType AddPostage(Postage postage)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
Postage oldPostage = alading.Postage.FirstOrDefault(p => p.postage_id == postage.postage_id);
if (oldPostage == null)
{
alading.AddToPostage(postage);
}
else
{
oldPostage.name = postage.name;
oldPostage.memo = postage.memo;
oldPostage.post_price = postage.post_price;
oldPostage.post_increase = postage.post_increase;
oldPostage.express_price = postage.express_price;
oldPostage.express_increase = postage.express_increase;
oldPostage.ems_price = postage.ems_price;
oldPostage.ems_increase = postage.ems_increase;
oldPostage.modified = postage.modified;
oldPostage.postage_modes = postage.postage_modes;
oldPostage.created = postage.created;
}
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddPAndPM(List <Postage> postageList, List <PostageMode> postageModeList)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
#region Postage
foreach (Postage postage in postageList)
{
Postage oldPostage = alading.Postage.FirstOrDefault(p => p.postage_id == postage.postage_id);
if (oldPostage == null)
{
alading.AddToPostage(postage);
}
else
{
oldPostage.name = postage.name;
oldPostage.memo = postage.memo;
oldPostage.post_price = postage.post_price;
oldPostage.post_increase = postage.post_increase;
oldPostage.express_price = postage.express_price;
oldPostage.express_increase = postage.express_increase;
oldPostage.ems_price = postage.ems_price;
oldPostage.ems_increase = postage.ems_increase;
oldPostage.modified = postage.modified;
oldPostage.postage_modes = postage.postage_modes;
oldPostage.created = postage.created;
}
}
#endregion
#region PostageMode
foreach (PostageMode postagemode in postageModeList)
{
PostageMode oldPostageMode = alading.PostageMode.FirstOrDefault(p => p.id == postagemode.id);
if (oldPostageMode == null)
{
alading.AddToPostageMode(postagemode);
}
else
{
oldPostageMode.postage_id = postagemode.postage_id;
oldPostageMode.id = postagemode.id;
oldPostageMode.dests = postagemode.dests;
oldPostageMode.increase = postagemode.increase;
oldPostageMode.type = postagemode.type;
oldPostageMode.price = postagemode.price;
}
}
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
