public static List <DocumentProductConnection> GetAllDocumnetProductConnections()
{
MySqlCommand cmd = new MySqlCommand("GetAllDocumnetProductConnections", new MySqlConnection(connectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <DocumentProductConnection> connections = new List <DocumentProductConnection>();
while (rdr.Read())
{
DocumentProductConnection connection = new DocumentProductConnection();
connection.connectionId = int.Parse(rdr[0].ToString());
connection.documentName = rdr[1].ToString();
connection.connectionId = int.Parse(rdr[2].ToString());
connections.Add(connection);
}
rdr.Close();
return(connections);
}
public static void InsertDocumentProductConnection(DocumentProductConnection connection)
{
List <string> propertyesToIgnore = new List <string> {
};
MySqlCommand cmdInsertConnection = new MySqlCommand("InsertDocumentProductConnection", new MySqlConnection(connectionString));
cmdInsertConnection.CommandType = CommandType.StoredProcedure;
cmdInsertConnection.Parameters.Add(new MySqlParameter(("_id"), connection.connectionId));
cmdInsertConnection.Parameters.Add(new MySqlParameter(("_document_name"), connection.documentName));
cmdInsertConnection.Parameters.Add(new MySqlParameter(("_product_id"), connection.productId));
cmdInsertConnection.Parameters.Add(new MySqlParameter(("_amount"), connection.amount));
cmdInsertConnection.Connection.Open();
cmdInsertConnection.ExecuteNonQuery();
cmdInsertConnection.Connection.Close();
}
public static void InsertDocumentProductConnection(DocumentProductConnection connection)
{
TcpClient.sendObject <DocumentProductConnection>(new DBMsg(ManagerType.DocumentManager, "InsertDocumentProductConnection", JsonConvert.SerializeObject(connection)));
}
private void btnCompleteDocument_Click(object sender, EventArgs e)
{
Document document = new Document();
document.name = tbox_document_name.Text;
document.date = dtp_document_date.Value;
document.remark = rtb_document_remark.Text;
try
{
switch (selectedDocument)
{
case DocumentTypes.receipt:
//Finish document props
document.supplier = (Partner)cmb_document_option1.SelectedItem;
document.transporter = (Partner)cmb_document_option2.SelectedItem;
document.type = DocumentTypes.receipt;
//Action for document type
documentReceiveAction();
break;
case DocumentTypes.intermediateWarehouse:
//Finish document props
document.type = DocumentTypes.intermediateWarehouse;
document.originWarehouse = (Warehouse)cmb_document_option1.SelectedItem;
document.destinationWarehouse = (Warehouse)cmb_document_option2.SelectedItem;
//Action for document
documentIntermediateWarehouseAction();
break;
case DocumentTypes.writeOff:
document.type = DocumentTypes.writeOff;
//Action for document
documentRemoveitemsAction();
break;
case DocumentTypes.returnToSupplier:
//finish document props
document.type = DocumentTypes.returnToSupplier;
document.supplier = (Partner)cmb_document_option1.SelectedItem;
//Action for document
documentRemoveitemsAction();
break;
default:
break;
}
document.products = documentProducts;
DocumentClient.insertDocument(document);
foreach (ProductDisplay product in document.products)
{
DocumentProductConnection connection = new DocumentProductConnection(
DocumentConnectionHolder.documentProductConnections.Count == 0 ? 0 : DocumentConnectionHolder.documentProductConnections.Count + 1,
product.id, document.name, product.inUnit);
DocumentConnectionHolder.documentProductConnections.Add(connection);
DocumentClient.InsertDocumentProductConnection(connection);
}
clearDocumentsForm();
}
catch (Exception)
{
MessageBox.Show("Failed to complete document");
}
}