public List<CoCard.Choice> getDiscount(int campaign_id) { List<CoCard.Choice> discount = new List<CoCard.Choice>(); using (CoCardDataContext bx = new CoCardDataContext()) { var data = bx.MAS_FORM_CO_CARD_CHOICEs.Where(s => s.CAMPAIGN__ID == campaign_id && s.CFLAG == 0).OrderBy(s => s.CHOICE_NO).Select(s => new { s.CHOICE_NO, s.CHOICE_CAPTION }).ToList(); foreach (var item in data) { discount.Add(new CoCard.Choice { CHOICE_NO = item.CHOICE_NO, CHOICE_CAPTION = item.CHOICE_CAPTION }); } return discount; } }
public string SaveRight(List<CoCard.CoCardList> item) { string sms; string whname; using (MasterITDataContext bx = new MasterITDataContext()) { var dt = bx.MAS_WHs.Where(s => s.WHCODE == item[0].Whcode).FirstOrDefault(); whname = dt.WHNAME; } using (CoCardDataContext bx = new CoCardDataContext()) { try { var cc = new TRN_FORM_CO_CARD(); cc.CAMPAIGN_ID = item[0].Campaign_id; cc.WORKDATE = item[0].Workdate.AddHours(7); cc.ABBNO = item[0].Abbno; cc.ADDR_FULLNAME = item[0].Addr_Fullname; cc.ADDR_MOBILE = item[0].Addr_Mobile; cc.WHCODE = item[0].Whcode; cc.WHNAME = whname; cc.STCODE = item[0].Stcode; cc.STNAME = item[0].Stname; cc.FLAG = item[0].FLAG; cc.DISCOUNT = item[0].Discount; cc.SYSCRATE = item[0].SysCreate.AddHours(7); bx.TRN_FORM_CO_CARDs.InsertOnSubmit(cc); bx.SubmitChanges(); sms = "บันทึกสำเร็จ"; } catch (Exception ex) { sms = "ไม่สำเร็จ\n" + ex.Message; } } return sms; }