private void attach_T_SCHEDULE(T_SCHEDULE entity)
{
this.SendPropertyChanging();
entity.M_User = this;
}
private void detach_T_SCHEDULE(T_SCHEDULE entity)
{
this.SendPropertyChanging();
entity.M_User = null;
}
partial void DeleteT_SCHEDULE(T_SCHEDULE instance);
partial void UpdateT_SCHEDULE(T_SCHEDULE instance);
partial void InsertT_SCHEDULE(T_SCHEDULE instance);
private void detach_T_SCHEDULE(T_SCHEDULE entity)
{
this.SendPropertyChanging();
entity.M_TITLE_COLOR = null;
}
/**
* 登録又は更新ボタン押下時
**/
protected void Insert_Click(object sender, EventArgs e)
{
StartTimeError.Text = "";
EndTimeError.Text = "";
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ToString());
//SqlCommand cmd;
//SqlDataAdapter adapter = new SqlDataAdapter();
string buttonId = ((Button)sender).ID;
string id = buttonId;
int startYear = Convert.ToInt32(Request["startYear"]);
int startMonth = Convert.ToInt32(Request["startMonth"]);
int startDay = Convert.ToInt32(Request["startDay"]);
int startOclock = Convert.ToInt32(Request["startOclock"]);
int startMinute = Convert.ToInt32(Request["startMinute"]);
int endYear = int.Parse(Request["endYear"]);
int endMonth = int.Parse(Request["endMonth"]);
int endDay = int.Parse(Request["endDay"]);
int endOclock = int.Parse(Request["endOclock"]);
int endMinute = int.Parse(Request["endMinute"]);
string title = Request["title"];
if (title.Contains("'"))
{
title = Regex.Replace(title, "'", "''");
}
int titleColor = int.Parse(Request["titleColor"]);
string description = Request["description"];
if (description.Contains("'"))
{
description = Regex.Replace(description, "'", "''");
}
string note = Request["note"];
if (note.Contains("'"))
{
note = Regex.Replace(note, "'", "''");
}
int insertOrUpdateUser = (int)Session["userId"];
int editAuthority = insertOrUpdateUser;
if (startDay <= DateTime.DaysInMonth(startYear, startMonth) && endDay <= DateTime.DaysInMonth(endYear, endMonth))
{
//try
//{
DateTime startTime = new DateTime(startYear, startMonth, startDay, startOclock, startMinute, 00, 00);
DateTime endTime = new DateTime(endYear, endMonth, endDay, endOclock, endMinute, 00, 00);
DateTime now = DateTime.Now;
//con.Open();
//登録ボタン押下時
if (buttonId == "Insert")
{
var db = new DataClasses1DataContext(ConfigurationManager.ConnectionStrings["connection"].ToString());
T_SCHEDULE scedule = new T_SCHEDULE
{
START_TIMESTAMP = startTime,
END_TIMESTAMP = endTime,
TITLE = title,
TITLE_COLOR = titleColor,
DESCRIPTION = description,
NOTE = note,
EDIT_AUTHORITY = editAuthority,
RELEASE_FLG = '0',
INSERT_DATE = now,
INSERT_USER = insertOrUpdateUser,
DELETE_FLG = '0'
};
db.T_SCHEDULE.InsertOnSubmit(scedule);
try
{
db.SubmitChanges();
Server.Transfer("~/Views/SchedulingIsOk.aspx");
}
catch (Exception insertError)
{
InsertError.Text = "登録エラーが発生しました";
db.SubmitChanges();
}
////INSERT SQL文
//string insertQuery = "INSERT INTO T_SCHEDULE (" +
//"START_TIMESTAMP, END_TIMESTAMP, TITLE, TITLE_COLOR, DESCRIPTION, NOTE, " +
//"EDIT_AUTHORITY, RELEASE_FLG, INSERT_DATE, INSERT_USER, DELETE_FLG " +
//")" +
//" VALUES (" +
//"'" + startTime + "', '" + endTime + "', '" + title + "', '" + titleColor + "', '" + description + "', '" + note + "', '" +
//editAuthority + "'," + "0, '" + now + "', '" + insertOrUpdateUser + "'," + "0" +
//");";
//cmd = new SqlCommand(insertQuery, con);
//adapter.InsertCommand = new SqlCommand(insertQuery, con);
////sql実行
//adapter.InsertCommand.ExecuteNonQuery();
//cmd.Dispose();
}
//更新ボタン押下時
else if (buttonId == "Update")
{
Update_Click(startTime, endTime, title,
titleColor, description, note, editAuthority);
}
//}
//catch (Exception exception)
//{
// Console.WriteLine(exception.Message);
// throw;
//}
//finally
//{
// con.Close();
// Server.Transfer("~/Views/SchedulingIsOk.aspx");
//}
}
else
{
//存在しない日付が選択された場合(EX.2月31日)
if (DateTime.DaysInMonth(startYear, startMonth) < startDay)
{
StartTimeError.Text = "[開始日]は存在しない日付です。正しい日付を入力してください。";
}
if (DateTime.DaysInMonth(endYear, endMonth) < endDay)
{
EndTimeError.Text = "[終了日]は存在しない日付です。正しい日付を入力してください。";
}
}
}
