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