protected void btnSubmit_Click(object sender, EventArgs e) { if (CheckValid()) { gtsvn.Tour tour = new gtsvn.Tour { TourNm = txtNm.Text, DescReview = txtDescRev.Text, TourReview = CKEditor1.Text, Description = CKEditor2.Text, TourGroup = Int32.Parse(ddGroup1.SelectedValue), IsPromotion = cbPromotion.Checked, IsProminent = cbProminent.Checked, IsActived = true, InsDate = DateTime.Now }; data.Tour.InsertOnSubmit(tour); try { //submit changes to get new identity userid data.SubmitChanges(); //insert into role int newtourid = (int)tour.TourID; for (int i = 0; i <= lbKind.Items.Count - 1; i++) { if (lbKind.Items[i].Selected) { //insert into UserRole table gtsvn.TourTourKind tourtourkind = new gtsvn.TourTourKind { TourID = newtourid, TourKindID = Int32.Parse(lbKind.Items[i].Value) }; data.TourTourKind.InsertOnSubmit(tourtourkind); } } data.SubmitChanges(); lblStatus.Text = "Thêm thành công tour <b>" + txtNm.Text + "</b>"; ddGroup.SelectedValue = ddGroup1.SelectedValue; SetGridMain(); //reset input field txtNm.Text = ""; txtDescRev.Text = ""; CKEditor1.Text = ""; CKEditor2.Text = ""; ddGroup1.SelectedIndex = 0; cbPromotion.Checked = false; cbProminent.Checked = false; lbKind.SelectedIndex = -1; } catch (Exception ex) { lblStatus.Text = ex.ToString(); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtId.Text != "") { var result = (from t in data.Tour where (int)t.TourID == Int32.Parse(txtId.Text) select t).First(); result.TourNm = txtNm.Text; result.DescReview = txtDescRev.Text; result.TourReview = CKEditor1.Text; result.Description = CKEditor2.Text; result.TourGroup = Int32.Parse(ddGroup1.SelectedValue); result.IsPromotion = (bool)cbPromotion.Checked; result.IsProminent = (bool)cbProminent.Checked; result.InsDate = DateTime.Now; try { data.SubmitChanges(); //delete old tour tourkind var result1 = from t in data.TourTourKind where t.TourID == Int32.Parse(txtId.Text) select t; foreach (var res in result1) { data.TourTourKind.DeleteOnSubmit(res); } data.SubmitChanges(); //insert new tour tourkind for (int i = 0; i <= lbKind.Items.Count - 1; i++) { if (lbKind.Items[i].Selected) { //insert into TourTourKind table gtsvn.TourTourKind tourtourkind = new gtsvn.TourTourKind { TourID = Int32.Parse(txtId.Text), TourKindID = Int32.Parse(lbKind.Items[i].Value) }; data.TourTourKind.InsertOnSubmit(tourtourkind); } } data.SubmitChanges(); lblStatus.Text = "Thay đổi thông tin tour <b>" + txtNm.Text + "</b> thành công"; } catch (Exception ex) { lblStatus.Text = "Có lỗi xảy ra. Chi tiết lỗi: " + ex.ToString(); } } }