private void SimpleButtonSavePVMaster_Click(object sender, RoutedEventArgs e)
{
int nProjectsID = Settings.Default.nCurrentProjectID;
SavePVMaster();
Net_Zero.Masters masters = ((Net_Zero.Masters)(this.FindResource("masters")));
Net_Zero.MastersTableAdapters.getPVMasterTableAdapter mastersgetPVMasterTableAdapter = new Net_Zero.MastersTableAdapters.getPVMasterTableAdapter();
mastersgetPVMasterTableAdapter.Fill(masters.getPVMaster);
System.Windows.Data.CollectionViewSource getPVMasterViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("getPVMasterViewSource")));
string message20 = "Update complete";
string caption20 = "Net-Zero";
MessageBoxButton buttons20 = MessageBoxButton.OK;
MessageBoxImage icon20 = MessageBoxImage.Information;
MessageBoxResult defaultResult20 = MessageBoxResult.OK;
MessageBoxOptions options20 = MessageBoxOptions.RtlReading;
// Show message box
// MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
// Displays the MessageBox.
MessageBoxResult result = MessageBox.Show(message20, caption20, buttons20, icon20, defaultResult20, options20);
}
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
Net_Zero.Masters masters = ((Net_Zero.Masters)(this.FindResource("masters")));
Net_Zero.MastersTableAdapters.getBatteryMasterTableAdapter mastersgetBatteryMasterTableAdapter = new Net_Zero.MastersTableAdapters.getBatteryMasterTableAdapter();
mastersgetBatteryMasterTableAdapter.Fill(masters.getBatteryMaster);
System.Windows.Data.CollectionViewSource getBatteryMasterViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("getBatteryMasterViewSource")));
getBatteryMasterViewSource.View.MoveCurrentToFirst();
}
private void SimpleButtonNewPVMaster_Click(object sender, RoutedEventArgs e)
{
int nProjectsID = Settings.Default.nCurrentProjectID;
Net_Zero.Masters masters = ((Net_Zero.Masters)(this.FindResource("masters")));
int TransactID1 = 0;
System.Windows.Data.CollectionViewSource getPVMasterViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("getPVMasterViewSource")));
Net_Zero.MastersTableAdapters.getPVMasterTableAdapter mastersgetPVMasterTableAdapter = new Net_Zero.MastersTableAdapters.getPVMasterTableAdapter();
DataRowView drv = (DataRowView)getPVMasterViewSource.View.CurrentItem;
//int accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
//int lineCurrent = 0;
int wasnull = 0;
wasnull = (getPVMasterViewSource.View == null ? 1 : 0);
if (wasnull == 1)
{
// MessageBox.Show("Warning: uSP_getLineViewSource is null", "CoolBlue");
string message = "Warning: getPVViewSource is null";
string caption = "Net-Zero";
MessageBoxButton buttons = MessageBoxButton.OK;
MessageBoxImage icon = MessageBoxImage.Information;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxOptions options = MessageBoxOptions.RtlReading;
// Show message box
// MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
// Displays the MessageBox.
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
if (result == MessageBoxResult.OK)
{
// Closes the parent form.
//this.Close();
}
return;
}
else
{
DataRowView drv1 = (DataRowView)getPVMasterViewSource.View.CurrentItem;
//lineCurrent = (drv1 == null ? 0 : DBNull.Value.Equals(drv1["ID"]) == true ? 0 : (int)drv1["ID"]);
}
if (getPVMasterViewSource.View != null)
{
SqlConnection conn1 = new SqlConnection()
{
ConnectionString = ProgramSettings.net_zeroconnectionString
};
//getPVViewSource.View.MoveCurrentToFirst();
try
{
using (SqlCommand cmd3 = new SqlCommand()
{
Connection = conn1, CommandType = CommandType.StoredProcedure
})
{
//cmd3.Transaction = trans1;
cmd3.Parameters.Clear();
cmd3.CommandText = "dbo.USP_insertPVMaster";
cmd3.Parameters.AddWithValue("@cModel", "Model");
cmd3.Parameters.AddWithValue("@cBrand", "Brand");
cmd3.Parameters.AddWithValue("@nPmax", 0);
cmd3.Parameters.AddWithValue("@nVmp", 0);
cmd3.Parameters.AddWithValue("@nImp", 0);
cmd3.Parameters.AddWithValue("@nVoc", 0);
cmd3.Parameters.AddWithValue("@nIsc", 0);
cmd3.Parameters.AddWithValue("@nWeight_kg", 0);
cmd3.Parameters.AddWithValue("@nLength_mm", 0);
cmd3.Parameters.AddWithValue("@nHeight_mm", 0);
cmd3.Parameters.AddWithValue("@nWidth_mm", 0);
cmd3.Parameters.AddWithValue("@cFrame", "");
cmd3.Parameters.AddWithValue("@cVendor", "");
cmd3.Parameters.AddWithValue("@nPrice", 0);
cmd3.Parameters.AddWithValue("@nPriority", 0);
cmd3.Parameters.AddWithValue("@cURL", "");
SqlParameter retval = cmd3.Parameters.Add("@transactIdentity", SqlDbType.Int);
retval.Direction = ParameterDirection.Output;
conn1.Open();
cmd3.ExecuteNonQuery();
TransactID1 = (int)cmd3.Parameters["@transactIdentity"].Value;
}
}
catch (Exception ex)
{
//utilities.errorLog(System.Reflection.MethodInfo.GetCurrentMethod().Name, ex);
System.ArgumentException argEx = new System.ArgumentException("New Line", "", ex);
throw argEx;
}
finally
{
if (conn1.State == ConnectionState.Open)
{
conn1.Close();
}
mastersgetPVMasterTableAdapter.Fill(masters.getPVMaster);
}
//getPVViewSource.View.MoveCurrentToNext();
}
}
private void SimpleButtonNewBatteryMaster_Click(object sender, RoutedEventArgs e)
{
int TransactID1 = 0;
System.Windows.Data.CollectionViewSource getBatteryMasterViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("getBatteryMasterViewSource")));
Net_Zero.Masters masters = ((Net_Zero.Masters)(this.FindResource("masters")));
int nProjectsID = Settings.Default.nCurrentProjectID;
int stringCurrent = 0;
int wasnull = 0;
wasnull = (getBatteryMasterViewSource.View == null ? 1 : 0);
if (wasnull == 1)
{
// MessageBox.Show("Warning: uSP_getLineViewSource is null", "CoolBlue");
string message = "Warning: getBatteryMasterViewSource is null";
string caption = "Net-Zero";
MessageBoxButton buttons = MessageBoxButton.OK;
MessageBoxImage icon = MessageBoxImage.Information;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxOptions options = MessageBoxOptions.RtlReading;
// Show message box
// MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
// Displays the MessageBox.
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
if (result == MessageBoxResult.OK)
{
// Closes the parent form.
//this.Close();
}
return;
}
else
{
DataRowView drv = (DataRowView)getBatteryMasterViewSource.View.CurrentItem;
stringCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["nID"]) == true ? 0 : (int)drv["nID"]);
}
SqlConnection conn = new SqlConnection()
{
ConnectionString = ProgramSettings.net_zeroconnectionString
};
try
{
using (SqlCommand cmd3 = new SqlCommand()
{
Connection = conn, CommandType = CommandType.StoredProcedure
})
{
//cmd3.Transaction = trans1;
cmd3.Parameters.Clear();
cmd3.CommandText = "[dbo].[USP_insertBatteryMaster]";
// cmd3.Parameters.AddWithValue("@nBatterySeriesStringID", stringCurrent);
// cmd3.Parameters.AddWithValue("@cName", "Series String");
SqlParameter retval = cmd3.Parameters.Add("@transactIdentity", SqlDbType.Int);
retval.Direction = ParameterDirection.Output;
conn.Open();
cmd3.ExecuteNonQuery();
TransactID1 = (int)cmd3.Parameters["@transactIdentity"].Value;
}
}
catch (Exception ex)
{
//utilities.errorLog(System.Reflection.MethodInfo.GetCurrentMethod().Name, ex);
System.ArgumentException argEx = new System.ArgumentException("New Line", "", ex);
throw argEx;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
//registerDataSet.EnforceConstraints = false;
Net_Zero.MastersTableAdapters.getBatteryMasterTableAdapter mastersgetBatteryMasterTableAdapter = new Net_Zero.MastersTableAdapters.getBatteryMasterTableAdapter();
mastersgetBatteryMasterTableAdapter.Fill(masters.getBatteryMaster); //resetButtons();
//LocateNewLineBattery(TransactID1);
}
}
