private void InButton_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
if (CheckDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if (CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[8].Value == null ||
((DateTime)CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[8].Value < (DateTime)CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[9].Value))
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
rq.FFACTDATEBEGIN = DateTime.Now;
rq.FSTATUS = Status.ActiveInput;
rq.FFACTDATEEND = rq.FWHDATEBEGIN = rq.FWHDATEEND = null;
rq.FWHCOMMENT = rq.FWHPERSON = null;
}
InOut io = new InOut
{
FID = id,
FFACTDATEBEGIN = DateTime.Now
};
db.InOut.Add(io);
db.SaveChanges();
}
FillCheck();
}
}
}
}
private void OutButton_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
if (CheckDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if ((CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[8].Value != null && CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[9].Value == null) ||
(DateTime)CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[8].Value > (DateTime)CheckDGV.Rows[CheckDGV.SelectedRows[0].Index].Cells[9].Value)
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
rq.FFACTDATEEND = DateTime.Now;
rq.FSTATUS = Status.ActiveOutput;
}
var io = db.InOut.Where(x => x.FID == id)
.Where(x => x.FFACTDATEEND == null)
.FirstOrDefault();
if (io != null)
{
io.FFACTDATEEND = DateTime.Now;
}
db.SaveChanges();
}
FillCheck();
}
}
}
}
private void ConfirmButton_Click(object sender, EventArgs e)
{
if (RequestDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(RequestDGV.Rows[RequestDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if (MessageBox.Show("Утвердить заявку № " + id.ToString() + "?",
"Утверждение",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Information) == DialogResult.OK)
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
rq.FSTATUS = Status.Approved;
rq.FUTVDATE = DateTime.Now;
db.SaveChanges();
}
}
FillRequestDGV();
}
}
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
if (RequestDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(RequestDGV.Rows[RequestDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if (MessageBox.Show("Вы действительно хотите удалить заявку № " + id.ToString() + "?",
"Удаление",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Warning) == DialogResult.OK)
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
db.Request.Remove(rq);
db.SaveChanges();
}
}
FillRequestDGV();
}
}
}
}
private void OutButton_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
if (WarehouseDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if (WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[8].Value != null &&
WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[9].Value == null &&
WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[7].Value.ToString() == Status.EntryAllowed)
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
rq.FWHDATEEND = DateTime.Now;
rq.FSTATUS = Status.ShipmentCompleted;
}
var io = db.InOut.Where(x => x.FID == id)
.Where(x => x.FFACTDATEEND == null)
.FirstOrDefault();
if (io != null)
{
io.FWHDATEEND = DateTime.Now;
}
db.SaveChanges();
}
FillWarehouse();
}
}
}
}
private void InButton_Click(object sender, EventArgs e)
{
Thread.Sleep(1000);
if (WarehouseDGV.SelectedRows.Count != 0)
{
if (Int32.TryParse(WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[0].Value.ToString(), out int id))
{
if (WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[12].Value == null)
{
MessageBox.Show("Нет комментария склада!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[8].Value == null &&
WarehouseDGV.Rows[WarehouseDGV.SelectedRows[0].Index].Cells[7].Value.ToString() == Status.ActiveInput)
{
using (CheckPoint db = new CheckPoint())
{
var rq = db.Request.Where(x => x.FID == id).FirstOrDefault();
if (rq != null)
{
rq.FWHDATEBEGIN = DateTime.Now;
rq.FWHDATEEND = null;
rq.FSTATUS = Status.EntryAllowed;
}
var io = db.InOut.Where(x => x.FID == id)
.Where(x => x.FFACTDATEEND == null)
.FirstOrDefault();
if (io != null)
{
io.FWHDATEBEGIN = DateTime.Now;;
io.FWHDATEEND = null;
}
db.SaveChanges();
}
FillWarehouse();
}
}
}
}
private void CreateButton_Click(object sender, EventArgs e)
{
if (GuestFIOTB.Text == "" || GuestJobTB.Text == "" || LocationTB.Text == "" || PurposeTB.Text == "" || MeetFIOTB.Text == "" || PhoneTB.Text == "")
{
MessageBox.Show("Заполнены не все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DateTime beginDT = BeginDateDTP.Value.Date.Add(BeginTimeDTP.Value.TimeOfDay);
DateTime endDT = EndDateDTP.Value.Date.Add(EndTimeDTP.Value.TimeOfDay);
DateTime outDT = OutDateDTP.Value.Date.Add(OutTimeDTP.Value.TimeOfDay);
if (beginDT.CompareTo(endDT) >= 0)
{
MessageBox.Show("Время окончания должно быть больше времени начала!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
using (CheckPoint db = new CheckPoint())
{
if (CreateButton.Text == "Создать")
{
if (beginDT.CompareTo(DateTime.Now) < 0)
{
MessageBox.Show("Время начала должны быть больше текущего!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Request rq = new Request
{
FCREATEDATE = DateTime.Now,
FDESCR = SystemInformation.UserName,
FGUESTFIO = GuestFIOTB.Text,
FGUESTJOB = GuestJobTB.Text,
FAUTOMARK = AutoMarkTB.Text,
FAUTONUMBER = AutoNumberTB.Text,
FLOCATION = LocationTB.Text,
FPURPOSE = PurposeTB.Text,
FDATEBEGIN = beginDT,
FDATEEND = endDT,
FMEETFIO = MeetFIOTB.Text,
FPHONE = PhoneTB.Text,
FSTATUS = Status.Initial
};
db.Request.Add(rq);
}
if (CreateButton.Text == "Изменить")
{
if (beginDT.CompareTo(DateTime.Now) < 0)
{
MessageBox.Show("Время начала должны быть больше текущего!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var rq = db.Request.Where(x => x.FID == request_id).FirstOrDefault();
if (rq != null)
{
rq.FGUESTFIO = GuestFIOTB.Text;
rq.FGUESTJOB = GuestJobTB.Text;
rq.FAUTOMARK = AutoMarkTB.Text;
rq.FAUTONUMBER = AutoNumberTB.Text;
rq.FLOCATION = LocationTB.Text;
rq.FPURPOSE = PurposeTB.Text;
rq.FDATEBEGIN = beginDT;
rq.FDATEEND = endDT;
rq.FMEETFIO = MeetFIOTB.Text;
rq.FPHONE = PhoneTB.Text;
rq.FSTATUS = Status.Changed;
}
}
if (CreateButton.Text == "Правка")
{
if (outDT.CompareTo(DateTime.Now) > 0)
{
MessageBox.Show("Время выхода должно быть меньше текущего!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var rq = db.Request.Where(x => x.FID == request_id).FirstOrDefault();
if (rq != null)
{
rq.FGUESTFIO = GuestFIOTB.Text;
rq.FGUESTJOB = GuestJobTB.Text;
rq.FAUTOMARK = AutoMarkTB.Text;
rq.FAUTONUMBER = AutoNumberTB.Text;
rq.FLOCATION = LocationTB.Text;
if (PurposeTB.Text.IndexOf("изменено") != -1)
{
rq.FPURPOSE = PurposeTB.Text.Substring(0, PurposeTB.Text.IndexOf("изменено")).Trim();
}
else
{
rq.FPURPOSE = PurposeTB.Text;
}
rq.FPURPOSE += Environment.NewLine + "изменено " + SystemInformation.UserName + " " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
rq.FDATEBEGIN = beginDT;
rq.FDATEEND = endDT;
rq.FMEETFIO = MeetFIOTB.Text;
rq.FPHONE = PhoneTB.Text;
if (rq.FFACTDATEEND != null)
{
rq.FFACTDATEEND = outDT;
}
}
var io = db.InOut.Where(x => x.FID == request_id)
.OrderByDescending(x => x.FFACTDATEEND)
.FirstOrDefault();
if (io != null && rq.FFACTDATEEND != null)
{
io.FFACTDATEEND = outDT;
}
}
if (CreateButton.Text == "Редактирование")
{
var rq = db.Request.Where(x => x.FID == request_id).FirstOrDefault();
if (rq != null)
{
rq.FWHCOMMENT = WHTB.Text;
rq.FWHPERSON = SystemInformation.UserName;
}
}
try
{
db.SaveChanges();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка обращения к данным!\n" + ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}