private void Btn_Enter_Click(object sender, EventArgs e)
//checks if textbox id null/blank
{
if (string.IsNullOrEmpty(tb_TM.Text) || string.IsNullOrWhiteSpace(tb_TM.Text))
{
MessageBox.Show("Please ensure all information is provided");
}
else
{
db.closeConnection(); // close db connection for new method
SqlCommand cmd = db.createService(); // this function will add to the DB
cmd.Parameters.Add("@Vehicle_Make", cb_VehicleMake.Text);
cmd.Parameters.Add("@Vehicle_Model", tb_Model.Text);
cmd.Parameters.Add("@Number_Plate", cb_NP.Text);
cmd.Parameters.Add("@Total_Milage", tb_TM.Text);
cmd.Parameters.Add("@Date", DTP.Value.Date);
cmd.Parameters.Add("@Vehicle_ID", Vehicle_ID);
cmd.ExecuteNonQuery(); // initiate the save to db
// clear textboxs
tb_Model.ResetText();
tb_TM.ResetText();
DTP.ResetText();
db.closeConnection();
db.ChangeV_Incident(Vehicle_ID.ToString());
}
}
private void SetFormatDTP()
{
SetCellFormat("Сумма возмещения", "N2");
DTPList dtpList = DTPList.getInstance();
foreach (DataGridViewRow row in _dgv.Rows)
{
int id;
int.TryParse(row.Cells[0].Value.ToString(), out id);
DTP dtp = dtpList.getItem(id);
if (dtp.GetCurrentStatusAfterDTP() == "Отремонтирован")
{
row.Cells["Текущее состояние"].Style.BackColor = BBColors.bbGreen3;
if (row.Cells["Сумма возмещения"].Value.ToString() == "0")
{
row.Cells["Сумма возмещения"].Style.BackColor = Color.MediumPurple;
}
}
else
{
row.Cells["Текущее состояние"].Style.BackColor = Color.White;
}
}
}
public string GetStatus()
{
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.GetLast(this);
StatusAfterDTPs statusAfterDTPs = StatusAfterDTPs.getInstance();
string statusAfterDTP = statusAfterDTPs.getItem(Convert.ToInt32(dtp.IDStatusAfterDTP));
CarSaleList carSaleList = CarSaleList.getInstance();
CarSale carSale = carSaleList.getItem(ID);
if (info.IsSale && carSale.Date != string.Empty)
{
return("продан");
}
if (info.IsSale)
{
return("на продажу");
}
if (!this.IsGet)
{
return("покупка");
}
if (statusAfterDTP == "А/м НЕ на ходу")
{
return("в ремонте");
}
return("на ходу");
}
private ToolStripMenuItem CreateShowNotice()
{
ToolStripMenuItem item = CreateItem("Извещение о страховом случае");
item.Click += delegate
{
Car car = _dgvMain.GetCar();
if (car == null)
{
return;
}
if (_mainStatus.Get() == Status.DTP)
{
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.getItem(_dgvMain.GetID());
CreateDocument doc = new CreateDocument(car);
doc.showNotice(dtp);
}
else
{
MessageBox.Show("Для формирования извещения необходимо перейти на вид \"ДТП\"", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
};
return(item);
}
public void ShowNotice(DTP dtp)
{
_excelDoc = openDocumentExcel("Извещение о страховом случае");
var owners = Owners.getInstance();
_excelDoc.setValue(6, 5, owners.getItem(Convert.ToInt32(_car.ownerID))); //страхователь
_excelDoc.setValue(7, 6, "а/я 34, 196128"); //почтовый адрес
_excelDoc.setValue(8, 7, "320-40-04"); //телефон
var driverCarList = DriverCarList.getInstance();
var driver = driverCarList.GetDriver(_car, dtp.Date);
var passportList = PassportList.getInstance();
var passport = passportList.getLastPassport(driver);
if (passport.Number != string.Empty)
{
var number = passport.Number;
var numbers = number.Split(' ');
_excelDoc.setValue(10, 3, numbers[0]); //серия
_excelDoc.setValue(10, 6, numbers[1]); //номер
_excelDoc.setValue(11, 3, passport.GiveOrg); //кем выдан
_excelDoc.setValue(12, 4, passport.GiveDate.ToShortDateString()); //дата выдачи
}
var policyList = PolicyList.getInstance();
var policy = policyList.getItem(_car, PolicyType.КАСКО);
_excelDoc.setValue(14, 6, policy.Number); //полис
_excelDoc.setValue(16, 6, string.Concat(_car.Mark.Name, " ", _car.info.Model)); //марка а/м
_excelDoc.setValue(18, 6, _car.Grz); //рег номер а/м
_excelDoc.setValue(20, 6, _car.vin); //вин
_excelDoc.setValue(22, 6, dtp.Date.ToShortDateString()); //дата дтп
_excelDoc.setValue(27, 2, driver.GetName(NameType.Full)); //водитель фио
var regions = Regions.getInstance();
_excelDoc.setValue(29, 3, regions.getItem(Convert.ToInt32(dtp.IDRegion))); //город
_excelDoc.setValue(31, 14, dtp.Damage); //повреждения
_excelDoc.setValue(33, 2, dtp.Facts); //обстоятельства происшествия
//SsDTP ssDTP = SsDTPList.getInstance().getItem(_car.Mark);
//_excelDoc.setValue(63, 11, ssDTP.ServiceStantion);
//DateTime date = DateTime.Today;
//MyDateTime myDate = new MyDateTime(date.ToShortDateString());
//_excelDoc.setValue(71, 3, string.Concat("« ", date.Day.ToString(), " »"));
//_excelDoc.setValue(71, 4, myDate.MonthToStringGenitive());
//_excelDoc.setValue(71, 8, date.Year.ToString().Substring(2, 2));
_excelDoc.Show();
}
public void Delete(int idDTP)
{
DTP dtp = getItem(idDTP);
list.Remove(dtp);
dtp.Delete();
}
public DTP_AddEdit(DTP dtp)
{
InitializeComponent();
_dtpFileList = DTPFileList.getInstance();
_dtp = dtp;
}
///<Summary>
///<CreatedOn>08/09/2017</CreatedOn>
///<Author>Sunny Bhardwaj</Author>
///<Description>Returns object for DTP segment</Description>
///</Summary>
public static DTP GetDTP(string DTP01, string DTP02, string DTP03)
{
DTP dtp = new DTP();
dtp.DTP01 = DTP01;
dtp.DTP02 = DTP02;
dtp.DTP03 = DTP03;// CreateString(DTP03, (int)SegmentLength.One, (int)SegmentLength.ThirtyFive, ' ', true); //CreateString(Convert.ToDateTime(DTP03).ToString("yyyyMMdd"), (int)SegmentLength.One, (int)SegmentLength.ThirtyFive, ' ', true);
return(dtp);
}
public void Add(DTP dtp)
{
if (list.Exists(item => item == dtp))
{
return;
}
list.Add(dtp);
}
private void FillDTP()
{
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.getLastByDriver(_driver);
if (dtp != null)
{
dtpInfo.Text = dtp.ToString();
}
}
public ActionResult Delete(int id)
{
DTP b = context.Dtps.Find(id);
if (b == null)
{
return(HttpNotFound());
}
return(View(b));
}
public ActionResult Create(DTP dtp)
{
IEnumerable <DTP> dtps = context.Dtps;
ViewBag.Dtps = dtps;
context.Dtps.Add(dtp);
context.SaveChanges();
return(RedirectToAction("Create"));
}
private void driverLicenseToolStripMenuItem_Click(object sender, EventArgs e)
{
DTP dtp = _dtpList.getItem(Convert.ToInt32(_dgvDTP.Rows[_dgvDTP.SelectedCells[0].RowIndex].Cells[0].Value));
Driver driver = _driverCarList.GetDriver(dtp.Car, dtp.Date);
LicenseList licencesList = LicenseList.getInstance();
DriverLicense driverLicense = licencesList.getItem(driver);
WorkWithFiles.OpenFile(driverLicense.File);
}
protected override void LoadFromSql()
{
list.Clear();
DataTable dt = Provider.Select("DTP");
foreach (DataRow row in dt.Rows)
{
DTP dtp = new DTP(row);
Add(dtp);
}
}
private void _dgvDTP_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (isCellNoHeader(e.RowIndex))
{
int idDTP = Convert.ToInt32(_dgvDTP.Rows[e.RowIndex].Cells[0].Value);
DTP dtp = dtpList.getItem(idDTP);
DTP_AddEdit aedtp = new DTP_AddEdit(dtp);
aedtp.ShowDialog();
}
}
public ActionResult Shtraf(int id)
{
ViewBag.ProductId = id;
DTP dtp = context.Dtps.Find(id);
if (dtp != null)
{
return(View(dtp));
}
return(View("Buy"));
}
private void messageToolStripMenuItem_Click(object sender, EventArgs e)
{
int idDTP = 0;
int.TryParse(_dgvDTP.Rows[_dgvDTP.SelectedCells[0].RowIndex].Cells[0].Value.ToString(), out idDTP);
DTP dtp = _dtpList.getItem(idDTP);
CreateDocument doc = new CreateDocument(_car);
doc.ShowNotice(dtp);
}
public ActionResult DeleteConfirmed(int id)
{
DTP b = context.Dtps.Find(id);
if (b == null)
{
return(HttpNotFound());
}
context.Dtps.Remove(b);
context.SaveChanges();
return(RedirectToAction("Index"));
}
private void _dgvDTP_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int idDTP = Convert.ToInt32(_dgvDTP.Rows[e.RowIndex].Cells[0].Value);
DTP dtp = _dtpList.getItem(idDTP);
DTP_AddEdit dtpAE = new DTP_AddEdit(dtp);
if (dtpAE.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
loadDTP();
}
}
private void btnAddDTP_Click(object sender, EventArgs e)
{
DTP dtp = _car.createDTP();
DTP_AddEdit dtpAE = new DTP_AddEdit(dtp);
if (dtpAE.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
_dtpList.Add(dtp);
loadDTP();
}
}
public ActionResult Add(DTP dtp)
{
if (!ModelState.IsValid)
{
Response.Write("<script>window.alert('Заповніть всі поля!');</script>");
return(View());
}
else
{
context.Dtps.Add(dtp);
context.SaveChanges();
return(RedirectToAction("../home/"));
}
}
public ActionResult Delete(int id)
{
IEnumerable <DTP> dtps = context.Dtps;
ViewBag.Dtps = dtps;
DTP dtp = context.Dtps.Find(id);
if (dtp != null)
{
context.Dtps.Remove(dtp);
context.SaveChanges();
}
return(RedirectToAction("Create"));
}
public ActionResult EditDTP(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
DTP dtp = context.Dtps.Find(id);
if (dtp != null)
{
return(View(dtp));
}
return(HttpNotFound());
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
DTP dtp = context.Dtps.Find(id);
ViewBag.Pdrs = context.Pdrs.ToList();
if (dtp != null)
{
return(View(dtp));
}
return(HttpNotFound());
}
private void DoubleClickDTP(Point point)
{
if (_dgvMain.GetID() == 0)
{
return;
}
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.getItem(_dgvMain.GetID());
DTP_AddEdit dtpAE = new DTP_AddEdit(dtp);
if (dtpAE.ShowDialog() == DialogResult.OK)
{
loadCars();
}
}
public DataTable ToDataTable(DTP dtp)
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("Название");
foreach (var item in dictionary)
{
dt.Rows.Add(new object[2] {
item.Key, item.Value
});
}
dt.Rows.Add(dtp.getCulpit());
return(dt);
}
private ToolStripMenuItem CreateNewDTP()
{
ToolStripMenuItem item = CreateItem("Новое ДТП");
item.Click += delegate
{
Car car = _dgvMain.GetCar();
if (car == null)
{
return;
}
DTP dtp = car.createDTP();
DTP_AddEdit dtpAE = new DTP_AddEdit(dtp);
dtpAE.ShowDialog();
};
return(item);
}
public ActionResult Edit(DTP dtp, int[] selectedPDRs)
{
DTP newDTP = context.Dtps.Find(dtp.Id);
newDTP.Name = dtp.Name;
newDTP.Type = dtp.Type;
newDTP.Price = dtp.Price;
newDTP.Pdrs.Clear();
if (selectedPDRs != null)
{
foreach (var c in context.Pdrs.Where(co =>
selectedPDRs.Contains(co.Id)))
{
newDTP.Pdrs.Add(c);
}
}
context.Entry(newDTP).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
private ToolStripMenuItem CreateShowDriverLicense()
{
ToolStripMenuItem item = CreateItem("Водительское удостоверение");
item.Click += delegate
{
if (_dgvMain.GetID() == 0)
{
return;
}
DateTime date = DateTime.Today;
if (_mainStatus.Get() == Status.DTP)
{
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.getItem(_dgvMain.GetID());
date = dtp.Date;
}
Car car = _dgvMain.GetCar();
if (car == null)
{
return;
}
DriverCarList driverCarList = DriverCarList.getInstance();
Driver driver = driverCarList.GetDriver(car, date);
LicenseList licencesList = LicenseList.getInstance();
DriverLicense driverLicense = licencesList.getItem(driver);
if ((driverLicense != null) && (!string.IsNullOrEmpty(driverLicense.File)))
{
WorkWithFiles.openFile(driverLicense.File);
}
};
return(item);
}
private void AddTimeBTN_Click(object sender, EventArgs e)
{
string Date = DTP.Value.ToString("dd/MM/yyyy");
string Time = textBox1.Text;
DateTime DT = DateTime.ParseExact((Date + " " + Time), "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);
if (!checkdoubletimes((Int32)NumHall.Value, DT, Duration))
{
AD.CreateDateTime(DT, Title, (Int32)NumHall.Value);
DTP.ResetText();
textBox1.Clear();
NumHall.ResetText();
}
else
{
DTP.ResetText();
textBox1.Clear();
NumHall.ResetText();
MessageBox.Show("The given hall is already in use at the given time. Please try again", "Invalid date", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
