public IntercepIntervals(string User)
{
InitializeComponent();
FillcbxHole();
fillComboBoxVhmod();
this.Usuario = User.Trim();
GlobalValue.Permissions = LoadLog.GetPermissiinRol("SPGet_RolesForUser", this.Usuario, this.Name);
this.Permission = GlobalValue.Permissions;
ValidatePermission(this.Controls);
}
private void btnExport_Click(object sender, EventArgs e)
{
exportForm popup = new exportForm();
popup.StartPosition = FormStartPosition.CenterParent;
DialogResult dialogResult = popup.ShowDialog();
if (dialogResult == DialogResult.OK)
{
switch (popup.ExportType)
{
case "HOLE":
exportByHoleId();
break;
case "SOURCE":
exportBySource(popup.Source);
break;
case "TARGET":
exportByTarget(popup.Target, popup.Source);
break;
default:
break;
}
return;
}
else if (dialogResult == DialogResult.Cancel)
{
return;
}
//exportIntercept(cbxSource.Text);
var culturaCol = CultureInfo.GetCultureInfo("es-CO");
DateTime dateReporte = Convert.ToDateTime(DateTime.Now, culturaCol);
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, "Generate Report", "Report");
Clear();
}
private void init_golobal_solusi()
{
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Memulai inisial solusi";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
//agro
//12 agro
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "12 AGRO A", Tingkat = 3, Visit = false
}));
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "12 AGRO B", Tingkat = 3, Visit = false
}));
//11 agro
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "11 AGRO A", Tingkat = 2, Visit = false
}));
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "11 AGRO B", Tingkat = 2, Visit = false
}));
//10 agro
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "10 AGRO A", Tingkat = 1, Visit = false
}));
GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi()
{
Jurusan = "Agro Bisnis", Kelas = "10 AGRO B", Tingkat = 1, Visit = false
}));
//////pm
////12 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "12 PM A", Tingkat = 3, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "12 PM B", Tingkat = 3, Visit = false }));
////11 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "11 PM A", Tingkat = 2, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "11 PM B", Tingkat = 2, Visit = false }));
////10 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "10 PM A", Tingkat = 1, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Bisnis Manajemen", Kelas = "10 PM B", Tingkat = 1, Visit = false }));
////TKJ
////12 TKJ
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "12 TKJ A", Tingkat = 3, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "12 TKJ B", Tingkat = 3, Visit = false }));
////11 TKJ
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "11 TKJ A", Tingkat = 2, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "11 TKJ B", Tingkat = 2, Visit = false }));
////10 TKJ
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ A", Tingkat = 1, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ B", Tingkat = 1, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Teknik Komputer & Jaringan", Kelas = "10 TKJ K", Tingkat = 1, Visit = false }));
////RPL
////12 RPL
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "12 RPL A", Tingkat = 3, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "12 RPL B", Tingkat = 3, Visit = false }));
////11 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "11 RPL A", Tingkat = 2, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "11 RPL B", Tingkat = 2, Visit = false }));
////10 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "10 RPL A", Tingkat = 1, Visit = false }));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Rekayasa Perangkat Lunak", Kelas = "10 RPL B", Tingkat = 1, Visit = false }));
////KI
////11 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "11 KI A", Tingkat = 2, Visit = false}));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "11 KI B", Tingkat = 2, Visit = false}));
////10 PM
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "10 KI A", Tingkat = 1, Visit = false}));
//GlobalJadwal.GlobalSolusi.Add(dom_solusi.init_solusi(new solusi() { Jurusan = "Kimia Industri", Kelas = "10 KI B", Tingkat = 1, Visit = false }));
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 12 Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[0].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[0].Solusi, sql.data_mengajar(3, 1, "12 AGRO A", "NEWID()"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 12 Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 12 Agro B";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[1].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[1].Solusi, sql.data_mengajar(3, 1, "12 AGRO B", "detail_mtp.sks asc"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 12 Agro B";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 11 Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[2].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[2].Solusi, sql.data_mengajar(2, 1, "11 AGRO A", "guru.nama_guru desc"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 1a Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 11 Agro B";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[3].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[3].Solusi, sql.data_mengajar(2, 1, "11 AGRO B", "mata_pelajaran.mata_pelajaran asc"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 1a Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 10 Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[4].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[4].Solusi, sql.data_mengajar(1, 1, "10 AGRO A", "NEWID()"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 10 Agro A";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "Dispatch 10 Agro B";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
GlobalJadwal.GlobalSolusi[5].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[5].Solusi, sql.data_mengajar(1, 1, "10 AGRO B", "detail_mtp.sks asc"), LoadLog, Log);
Row = Log.NewRow(); Row["Status"] = "Simple Dispatch"; Row["Keterangan"] = "selesai Dispatch 10 Agro B";
Log.Rows.Add(Row);
LoadLog.Invoke((MethodInvoker)(() => LoadLog.DataSource = Log));
Thread.Sleep(500);
//GlobalJadwal.GlobalSolusi[6].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[6].Solusi, sql.data_mengajar(3, 3, "12 PM A", "guru.nama_guru desc"));
//GlobalJadwal.GlobalSolusi[7].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[7].Solusi, sql.data_mengajar(3, 3, "12 PM B", "mata_pelajaran.mata_pelajaran asc"));
//GlobalJadwal.GlobalSolusi[8].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[8].Solusi, sql.data_mengajar(2, 3, "11 PM A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[9].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[9].Solusi, sql.data_mengajar(2, 3, "11 PM B", "NEWID()"));
//GlobalJadwal.GlobalSolusi[10].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[10].Solusi, sql.data_mengajar(1, 3, "10 PM A", "guru.nama_guru desc"));
//GlobalJadwal.GlobalSolusi[11].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[11].Solusi, sql.data_mengajar(1, 3, "10 PM B", "mata_pelajaran.mata_pelajaran asc"));
//GlobalJadwal.GlobalSolusi[12].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[12].Solusi, sql.data_mengajar(3, 5, "12 TKJ A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[13].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[13].Solusi, sql.data_mengajar(3, 5, "12 TKJ B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[14].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[14].Solusi, sql.data_mengajar(2, 5, "11 TKJ A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[15].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[15].Solusi, sql.data_mengajar(2, 5, "11 TKJ B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[16].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[16].Solusi, sql.data_mengajar(1, 5, "10 TKJ A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[17].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[17].Solusi, sql.data_mengajar(1, 5, "10 TKJ B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[18].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[18].Solusi, sql.data_mengajar(1, 5, "10 TKJ k", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[19].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[19].Solusi, sql.data_mengajar(3, 4, "12 RPL A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[20].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[20].Solusi, sql.data_mengajar(3, 4, "12 RPL B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[21].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[21].Solusi, sql.data_mengajar(2, 4, "11 RPL A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[22].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[22].Solusi, sql.data_mengajar(2, 4, "11 RPL B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[23].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[23].Solusi, sql.data_mengajar(1, 4, "10 RPL A", "detail_mtp.sks desc"));
//GlobalJadwal.GlobalSolusi[24].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[24].Solusi, sql.data_mengajar(1, 4, "10 RPL B", "detail_mtp.sks asc"));
//GlobalJadwal.GlobalSolusi[25].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[25].Solusi, sql.data_mengajar(2, 2, "11 KI A", "rand()"));
//GlobalJadwal.GlobalSolusi[26].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[26].Solusi, sql.data_mengajar(2, 2, "11 KI B", "rand()"));
//GlobalJadwal.GlobalSolusi[27].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[27].Solusi, sql.data_mengajar(1, 2, "10 KI A", "rand()"));
//GlobalJadwal.GlobalSolusi[28].Solusi = dom_solusi.greedy(GlobalJadwal.GlobalSolusi[28].Solusi, sql.data_mengajar(1, 2, "10 KI B", "rand()"));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dtgValueCalculate.RowCount > 1)
{
string contextValue = string.Empty;
try
{
foreach (DataGridViewRow row in dtgDetailHoleID.Rows)
{
if (row.Cells[0].Value != null && Convert.ToBoolean(row.Cells[0].Value) && !String.IsNullOrEmpty(row.Cells[0].Value.ToString()))
{
if (row.Cells[1].Value == null)
{
MessageBox.Show("Select all value Column Vn_mod this select");
return;
}
}
}
var culturaCol = CultureInfo.GetCultureInfo("es-CO");
DateTime dateReporte = Convert.ToDateTime(DateTime.Now, culturaCol);
foreach (DataGridViewRow row in dtgDetailHoleID.Rows)
{
if (row.Cells[0].Value != null && Convert.ToBoolean(row.Cells[0].Value) && !String.IsNullOrEmpty(row.Cells[0].Value.ToString()))
{
contextValue = "UPDATE [dbo].[DH_Samples] SET Vn_mod = '" + row.Cells[1].Value.ToString() + "' WHERE SKDHSamples =" + Convert.ToInt32(row.Cells[dtgDetailHoleID.Columns["SKDHSamples"].Index].Value) + " and HoleID ='" + row.Cells[dtgDetailHoleID.Columns["dhid"].Index].Value.ToString() + "'";
LoadLog.alterdataBase(contextValue);
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "update");
}
else
{
if (row.Cells[dtgDetailHoleID.Columns["Vn_mod_codes"].Index].Value != null && !String.IsNullOrEmpty(row.Cells[dtgDetailHoleID.Columns["Vn_mod_codes"].Index].Value.ToString()))
{
contextValue = "UPDATE [dbo].[DH_Samples] SET Vn_mod = Null WHERE SKDHSamples =" + Convert.ToInt32(row.Cells[dtgDetailHoleID.Columns["SKDHSamples"].Index].Value) + " and HoleID ='" + row.Cells[dtgDetailHoleID.Columns["dhid"].Index].Value.ToString() + "'";
LoadLog.alterdataBase(contextValue);
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "update");
}
}
}
foreach (DataGridViewRow row in dtgValueCalculate.Rows)
{
if (row.Cells[1].Value != null && !String.IsNullOrEmpty(row.Cells[1].Value.ToString()))
{
contextValue = String.Format("SELECT Count(1) FROM DH_IntercepInterval WHERE HoleID = @HoleID and SKDHSamples= @SKDHSamples");
object count = LoadLog.Exist_DB(contextValue, row.Cells[1].Value.ToString(), Convert.ToDecimal(row.Cells[9].Value));
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Search");
if (Convert.ToInt32(count) > 0)
{
string valueDescrioption = string.Empty;
if (!string.IsNullOrEmpty(txtComment.Text.Trim()))
{
//valueDescrioption = string.Concat(txtComent.Text, " Con intervale inicial de ", Convert.ToDecimal(row.Cells[2].Value), " hasta ", valueTo);
contextValue = "update dbo.DH_IntercepInterval set Tov=" + Convert.ToDecimal(row.Cells[3].Value) + ",Length_Grade=" + Convert.ToDecimal(row.Cells[4].Value) + ", Au_Grade=" + Convert.ToDecimal(row.Cells[5].Value) + ",Ag_Grade= " + Convert.ToDecimal(row.Cells[6].Value) + ",Comments='" + valueDescrioption + "',TotalRegister=" + Convert.ToInt32(row.Cells[7].Value) + " , Date_Event ='" + dateReporte.ToString() + "' where HoleID ='" + row.Cells[1].Value.ToString() + "' AND SKDHSamples =" + Convert.ToDecimal(row.Cells[9].Value);
LoadLog.alterdataBase(contextValue);
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Update");
}
else
{
MessageBox.Show("Comment is required for the rank update");
return;
}
}
else
{
contextValue = "INSERT INTO dbo.DH_IntercepInterval(HoleID,Fromv,Tov,Length_Grade,Au_Grade,Ag_Grade,Comments,TotalRegister,Vn_mod,SKDHSamples,Date_Event)VALUES(" + "'" + row.Cells[1].Value.ToString() + "'," + Convert.ToDecimal(row.Cells[2].Value) + " ," + Convert.ToDecimal(row.Cells[3].Value) + "," + Convert.ToDecimal(row.Cells[4].Value) + " ," + Convert.ToDecimal(row.Cells[5].Value) + "," + Convert.ToDecimal(row.Cells[6].Value) + ",'" + txtComment.Text + "'," + Convert.ToInt32(row.Cells[7].Value) + ",'" + row.Cells[8].Value.ToString() + "'," + row.Cells[9].Value.ToString() + ",'" + dateReporte + "')";
LoadLog.alterdataBase(contextValue);
LoadLog.Register(dateReporte, clsRf.sUser, IpLocal, IpPublica, SerialHDD, Environment.MachineName, contextValue, "Update");
}
}
}
MessageBox.Show("The Calculated items were save successful.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtComment.Text = String.Empty;
lblSavedItems.Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("There is not data to save.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
