private void TambahWarna_Click(object sender, EventArgs e)
{
if (!WarnaValidator.Validate())
{
return;
}
var SelectedModel = ModelGridView.GetFocusedRowCellValue(colid_model);
XPQuery <UnitModelModel> model_coll = ModelUnitOfWork.Query <UnitModelModel>();
UnitModelModel model = model_coll.FirstOrDefault(m => m.id_model == Convert.ToInt64(SelectedModel));
var SelectedVariant = VariantGridView.GetFocusedRowCellValue(colvariant);
XPQuery <UnitModelVariantModel> variant_coll = ModelUnitOfWork.Query <UnitModelVariantModel>();
UnitModelVariantModel variantModel = variant_coll.FirstOrDefault(v => v.nama_variant == SelectedVariant.ToString() && v.id_model == model);
UnitModelWarnaModel warnaModel = new UnitModelWarnaModel(ModelUnitOfWork)
{
id_model = model,
id_variant = variantModel,
nama_warna = nama_warna.Text
};
ModelUnitOfWork.CommitChanges();
nama_warna.ResetText();
LoadDataGrid();
}
private void LoadDataGrid()
{
var SelectedModel = ModelGridView.GetFocusedRowCellValue(colid_model);
XPQuery <UnitModelModel> model_coll = ModelUnitOfWork.Query <UnitModelModel>();
UnitModelModel model = model_coll.FirstOrDefault(m => m.id_model == Convert.ToInt64(SelectedModel));
XPQuery <UnitModelVariantModel> variant_coll = ModelUnitOfWork.Query <UnitModelVariantModel>();
if (VariantGridView.RowCount <= 0)
{
panelControlTransmisi.Enabled = false;
panelControlWarna.Enabled = false;
}
else
{
panelControlTransmisi.Enabled = true;
panelControlWarna.Enabled = true;
}
var SelectedVariant = VariantGridView.GetFocusedRowCellValue(colvariant);
UnitModelVariantModel variant = variant_coll.FirstOrDefault(v => v.nama_variant == SelectedVariant.ToString() && v.id_model == model);
XPQuery <UnitModelTransmisiModel> transmisi_coll = ModelUnitOfWork.Query <UnitModelTransmisiModel>();
TransmisiGridControl.DataSource = transmisi_coll.Where(t => t.id_model == model && t.id_variant == variant);
XPQuery <UnitModelWarnaModel> warna_coll = ModelUnitOfWork.Query <UnitModelWarnaModel>();
WarnaGridControl.DataSource = warna_coll.Where(w => w.id_model == model && w.id_variant == variant);
}
private void HapusVariant_Click(object sender, EventArgs e)
{
if (VariantGridView.RowCount <= 0)
{
return;
}
var Selected = VariantGridView.GetFocusedRowCellValue(colvariant);
var SelectedModel = ModelGridView.GetFocusedRowCellValue(colid_model);
XPQuery <UnitModelModel> model_coll = Session.DefaultSession.Query <UnitModelModel>();
UnitModelModel model = model_coll.FirstOrDefault(m => m.id_model == Convert.ToInt64(SelectedModel));
XPQuery <UnitModelVariantModel> variant_coll = Session.DefaultSession.Query <UnitModelVariantModel>();
UnitModelVariantModel variantModel = variant_coll.FirstOrDefault(v => v.nama_variant == Selected.ToString() && v.id_model == model);
variantModel.Delete();
LoadDataGrid();
}
private void TambahVariant_Click(object sender, EventArgs e)
{
if (!VariantValidator.Validate())
{
return;
}
UnitModelVariantModel variantModel = new UnitModelVariantModel(ModelUnitOfWork);
var SelectedModel = ModelGridView.GetFocusedRowCellValue(colid_model);
XPQuery <UnitModelModel> model_coll = ModelUnitOfWork.Query <UnitModelModel>();
UnitModelModel model = model_coll.FirstOrDefault(m => m.id_model == Convert.ToInt64(SelectedModel));
variantModel.id_model = model;
variantModel.created_by = Login.User.username;
variantModel.nama_variant = nama_variant.Text;
variantModel.Save();
ModelUnitOfWork.CommitChanges();
nama_variant.ResetText();
LoadDataGrid();
}
private void HapusTransmisi_Click(object sender, EventArgs e)
{
if (TransmisiGridView.RowCount <= 0)
{
return;
}
var SelectedModel = ModelGridView.GetFocusedRowCellValue(colid_model);
XPQuery <UnitModelModel> model_coll = ModelUnitOfWork.Query <UnitModelModel>();
UnitModelModel model = model_coll.FirstOrDefault(m => m.id_model == Convert.ToInt64(SelectedModel));
var SelectedVariant = VariantGridView.GetFocusedRowCellValue(colvariant);
XPQuery <UnitModelVariantModel> variant_coll = Session.DefaultSession.Query <UnitModelVariantModel>();
UnitModelVariantModel variantModel = variant_coll.FirstOrDefault(v => v.nama_variant == SelectedVariant.ToString() && v.id_model == model);
var Selected = TransmisiGridView.GetFocusedRowCellValue(coltransmisi);
XPQuery <UnitModelTransmisiModel> transmisi_coll = Session.DefaultSession.Query <UnitModelTransmisiModel>();
UnitModelTransmisiModel transmisiModel = transmisi_coll.FirstOrDefault(t => t.id_model == model && t.id_variant == variantModel && t.nama_tarnsmisi == Selected.ToString());
transmisiModel.Delete();
LoadDataGrid();
}
