protected void Page_Load(object sender, EventArgs e) { var code = Request["code"]; using (var db = new DataClasses1DataContext()) { SR = db.ShippingRestriction.Single(x => x.Code == code); SRProducts = db.ShippingRestrictedProduct.Where(x => x.ShippingRestrictionCode == code).ToList(); SRCities = db.ShippingRestrictedCity.Where(x => x.ShippingRestrictionCode == code).ToList(); } }
protected void Create_Click(object sender, EventArgs e) { using (var db = new DataClasses1DataContext()) { ShippingRestriction rest = new ShippingRestriction(); rest.Code = Code.Text; rest.Caption = Caption.Text; rest.Comment = Comment.Text; rest.CityFilterMode = Convert.ToInt32(CityFilterMode.SelectedValue); rest.ProductFilterMode = Convert.ToInt32(ProductFilterMode.SelectedValue); rest.PrefName = PrefName.Text; DateTime dt; if (DateTime.TryParse(BeginDate.Text, out dt)) { rest.BeginDate = dt; } if (DateTime.TryParse(EndDate.Text, out dt)) { rest.EndDate = dt; } var products = new List<ShippingRestrictedProduct>(); foreach (var item in Products.Text.Split(new char[] { ' ', '\t', ',', '、' }).Select(x => x.Trim())) { products.Add(new ShippingRestrictedProduct() { ProductName = item, ShippingRestrictionCode = rest.Code }); } var cities = new List<ShippingRestrictedCity>(); foreach (var item in Cities.Text.Split(new char[] { ' ', '\t', ',', '、' }).Select(x => x.Trim())) { cities.Add(new ShippingRestrictedCity() { CityName = item, ShippingRestrictionCode = rest.Code }); } db.ShippingRestriction.InsertOnSubmit(rest); db.ShippingRestrictedProduct.InsertAllOnSubmit(products); db.ShippingRestrictedCity.InsertAllOnSubmit(cities); db.SubmitChanges(); ClientScript.RegisterStartupScript(typeof(String), "msg", "alert('追加しました。')", true); } }
protected void Insert_Click(object sender, EventArgs e) { var code = Code.Text; using (var db = new DataClasses1DataContext()) { var Model = db.ShippingRestriction.FirstOrDefault(x => x.Code == code); if (Model != null) { ClientScript.RegisterClientScriptBlock(typeof(String), "msg", "alert('すでに使用されているコードが指定されました')", true); return; } Model = new ShippingRestriction(); Model.Code = code; Model.Caption = Caption.Text.Trim(); Model.PrefName = PrefName.Text.Trim(); Model.CityFilterMode = Convert.ToInt32(CityFilterMode.Text); Model.ProductFilterMode = Convert.ToInt32(ProductFilterMode.Text); Model.Comment = Comment.Text.Trim(); DateTime dt; if (DateTime.TryParse(BeginDate.Text, out dt)) { Model.BeginDate = dt; } else { Model.BeginDate = null; } if (DateTime.TryParse(EndDate.Text, out dt)) { Model.EndDate = dt; } else { Model.EndDate = null; } var products_edit = Products.Text.Split(new char[] { ',' }).Select(x => x.Trim()).ToArray(); var cities_edit = Cities.Text.Split(new char[] { ',' }).Select(x => x.Trim()).ToArray(); foreach (var item in products_edit) { db.ShippingRestrictedProduct.InsertOnSubmit(new ShippingRestrictedProduct() { ProductName = item, ShippingRestrictionCode = code }); } foreach (var item in cities_edit) { db.ShippingRestrictedCity.InsertOnSubmit(new ShippingRestrictedCity() { CityName = item, ShippingRestrictionCode = code }); } db.ShippingRestriction.InsertOnSubmit(Model); db.SubmitChanges(); Response.Redirect("srdetail.aspx?code=" + code); } }