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