public int ws_checkPassportProducer(wsProducerType P, out int OpValue, out string OpStatus)
{
OpValue = 555;
wsProducerType RP = new wsProducerType();
try
{
DeviceDataManager DDM = new DeviceDataManager();
DDM.checkPassport(P, out OpValue, out OpStatus);
if (OpValue == 50018)
{
return(1); // Можно вставлять паспорт
}
else
{
return(0);
}
}
catch (Exception err)
{
OpStatus = "Ошибка SQL: " + err.Message.ToString();
return(0);
}
}
public List <wsProducerType> GetProducerList() //lp_sel_ProducerList
{
List <wsProducerType> l = new List <wsProducerType>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_ProducerList");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader Reader = cmd.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
wsProducerType temp = new wsProducerType();
if (!Reader.IsDBNull(Reader.GetOrdinal("ID")))
{
temp.ProducerID = (int)Reader["ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Name")))
{
temp.ProducerName = (string)Reader["Name"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Country")))
{
temp.ProducerCountry = (string)Reader["Country"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("State")))
{
temp.ProducerState = (string)Reader["State"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("City")))
{
temp.ProducerCity = (string)Reader["City"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StreetBuilding")))
{
temp.ProducerStreetBuilding = (string)Reader["StreetBuilding"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Phone")))
{
temp.ProducerPhone = (string)Reader["Phone"];
}
l.Add(temp);
}
}
conn.Close();
}
return(l);
}
public int insertProducer(wsProducerType P)//lp_ins_Producer
{
int ReturnVal = 999;
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_ins_Producer");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProducerID_out", SqlDbType.Int);
cmd.Parameters["@ProducerID_out"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Name", P.ProducerName);
cmd.Parameters.AddWithValue("@Country", P.ProducerCountry);
cmd.Parameters.AddWithValue("@State", P.ProducerState);
cmd.Parameters.AddWithValue("@City", P.ProducerCity);
cmd.Parameters.AddWithValue("@StreetBuilding", P.ProducerStreetBuilding);
cmd.Parameters.AddWithValue("@Phone", P.ProducerPhone);
cmd.Parameters.Add("@ReturnVal", SqlDbType.Int);
cmd.Parameters["@ReturnVal"].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
ReturnVal = (int)cmd.Parameters["@ReturnVal"].Value;
conn.Close();
}
return(ReturnVal);
}
private void btn_deleteProducer_Click(object sender, RoutedEventArgs e)
{
producerType = list_Catalogs.SelectedItem as wsProducerType;
if (producerType != null)
{
wc.ws_checkProducerAsync((int)producerType.ProducerID);
}
else
{
InfoWindow iw = new InfoWindow(Messages.m_Message, "Не выбран элемент для удаления");
iw.Show();
}
}
void wc_ws_selectProducersDataCompleted(object sender, ws_selectProducersDataCompletedEventArgs e)
{
if (e.Result != null)
{
globalProducer = e.Result;
grid_ProducerType.DataContext = globalProducer;
}
else
{
cwnd_ShitHappens w = new cwnd_ShitHappens(ErrorResources.err_SELECT, e.OpStatus.ToString());
w.Show();
}
}
// --- Submit form
private void btn_okUW_Click(object sender, RoutedEventArgs e)
{
switch (ucMode)
{
case 1: // mode_U
wc.ws_updateProducerAsync(globalProducer);
break;
case 2: // mode_W
globalProducer = grid_ProducerType.DataContext as wsProducerType;
wc.ws_insertProducerAsync(globalProducer);
break;
}
}
public wsProducerType GetProducerData(int ID)//lp_sel_ProducerData
{
wsProducerType l = new wsProducerType();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_ProducerData");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProducerID", ID);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
l.ProducerID = (int)Reader["ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Name")))
{
l.ProducerName = (string)Reader["Name"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Country")))
{
l.ProducerCountry = (string)Reader["Country"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("State")))
{
l.ProducerState = (string)Reader["State"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("City")))
{
l.ProducerCity = (string)Reader["City"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StreetBuilding")))
{
l.ProducerStreetBuilding = (string)Reader["StreetBuilding"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Phone")))
{
l.ProducerPhone = (string)Reader["Phone"];
}
}
}
return(l);
}
public int ws_updateProducer(wsProducerType LocalProducer, out string OpStatus)
{
try
{
OpStatus = "Выполнено";
CatalogsDataManager CDM = new CatalogsDataManager();
CDM.updateProducer(LocalProducer);
return(1);
}
catch (Exception err)
{
OpStatus = err.Message.ToString();
return(0);
}
}
public int ws_insertProducer(wsProducerType LocalProducer, out string OpStatus)
{
int res = 555;
try
{
OpStatus = "Выполнено";
CatalogsDataManager CDM = new CatalogsDataManager();
if ((res = CDM.insertProducer(LocalProducer)) == 0)
{
return(1);
}
else
{
return(res);
}
}
catch (Exception err)
{
OpStatus = err.Message.ToString();
return(0);
}
}
public void checkPassport(wsProducerType P, out int OutVal, out string OutText)//lp_sel_CheckDevicePassportData
{
wsProducerType l = new wsProducerType();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_CheckDevicePassportData");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", P.ProducerName);
cmd.Parameters.AddWithValue("@Country", P.ProducerCountry);
cmd.Parameters.Add("@ReturnVal", SqlDbType.Int);
cmd.Parameters["@ReturnVal"].Direction = ParameterDirection.ReturnValue;
SqlDataReader Reader = cmd.ExecuteReader();
Reader.Close();
OutVal = (int)cmd.Parameters["@ReturnVal"].Value;
OutText = selectMessageText(OutVal);
conn.Close();
}
}
private void OKButton_Click(object sender, RoutedEventArgs e)
{
wsProducerType LocalProducer = ContentControl_Producer.Content as wsProducerType;
wc.ws_updateProducerAsync(LocalProducer);
}
public cwnd_Producer(wsProducerType P)
{
InitializeComponent();
ContentControl_Producer.Content = P;
Loaded += new RoutedEventHandler(cwnd_Producer_Loaded);
}
