public ReturnType RemoveTradeRefundMessage(int refundid)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<TradeRefundMessage> list = alading.TradeRefundMessage.Where(p => p.TradeRefundMessageID == traderefundmessageID).ToList();*/
List <TradeRefundMessage> list = alading.TradeRefundMessage.Where(p => p.refund_id == refundid).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
TradeRefundMessage sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddTradeRefundMessage(TradeRefundMessage traderefundmessage)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToTradeRefundMessage(traderefundmessage);
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 UpdateTradeRefundMessage(TradeRefundMessage traderefundmessage)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*TradeRefundMessage result = alading.TradeRefundMessage.Where(p => p.TradeRefundMessageID == traderefundmessage.TradeRefundMessageID).FirstOrDefault();*/
TradeRefundMessage result = alading.TradeRefundMessage.Where(p => p.refund_id == traderefundmessage.refund_id).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("TradeRefundMessage", traderefundmessage);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.id = traderefundmessage.id;
*
* result.refund_id = traderefundmessage.refund_id;
*
* result.owner_id = traderefundmessage.owner_id;
*
* result.owner_nick = traderefundmessage.owner_nick;
*
* result.owner_role = traderefundmessage.owner_role;
*
* result.content = traderefundmessage.content;
*
* result.pic_urls = traderefundmessage.pic_urls;
*
* result.created = traderefundmessage.created;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
return(ReturnType.OthersError);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateTradeRefundMessage(int refundid, TradeRefundMessage traderefundmessage)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.TradeRefundMessage.Where(p => p.TradeRefundMessageID == traderefundmessageID).ToList();*/
var result = alading.TradeRefundMessage.Where(p => p.refund_id == refundid).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
TradeRefundMessage ob = result.First();
ob.id = traderefundmessage.id;
ob.refund_id = traderefundmessage.refund_id;
ob.owner_id = traderefundmessage.owner_id;
ob.owner_nick = traderefundmessage.owner_nick;
ob.owner_role = traderefundmessage.owner_role;
ob.content = traderefundmessage.content;
ob.pic_urls = traderefundmessage.pic_urls;
ob.created = traderefundmessage.created;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public static ReturnType UpdateTradeRefundMessage(int traderefundmessageCode, TradeRefundMessage traderefundmessage)
{
return(DataProviderClass.Instance().UpdateTradeRefundMessage(traderefundmessageCode, traderefundmessage));
}
public static ReturnType AddTradeRefundMessage(TradeRefundMessage traderefundmessage)
{
return(DataProviderClass.Instance().AddTradeRefundMessage(traderefundmessage));
}
