public static t_reservation getSingleFacility_reservation_code(string facility_reservation_code)
{
t_reservation res = null;
using (var dbc = new DBConnect())
{
res = dbc.t_reservation.SingleOrDefault(x => x.facility_reservation_code == facility_reservation_code);
}
return(res);
}
public static t_reservation getSingleCostume_reservation_code(string costume_reservation_code)
{
t_reservation res = null;
using (var dbc = new DBConnect())
{
res = dbc.t_reservation.SingleOrDefault(x => x.costume_reservation_code == costume_reservation_code);
}
return(res);
}
private void b_regist_Click(object sender, EventArgs e)
{
//入力チェック
chk.clear();
chk.addControl(d_Shooting_purpose);
chk.addControl(d_facility);
//chk.addControl(t_name);
//chk.addControl(t_name_kana);
//chk.addControl(d_sex2);
//chk.addControl(d_height);
//chk.addControl(d_foot);
//chk.addControl(d_sleeve);
if (chk.check("W00000", chk.checkControlImportant))
{
return;
}
//桁数チェック
//20
chk.clear();
chk.addControl(d_facility);
chk.addControl(t_name);
if (chk.check("W00001", chk.checkTextboxLength, 20))
{
return;
}
//40
chk.clear();
chk.addControl(t_name_kana);
if (chk.check("W00001", chk.checkTextboxLength, 40))
{
return;
}
//4
chk.clear();
chk.addControl(d_height);
chk.addControl(d_foot);
chk.addControl(d_sleeve);
if (chk.check("W00001", chk.checkTextboxLength, 4))
{
return;
}
//フォーマットチェック
chk.clear();
chk.addControl(d_height);
chk.addControl(d_foot);
chk.addControl(d_sleeve);
if (chk.check("W00003", chk.checkTextboxFormat, @"\d{1,4}?\z", @"半角数字"))
{
return;
}
for (int i = 0; d_renral_result.Rows.Count > i; i++)
{
if (costumeReservationList[i].costume_reservation_code == "")
{
costumeReservationList[i].costume_reservation_code = DB.t_costume_reservation.getNewcostume_reservation_code();
}
costumeReservationList[i].memo = d_renral_result.Rows[i].Cells[11].Value == null ? "" : d_renral_result.Rows[i].Cells[11].Value.ToString();
if (d_Cancellation_date.Checked)
{
costumeReservationList[i].cancellation_date = d_Cancellation_date.Value;
}
else
{
costumeReservationList[i].cancellation_date = null;
}
costumeReservationList[i].shooting_purpose = Enum.GetNames(typeof(Utile.Data.撮影目的)).ToList()[d_Shooting_purpose.SelectedIndex];
costumeReservationList[i].facility = d_facility.Text;
costumeReservationList[i].name = t_name.Text;
costumeReservationList[i].name_kana = t_name_kana.Text;
if (d_sex2.SelectedIndex != -1)
{
costumeReservationList[i].sex = d_sex2.SelectedIndex.ToString();
}
else
{
costumeReservationList[i].sex = null;
}
if (dt_birthday.Checked)
{
costumeReservationList[i].birthday = dt_birthday.Value;
}
else
{
costumeReservationList[i].birthday = null;
}
if (d_height.Text != "")
{
costumeReservationList[i].height = int.Parse(d_height.Text);
}
else
{
costumeReservationList[i].height = null;
}
if (d_foot.Text != "")
{
costumeReservationList[i].foot = int.Parse(d_foot.Text);
}
else
{
costumeReservationList[i].foot = null;
}
if (d_sleeve.Text != "")
{
costumeReservationList[i].sleeve = int.Parse(d_sleeve.Text);
}
else
{
costumeReservationList[i].sleeve = null;
}
costumeReservationList[i].Command();
var res = new DB.t_reservation();
res.costume_reservation_code = costumeReservationList[i].costume_reservation_code;
res.reservation_code = MainForm.session_t_reception.reception_code;
res.facility_reservation_code = " ";
res.Command();
}
pageParent.PageRefresh();
MainForm.backPage(this);
}
private void b_regist_Click(object sender, EventArgs e)
{
if (d_check.Checked)
{
// 必須チェック
chk.clear();
chk.addControl(d_start_time);
chk.addControl(d_end_time);
if (chk.check("W00000", chk.checkControlImportant))
{
return;
}
chk.clear();
//フォーマットチェック
chk.addControl(d_start_time);
chk.addControl(d_end_time);
if (chk.check("W00003", chk.checkTextboxFormat, @"^([0-9]|[0-1][0-9]|[2][0-3]):[0-5][0-9]$", "00:00"))
{
return;
}
chk.clear();
//桁数チェック
chk.addControl(d_start_time);
chk.addControl(d_end_time);
if (chk.check("W00001", chk.checkTextboxLength, 5))
{
return;
}
chk.clear();
chk.addControl(d_tekiyou);
if (chk.check("W00001", chk.checkTextboxLength, 256))
{
return;
}
chk.clear();
//施設予約登録処理（スケジュール）
if (facility_reservation.facility_reservation_code == null)
{
facility_reservation.facility_reservation_code = DB.t_facility_reservation.getNewFacility_reservation_code();
}
facility_reservation.start_date = d_start_date.Value;
facility_reservation.start_time = TimeSpan.Parse(d_start_time.Text);
facility_reservation.end_date = d_end_date.Value;
facility_reservation.end_time = TimeSpan.Parse(d_end_time.Text);
facility_reservation.reservator = null;
facility_reservation.remarks = d_tekiyou.Text;
facility_reservation.cancellation_date = null;
facility_reservation.shooting_purpose = null;
facility_reservation.photographer = null;
facility_reservation.task_class = null;
facility_reservation.selection_start_date = null;
facility_reservation.selection_start_time = null;
facility_reservation.selection_end_date = null;
facility_reservation.selection_end_time = null;
facility_reservation.selector = null;
facility_reservation.store_code = DB.m_store.getSingleName(d_tenpomei.SelectedItem.ToString()).store_code;
facility_reservation.facility_code = MainForm.Reservation_timetable.scheduleLabel;
facility_reservation.order_code = null; //DOTO:特に入力するものが無いため取りあえずNULLを入れる
//重複チェック
using (var dbc = new DB.DBConnect())
{
var frStart = new DateTime(facility_reservation.start_date.Year, facility_reservation.start_date.Month, facility_reservation.start_date.Day,
facility_reservation.start_time.Hours, facility_reservation.start_time.Minutes, 0);
var frEnd = new DateTime(facility_reservation.end_date.Year, facility_reservation.end_date.Month, facility_reservation.end_date.Day,
facility_reservation.end_time.Hours, facility_reservation.end_time.Minutes, 0);
var q = from t in dbc.t_facility_reservation
select t;
foreach (var data in q)
{
var dStart = new DateTime(data.start_date.Year, data.start_date.Month, data.start_date.Day, data.start_time.Hours, data.start_time.Minutes, 0);
var dEnd = new DateTime(data.end_date.Year, data.end_date.Month, data.end_date.Day, data.end_time.Hours, data.end_time.Minutes, 0);
if (data.facility_code == facility_reservation.facility_code &&
data.store_code == facility_reservation.store_code &&
!(dEnd <= frStart || dStart >= frEnd))
{
Utile.Message.showMessageOK("I03009");
return;
}
}
}
facility_reservation.Command();
//リスト更新
if (MainForm.session_t_reception != null)
{
setYoyakuTabList(MainForm.session_t_reception.reception_code);
}
sescheduleTabList(facility_reservation.start_date, facility_reservation.store_code);
Utile.Message.showMessageOK("I03003");
}
else
{
// 必須チェック
chk.clear();
chk.addControl(d_tenpomei);
chk.addControl(d_shisetumei);
chk.addControl(d_satueisya);
chk.addControl(d_select_name);
chk.addControl(d_tasukukubun);
chk.addControl(d_satsueimokuteki);
chk.addControl(d_start_time);
chk.addControl(d_end_time);
chk.addControl(d_yoyakusya);
if (chk.check("W00000", chk.checkControlImportant))
{
return;
}
chk.clear();
//フォーマットチェック
chk.addControl(d_start_time);
chk.addControl(d_end_time);
if (d_select_start_time.Text != "")
{
chk.addControl(d_select_start_time);
}
if (d_select_end_time.Text != "")
{
chk.addControl(d_select_end_time);
}
if (chk.check("W00003", chk.checkTextboxFormat, @"^([0-9]|[0-1][0-9]|[2][0-3]):[0-5][0-9]$", "00:00"))
{
return;
}
chk.clear();
//桁数チェック
chk.addControl(d_start_time);
chk.addControl(d_end_time);
if (d_select_start_time.Text != "")
{
chk.addControl(d_select_start_time);
}
if (d_select_end_time.Text != "")
{
chk.addControl(d_select_end_time);
}
if (chk.check("W00001", chk.checkTextboxLength, 5))
{
return;
}
chk.clear();
chk.addControl(d_yoyakusya);
if (chk.check("W00001", chk.checkTextboxLength, 20))
{
return;
}
chk.clear();
chk.addControl(d_tekiyou);
if (chk.check("W00001", chk.checkTextboxLength, 256))
{
return;
}
chk.clear();
//施設予約登録処理
if (facility_reservation.facility_reservation_code == null)
{
facility_reservation.facility_reservation_code = DB.t_facility_reservation.getNewFacility_reservation_code();
}
facility_reservation.start_date = d_start_date.Value;
facility_reservation.start_time = TimeSpan.Parse(d_start_time.Text);
facility_reservation.end_date = d_end_date.Value;
facility_reservation.end_time = TimeSpan.Parse(d_end_time.Text);
facility_reservation.reservator = d_yoyakusya.Text;
facility_reservation.remarks = d_tekiyou.Text;
if (d_tyushi.Checked)
{
facility_reservation.cancellation_date = d_tyushi.Value;
}
else
{
facility_reservation.cancellation_date = null;
}
facility_reservation.shooting_purpose = ((Utile.Data.撮影目的)(d_satsueimokuteki.SelectedIndex)).ToString();
facility_reservation.photographer = d_satueisya.Text;
facility_reservation.task_class = DB.m_task.getSingleName(d_tasukukubun.SelectedItem.ToString()).task_class;
if (d_select_start_time.Text == "")
{
facility_reservation.selection_start_date = null;
facility_reservation.selection_start_time = null;
}
else
{
facility_reservation.selection_start_date = d_select_start_date.Value;
facility_reservation.selection_start_time = TimeSpan.Parse(d_select_start_time.Text);
}
if (d_select_end_time.Text == "")
{
facility_reservation.selection_end_date = null;
facility_reservation.selection_end_time = null;
}
else
{
facility_reservation.selection_end_date = d_select_end_date.Value;
facility_reservation.selection_end_time = TimeSpan.Parse(d_select_end_time.Text);
}
facility_reservation.selector = d_select_name.SelectedItem.ToString();
facility_reservation.store_code = DB.m_store.getSingleName(d_tenpomei.SelectedItem.ToString()).store_code;
facility_reservation.facility_code = DB.m_facility.getSingleName(facility_reservation.store_code, d_shisetumei.SelectedItem.ToString()).facility_code;
facility_reservation.order_code = null; //DOTO:特に入力するものが無いため取りあえずNULLを入れる
//重複チェック
using (var dbc = new DB.DBConnect())
{
var frStart = new DateTime(facility_reservation.start_date.Year, facility_reservation.start_date.Month, facility_reservation.start_date.Day,
facility_reservation.start_time.Hours, facility_reservation.start_time.Minutes, 0);
var frEnd = new DateTime(facility_reservation.end_date.Year, facility_reservation.end_date.Month, facility_reservation.end_date.Day,
facility_reservation.end_time.Hours, facility_reservation.end_time.Minutes, 0);
var q = from t in dbc.t_facility_reservation
select t;
foreach (var data in q)
{
var dStart = new DateTime(data.start_date.Year, data.start_date.Month, data.start_date.Day, data.start_time.Hours, data.start_time.Minutes, 0);
var dEnd = new DateTime(data.end_date.Year, data.end_date.Month, data.end_date.Day, data.end_time.Hours, data.end_time.Minutes, 0);
if (data.facility_code == facility_reservation.facility_code &&
data.store_code == facility_reservation.store_code &&
!(dEnd <= frStart || dStart >= frEnd))
{
Utile.Message.showMessageOK("I03009");
return;
}
}
}
facility_reservation.Command();
//予約登録処理
DB.t_reservation reservation = new DB.t_reservation();
reservation.reservation_code = MainForm.session_t_reception.reception_code;
reservation.facility_reservation_code = facility_reservation.facility_reservation_code;
reservation.costume_reservation_code = " ";
reservation.Command();
//撮影データ登録処理
DB.t_shooting_data shooting_data = DB.t_shooting_data.getSingle(MainForm.session_t_reception.customer_code,
d_start_date.Value,
MainForm.session_t_reception.reception_code);
if (shooting_data == null)
{
shooting_data = new DB.t_shooting_data();
int index = 1;
string folder = null;
while (true)
{
folder = d_start_date.Value.ToString("yyyyMMdd") + "-" + index.ToString() + "-" + DB.m_customer.getSingle(MainForm.session_t_reception.customer_code).surname;
if (DB.t_shooting_data.chkFolder(folder))
{
break;
}
index++;
}
shooting_data.customer_code = MainForm.session_t_reception.customer_code;
shooting_data.shooting_date = d_start_date.Value;
shooting_data.folder = folder;
shooting_data.select_class = "2";
shooting_data.images = 0;
shooting_data.reception_code = MainForm.session_t_reception.reception_code;
shooting_data.Command();
// フォルダ作成
var photo_root = System.Configuration.ConfigurationManager.AppSettings["photo_root"];
var Photographer_Select = System.Configuration.ConfigurationManager.AppSettings["Photographer_Select"];
var Photographer_Select_dir = System.IO.Path.Combine(photo_root, Photographer_Select);
var folderPath = System.IO.Path.Combine(Photographer_Select_dir, folder);
folderPath = System.IO.Path.GetFullPath(folderPath);
if (System.IO.Directory.Exists(folderPath))
{
Utile.Message.showMessageOK("I03008");
}
else
{
System.IO.Directory.CreateDirectory(folderPath);
}
}
//リスト更新
if (MainForm.session_t_reception != null)
{
setYoyakuTabList(MainForm.session_t_reception.reception_code);
}
sescheduleTabList(facility_reservation.start_date, facility_reservation.store_code);
Utile.Message.showMessageOK("I03001");
}
//更新チェックリセット
mod.reset();
}
