199 New folder/sadProject/InventorySubsystem.resx
View file
@@ -0,0 +1,199 @@
<?xml version="1.0" encoding="utf-8"?>
<root>
<!--
Microsoft ResX Schema
Version 2.0
The primary goals of this format is to allow a simple XML format
that is mostly human readable. The generation and parsing of the
various data types are done through the TypeConverter classes
associated with the data types.
Example:
... ado.net/XML headers & schema ...
<resheader name="resmimetype">text/microsoft-resx</resheader>
<resheader name="version">2.0</resheader>
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
<value>[base64 mime encoded serialized .NET Framework object]</value>
</data>
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
<comment>This is a comment</comment>
</data>
There are any number of "resheader" rows that contain simple
name/value pairs.
Each data row contains a name, and value. The row also contains a
type or mimetype. Type corresponds to a .NET class that support
text/value conversion through the TypeConverter architecture.
Classes that don't support this are serialized and stored with the
mimetype set.
The mimetype is used for serialized objects, and tells the
ResXResourceReader how to depersist the object. This is currently not
extensible. For a given mimetype the value must be set accordingly:
Note - application/x-microsoft.net.object.binary.base64 is the format
that the ResXResourceWriter will generate, however the reader can
read any of the formats listed below.
mimetype: application/x-microsoft.net.object.binary.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.soap.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.bytearray.base64
value : The object must be serialized into a byte array
: using a System.ComponentModel.TypeConverter
: and then encoded with base64 encoding.
-->
<xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
<xsd:element name="root" msdata:IsDataSet="true">
<xsd:complexType>
<xsd:choice maxOccurs="unbounded">
<xsd:element name="metadata">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="name" use="required" type="xsd:string" />
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="mimetype" type="xsd:string" />
<xsd:attribute ref="xml:space" />
</xsd:complexType>
</xsd:element>
<xsd:element name="assembly">
<xsd:complexType>
<xsd:attribute name="alias" type="xsd:string" />
<xsd:attribute name="name" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="data">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
<xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
<xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
<xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
<xsd:attribute ref="xml:space" />
</xsd:complexType>
</xsd:element>
<xsd:element name="resheader">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<resheader name="resmimetype">
<value>text/microsoft-resx</value>
</resheader>
<resheader name="version">
<value>2.0</value>
</resheader>
<resheader name="reader">
<value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
</resheader>
<resheader name="writer">
<value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
</resheader>
<assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<data name="button1.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAARJSURBVHhe7ZsxaNVAGMc7VOnQoaBDBcEKCh06FOxQpZYODnZrQahIsR0cFAQ7dKhQKOLgpBUc
HArtIOIgIm6KgoOgRQdBBwcHBYciDkWKiDjU/z/3Jd57L0nT3HfhvZf84A/Jd5d73/2bXHKXtKOioqKi
whPb29vd0GXoAfQJ+pJRrPsQmod6pLnWAomPQeyMK9+g09Jsa8CEoa/MXonv0KQ039wg0U7oDbO2+Azx
MljLqHsQLwMb7nfJzzQvSHIwSPc/7HinFGeGx0B32YDFKSkuFvwwB7Oz0GydxqRKBGIc9Gx6pWjX4Ngu
6G/QimFeiiIQG4Hq85qG9AZPNLYAJVHTQezbf7UNCecGbdgD6ZqEA7C/H7INslmUau6gsSXTZix9Ui0A
+8smHLAp4dygjTQDekw4lmWptntwME+9IYinM/+i76EkeL+2BzAOeCFbkF2WR2wjhG3bZfztJJgzc5+D
eJl0S/eSQaVD0A1oE2o3fkE3oaPS3VpQwNH7I9Tu8Cwakm4bEDgGvWVpSfgAHQ87vwdaYbRkcAzZSwMm
gt1yMkED7NtW2bhFA56Z7VLylAbY99kiCO/lvN3yOYPiNmP2M0QRbNGAItiAFqH+YORNAXWOSF0e4x3f
BvyA+CS262ksj5Fj2YY3fBrwBBqV/uQGbZyEHrNBH/gygAk3PHsjxpWitDGHZRNSPQIxng1pz/258WHA
I+iw5F4D4mmzypDYWRziB6D7QQ1FtA3gwJW4AIKyLAYsSfUGUMb5v+qdQtuAS5JrLCjPfQaEoHzGVNNB
04AX0D7JMxaUaxjA8YADrAqaBlyQHBNBHadLIAR1zpiq7mgZ8BuKRn1sD0P1C5VUltsZ68QdOyzNs32e
BSpPsFoGPJfc2F7aQqUr0QCLbb47cEbLgAXJi+31mZAXogVYbF80ITe0DJiVvHwbMCg/w9+ZNCE3tAyI
Xl5iuygDTpiQG1oGjEhevg2wL4F+E3JDy4Apycu3AfYZMG5CbmgZcEXyKtIA3hqd0TJgRfLybYB9CXAV
yRktA2pegmKfr6RexijLFyN8pRW++rLFxdvoNTu2VSZFWgaQaCBMAnW0HoXrv0HIjaYB0WWQBOo4T4YI
6tw2Vd3RNOAnNC45xoJyjdngKKS2YKppAInmBHGg3PkSQDk/uVFD2wByTXJtAGVOZwDKrpoqevgwgExL
zjUgzmXunYgmVjaIcw1AfZbpywDS8I0OYpzH8wPKNDW8Q0CMX4x6mWL7NIDwenX5SqxX2vCGbwMIV4v4
EHNQ+rUjrCvH8FivFGGADb8g5Xs/nuqczfH7Q4rbjLHsFVQYNGDdbJaSdRqwarZLySoNyHJralfmaMAA
VOh11yS8hgbCUfccxGf5svAHmgk6H4IAR2Bf6/nNxnXpdi0omIK4cNGu8LQ/L92NBxV4X+ZLhzvQO4ir
OK0srjDxQ1B+jNWa/4BVUVFR4YeOjn9j/O4LaMVqCgAAAABJRU5ErkJggg==
</value>
</data>
<data name="button2.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAAVxSURBVHhe7ZtPyBZFHMffQEhISMTIg4REBw8ePHjwIOFBwYOQiIRBByMPQgZCBaFGgUKHDh4M
OnQI8WDUIcLAQ4FRh6AgwQ4dTUQ8BEV0KOjw+vnO/HZ7nt3Z3dmd/Sc8H/jyvjsz+5vZ77s7OzM771qR
9fX14+gm+htNjdqxzZo2PFR23lU7L35Fw5tAJdvRf6pxhgxvAhUccVXNl2FNIPgJV83//IB2TKB9qIrh
TCBw0YBbljUq1LvZV1+JOsb9Vrw/CPqoGCD6N4GAgxhAnFMourGUjTFA9GsCwYYy4IEPt/4L2mXJlVAm
1gDRnwkE6mwAZXehw0gxNJDaa+nq1BbR4OqYO6kC8tsYIPoxgSBFA25aVhDyN6E3kXrmIjeszKv+cIn7
6EUXJAB5RdNiSH87ECDaAPIOoq9cqTDvWLmP/GEJPRZbXbACpHcxQFy1EN0gQJQBpO9ETfOEA1b2O38Y
5KwLWID0rajLiLT2jm2EAI0GkLYFfeZyq/kDPYOeRX8poYJv0eMWegnSq+6cOkYx4G2fVYs7j59H/WHO
v+hH9DF6HT2PNrvAAcjTnZCNDkNS/7NI7wYsvQU4Vqf3j8up55KVl1nqod9HmmcEn/muEC+6z4qCAE0G
7PHJjRy3U5YgfQPajfZZUhLEGd0Ajehi2GHldcccQu+ir1HWcV5zARMhzugGXPLJtegRuYxuuaMwaQ01
iDO6Ae/55GSuW8gkiDO6AS/55GQ+tJBJEGd0AzQA6oMTFjIJxfHhcoY1QJAWGve34U+00cIlQZxJDNiL
UhZOL1ioZIg1vgGC9Is+uzWfoqctTDLEmsyAjehzVyIeLbD2uphJvGkMEOQ9hjQw+lkFa7iLzqFeh8GC
mNMZkEEZTVguoOvodyTU0Wnk9wHaaUV7h9jTG1CEc3r/S1dBXfMzYExo38oA38yclQGW1Q0CrAzwcXJW
BlhWCfK0srPfpK+5vYzv20Cd0xhAemgUqHX+TVZkFKhvfANI07qeBjoh9lixUaC+ye6Al5GmxXcWdNmy
R4M6pzFgLtC+lQG+mTmjPQLqB/ShQ+Xb6JGbDgcDkn7DZ7dGS+bbLUwyxNLr9yeLK0YzIJv2duGQhekN
YmZfnNwX6SKka/9j8yuaQkUDqh4B3f768LH4FoiRPqxssDCDQ13bkNYptIapV7fWJ6rrJzPKgKmhXbow
3f4ahWqpvnRRVia0gq1BXNgEMmZrAG3RbX5GbVLDAmjN8YiVXbx4/fX1GV3fJ7PV7PBOEjJiHwFtYtJ6
oILGKGkDE+frr6wLjEEGLV58viGL30+7VE+5vyAx1oAvfXYrXrHTW8F5GnXG7EkosnTxgmN9qc4of51S
os/LKRlAmm7FbN9fG85biGg4R7tAuvzPQujidRdl7VbM8uuYxNg74AD6Amn3R4zU+1ZuhanCzm1LzMWH
N2iQMZtOkLpP+iaU0AVq642k3xfpfvGCzDkZ8L1vQonTVkRljqHMhLSLFxSYhQHUq48tVSyNJDmWCeok
0y5eUGguBqjxVeiilr42cbw0yVK+lcsIDpFLUHAuBmiEV0fJhAylW/4ibtNWIxSciwHaed6EBkbFx0Hv
+eKASY/Hk1akHgrOxYDYDZn5naCfdlzkjgsaA4VnYYCgbo0zYtDUXPuKq6bobtdqFBSekwFN/UAM6v3j
P89TuGiA5vChyc1QOmNNcXCsEWQKb1ioODjhBX/epLxlzVF7nkPfuNT2XEFPWKg4OEHT3JTlrj5Q57fb
mqQ2qXOLnQpnaBWo2wIsJ+ofn7pMP/tE8/l8DY/fn0Jn0W+ojtvoNZS27EYATUP1TH4yoQ5bc3JI0yOh
dmklOHvl3UOaN2hy1OGvvrb2EBJppgjAfmNMAAAAAElFTkSuQmCC
</value>
</data>
<data name="button3.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAASMSURBVHhe7ZptqBVFHMYvdINIEaMQBEUF8Us3kpCUELmiUoiBUJBQkJGIEImCXwxDEURB8QYX
v6goIiUS0YuRREFQUNSHKEKEXkjwg0KCSIJC2PX37PzPenbOztlzzt3d6znOD557d2eemdn5n32Zmd2h
PCYmJp5AZ9B11O+oDx+j+da99mAcRt+gQeM3NGzdDIPpucQ+mLxg3QyD6TXnTbmIdEb0o3TszWy0bobB
tN55U7ZZVt/BsW90XUiJAbCsMJhiAJw3JQbAstqCbzXaXaDiu3CJ0F49AcCz31k7YtyKVQ5t1RYA/3HT
jitWrHJoq7YAbHPWjthlxSqHtmq9B8xHowVaaPZaoL36AnA/wrHHALgupMQAWFYYTL3cBEeQ5tx/1yBN
ckat6bbgqy0AWjypkx/RLGs+CJ4YgMR9j3AAyJyO9KjSkLWZwqjh6ZdLYBdSH2eaxUHCMvQPyqP4tLlP
0bG7LrSgdcJ78xJ2FNkQgxgAoR98WKY5yW6Y2iYvZcOxH3RdCDIi02K33Zbj6CmrNxfyFyJFvGotsSaD
4NGxjKMiRmXWTaGZc+iy28zwB1psbWQgvZvJUBkcs6ZbIE+d1xK4zxV03m2m5AZATwG9GPkq2ctyC7Xc
E0jrZjpcBv+h6dZ8Cmkvo39l8PgO6VL3n3BJAPxLYMwqexztRTeU6PEeWpC0Cmx3syBSBues6QT2Z6MD
SD9QM7eR0mebr/MANGD/DfRLkpPlU7TKbPLpTMq7ZsvWOpS+4WFbL3LOIh+dlVvMlsB+9wEQpKlzGuj4
6FrbZLbaoe1X0U86EI8v0PNmSyGttwAI0uehw+iOTE3cRPtQ4dC0LGhrBnoXXUM+R9Ais2YgvfcANCD/
bfRn4szyAVpqtsqgjafRCTXooSfXDvSwWVsgb/IBEHh0HeY9JX5AG8xWOtStiZrmAj7fopfMFgRPOQEQ
+J5ER5MSWa6id9A0s04a6noIbUeXkM8p9IxZ24KvvAAIvI+inUid9jmGRszaM9QRGtVpQrMHPWbWQvCW
G4AGlNmAdPr7fI1eNFvXUHYN+lwVefyMXjdbx1CmmgAIyi1FuhH6/IW2mq1jKLMZXVAFHh+hFWbrCspV
FwBB2VlIj0Q9Gpv5H42hwu908IRGdRr+HkJzzdo1lK02AA2oYxPKm5B8glaarQXyQqO639FbZusZ6qgn
AIJ6VqHPkhqz/IreNFsKaaFR3ZdordkmBfXkBqBlNmj+SUNdWmc8mdTaiiZQyZie/1qr0ynu8yFqmfX1
CnXVG4AG1KlLwr+mhUZveWsPCkbpL2Sos75LwId6Q6M4n+/RK1asVKh36gIgqDs0jm/wPnrW7KVD3VNz
CfjQRuNs0MqspO31ll0ZtDG1Z8BUQ99iAFwXU2IAYgD4EwPgtlNiAMw/cNC3GADXxZQYgBgA/sQAuO2U
GADzDxz0LQbAdTElBkCJS9x2yiAHwP+QY7kSH0HN63Xa1gLFIMpfl3QfTLKR9/HDoHM+6bxgRx8Q6Suq
BwW9WM2+pSJBX4ZpDb/dV6P9jpbgT6M5rtdDQ3cBvaYPyjrPTP0AAAAASUVORK5CYII=
</value>
</data>
</root>
111 New folder/sadProject/MCInventory.Designer.cs
View file
10 ...ct01/sadProject/sadProject/MCInventory.cs → New folder/sadProject/MCInventory.cs
View file
@@ -1,4 +1,5 @@
using System;
using MetroFramework.Forms;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
@@ -10,7 +11,7 @@

namespace sadProject
{
public partial class MCInventory : Form
public partial class MCInventory : MetroForm
{
public MCInventory()
{
@@ -34,5 +35,10 @@ private void button3_Click(object sender, EventArgs e)
mothersClassReport mcr = new mothersClassReport();
mcr.ShowDialog(this);
}

private void MCInventory_Load(object sender, EventArgs e)
{

}
}
}
214 New folder/sadProject/MCInventory.resx
View file
@@ -0,0 +1,214 @@
<?xml version="1.0" encoding="utf-8"?>
<root>
<!--
Microsoft ResX Schema
Version 2.0
The primary goals of this format is to allow a simple XML format
that is mostly human readable. The generation and parsing of the
various data types are done through the TypeConverter classes
associated with the data types.
Example:
... ado.net/XML headers & schema ...
<resheader name="resmimetype">text/microsoft-resx</resheader>
<resheader name="version">2.0</resheader>
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
<value>[base64 mime encoded serialized .NET Framework object]</value>
</data>
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
<comment>This is a comment</comment>
</data>
There are any number of "resheader" rows that contain simple
name/value pairs.
Each data row contains a name, and value. The row also contains a
type or mimetype. Type corresponds to a .NET class that support
text/value conversion through the TypeConverter architecture.
Classes that don't support this are serialized and stored with the
mimetype set.
The mimetype is used for serialized objects, and tells the
ResXResourceReader how to depersist the object. This is currently not
extensible. For a given mimetype the value must be set accordingly:
Note - application/x-microsoft.net.object.binary.base64 is the format
that the ResXResourceWriter will generate, however the reader can
read any of the formats listed below.
mimetype: application/x-microsoft.net.object.binary.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.soap.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.bytearray.base64
value : The object must be serialized into a byte array
: using a System.ComponentModel.TypeConverter
: and then encoded with base64 encoding.
-->
<xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
<xsd:element name="root" msdata:IsDataSet="true">
<xsd:complexType>
<xsd:choice maxOccurs="unbounded">
<xsd:element name="metadata">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="name" use="required" type="xsd:string" />
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="mimetype" type="xsd:string" />
<xsd:attribute ref="xml:space" />
</xsd:complexType>
</xsd:element>
<xsd:element name="assembly">
<xsd:complexType>
<xsd:attribute name="alias" type="xsd:string" />
<xsd:attribute name="name" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="data">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
<xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
<xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
<xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
<xsd:attribute ref="xml:space" />
</xsd:complexType>
</xsd:element>
<xsd:element name="resheader">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<resheader name="resmimetype">
<value>text/microsoft-resx</value>
</resheader>
<resheader name="version">
<value>2.0</value>
</resheader>
<resheader name="reader">
<value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
</resheader>
<resheader name="writer">
<value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
</resheader>
<assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<data name="button1.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAAaNSURBVHhe7ZpbqBVVGMdPIWRgaTe7aR1CQshAootFgdBNSsLCQEHEMEhCy25gEfjQQ0TUiYJe
ejCK8sFCSKKoQCpIKinIh64QURDUQzcqup7+vzXfzJ77WrP37PF09v7Bn5lZ61tr1qxZl2+tmYmY6enp
S6XfpdnOX9IV9tg9FLjJRY8G2+2xeyhwXAFR3EgwrgB77B4KHFdAFNcZzDjvm7qefTbZY/cgMIobKjzo
/dJyaY7dmnvPsbAd0i/SsDksFfCCdJXdrhLZrJSeJ8EQ6bwLPCslbzwE2T/lUg6HTlvAu9Jyu02CwlbY
aSmKP1vaLw2DzlrA39Jmu0WCwha52OnpPdI8Cy6guPXSzxi2TGcV8J5ln0Hhk1G04zVptUUVUNwbzqpd
OquAXZZ9BoWnKwC+kLZZdAaFP+4s2qWzCrjHss+g8HwFwL/SlDRpZg5dbyGyZTqrgFWWfQaFl1VATKZw
umZabJvOZoEmLYB1+qNSvgXcQmTLzLgx4BPpVovOoPD/9RhwyLLPoPB0BbwsXW1RBRTHWqFtOusCPj9g
lzSr/QCo8gSX2Wkpip8VnmDMSK8FYkZ6NRgz0vsBeUZyR2imcNi6wExhXAH22D0UOK6AKG4kKK0Avg5/
OSJaaY89JgjV2IlSZp3eBsqTRdEpdtkalJUy22V/UDAJH/57KYZNiw+lNWbWGKVdJrHISXt8nL8unW9m
jVHaVRJlo4wxlH23tMjMwlACHv4HqY4dZh6M0uDnpwuYh7jKHeIqlMa3b0gFLzFzPzLmzfvAfW3UfGXP
G/LxuRS8cpQt3dP3smCvJfEj40+jNF7WWRIvsj0zShLEuZbMi2yviZJ4+VY60pJVI6P5UuiK7E5L5kW2
l0RJgqjcIssj25ujJEH4xwIZHSt958z9bLVkXmR7UZQkiMstmRfZhjpwvNTTLVk9MnzHJfFzpSXxIlv6
6o8uVT2/SostmRfZXuZS+TloSfzIOGQQ/E06w5IkKGyutMAuMyj8oOTjAzPPoPAFUmEDVWGnSZTFx3OW
xI+MQ5rVfjPHnrfLHh5uZgxz8D4p2RDVOZ++fEyZOfZLpb0SA1jM1xK7yUl/1nnI5mlxE6QKGZ8k1WVK
jTtnSEe8rrppiLl9rdleIKUrKc/HkqswHX0+A316qdne6EKqeVU6DttglGC1VFWA5IuPzvG0fPDQc81+
pwspZ4vZsEd4yIXU8wr2oPOqcuCvFH+NDUEJN0t5n+Ahab7F09/TzbOOZAWm8/uk9ID4lXSbRRN/ngv1
w4C50NIslB4jMAX7jetdpk1RQtzhA9K90hppq3SxxJvZYDb00VBcH9SRNHh71xEmbZCutTD324yON0ih
XGhp1krkgWOEa0wLJm/KG+6xypjR9m4p/Wa3S1QIfTSGm7CwCeUmia3v2MniyB4EisNorlz7+nSaFRIP
GndXyk0lUyHpMLbjq1eIiqTfPSDFhcmTH+gY9Y+WvnFXfvAE84sWHji/JU5lh3YBHLbjpSfcVQ+eoWz8
4l7MRMWKUGDTT1EHLN2b0WUtTIknSI+4q3r4HI47HuKNvm1laPoNcR/pEhTAxkTdlFMGD0WrCZnb3UpM
x5CCOv9CR/YHfDCjUIb0nkUoveWxLu6KwhrDwEi//sxdlcPnbQY5BrZ8cy+DkZ0BjIH3TwIq+Eg6R7rD
XTVnpz2+qwA8tn54SzpVqpvb6VpHSXwcDeUZKxf/EVbBeMIn9H5/oIg8WZ0w6g8CBTlCYrr8iQDjD4lB
9RiJt9kURveTpXwXwxV2v9TpyMfUQZgkkyZzbhoGP5rfWRJjCG/idokKYSRnPmYOxqVlib1RelH6R6rj
JQkHjEGTSnB7kBJ5sva/XuJeTHWLpW1Svz9TbqQCmB+bwICDA8PgQ+uh+cdTJAMp8y+Fi/0Iwli8uEFH
RyqkzM3FiXEuq45LJN58PGbEc3vaZ+CetDDn5Oi4Tkr7LiFMkZCabQKF4OEflsoGNR64alRmZYdDxeox
bcM5rWieRGWVzUjYlPkolIGyUCZaTJPZ7EEqrzFKGLJfUAXepFsYpVEYDxCyAKoiWRgNFd2o7CfHphTW
5gqj6wxK7Y9XraCbNB0zythj2SUo7OkoaiD6a9JN0E1CPDQf9OfkbemcVlW3URIKq9dC92oNZd5G849J
uoHO+/ETqhheN1DmzM9t8aRlS75ssrRF8dt/Wyjz/LJzEJL/iHVO022L3ZZt+yjzYVVAyDfDUMK/AU5M
TPwHYYSCw6aveJEAAAAASUVORK5CYII=
</value>
</data>
<data name="button2.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAAb5SURBVHhe7ZtbyBVVFMclhIQkLIQsJLSkFHvo4oOVQpFgSZSWQZSBRKVUhJSEUdhF0ijKzEch
ox4KCoxMsoSsfPChqKCiKJJuEBEkXSCi4uv333ud+Wb27D2Xc77vnAn8weLM7PVfc9bsMzP7MvtMCRkb
G5uBbcEOYEex77E92Hpsqsk6DXmuxV7GvsJ0DjqXbdhMk8RBcCWmE05xGJtn8s5BbnOwg0o0wc/YapMX
wbEK+0mqGg5hCy2sM5DTXOxNJVjDb9gNFuahQDW3X96G7LDQzkBOj/nUGvEutsBCXfAaV9ycf7CzLXzk
kMtpmO71Ntxu4e4AW31ZK1ZZ+Mghl8t8Sq3YaeHuAG/4slZssvCRQy566rfloIW7Azzty1pxo4WPHHK5
yqfUimct3B1gnS9rxXkWPnLIZR72l8uqORst3B1gFtbmIXLYQjsDObW5jX/H5lioh4I7nKuer7FlFtYZ
yOli7BMl2IDxXz8PDnUX/3aSOLpKVpq8c5Db5Zh6e1WMP/1jIFiMqbf3p9SGTvxFbLbJOgs5zsR2Y/mK
0LmoG3+JyepBPBU7F2vV97e4jZgGIiVMJp2SDFFFa+BVvD/7hOPMxnQOwxvE8WWbsSpmmC5WAT3UVT3L
HfD/BonX3YM6cVn0CskRH7V1GZJWczpRPGiHHT58ue4bTSh8jn2E7cRqnwVoNKqcKPquAGL1QzyBKXdd
aXquLDZ3NQhXYrGmUJ2HJSaLgr9JBfyIVd3/PfqqAOL04+k7QnROa0wWB8F0rOoeViUkO0H46ipA8Wpm
1VLsVUEFrSuAmCWYviOFWplZJi+D82onq0ZTZusspADlmk9MoS+/1aTSLsBelyNBqwpArxFh3YNVpK8C
nGq/m6DL6RYLy6Cs6goodT8pkz52uYrGFYB2NVbVg82TPq6cXtOYDRbqYD9VAUpOk5XbTSqtuq0awOhB
FaNRBaDTbHXTkxcTWgFii4UrXk/fqmSySQi26yYxaisAzQYvbUVlBfRzQPE4dqId42ZMI8YYE1IB+I7H
HsH+lbAlA18BGlTE0GDJ9bn5TD2NJ6oCtntJCfVb6hi4AjT7ok5SDJX3KmERFj7gBqoAytR8Vn33OX6z
ksoKaHILqKOh5k49rRgvYPPteMux91TYB+tdUgb7esDucp4y6qnq+VPXDxEDXwHZUJVtTaDE0HyCew/H
p4akTS7NPIUOC9vqoOmYMfIty3ArQLCfump00u4k+FRiOqkmqKOV9TbZ1i+bOvmsBRLsD78CBGW6n2PN
nyqhN/7XTI0SrLLCjBP707DU1VPogwjKdIw6Bn8GmLwA5bdh3zpFkc0maQ2x9/hDFNAL3LtMUoDy0VWA
wHcT9oVTjdP3i1RiH/WHyPgGy8YTIfgGroC+boE8+NUH6K0xUF9gkblaQ+x8O4ZQkzoRw/HJrQCBRu21
hr212jo4hloRVWrtxKa+D6tj8m6BUUNuxyrAp1jJsQoweRmcdf1zkZ5SGjHkVjUj1aPQxS6AU/18LX9J
8aFJOws56qVKFUtNGgdBarQlStNgXYMcq9Y77TVZGkTqfsamqeqDOwK5akQaoi71dJNUg3CfCylywNyd
h1z1IiTkkLnrQfyZjynwCzbXJJ2FHDXoio1JvsOOM1kaRDrAH4qI0PkXluSoSZgUZ5gsDaILvDbKVpN1
FnK8z6ca5VKTpUF0rddG2W+yzkKOr/hUo6w1WRpEd3ttFL03PN2knYPcTsKOKNEED5k0DaIdXpuky4uk
lvkUk+w2aRpEr3ptksI8XJcgt3t9ikneNmkaRB97bZJ9Ju0c5PaSTzHJEZOmMWGe9+2zh5acTTN5pyCv
cOY5zF24SdooOPXWJ0RvX0Oar7cbEuSkgVxILPf0FB1OvbIO0bx8+J4vPaYeEeQUzmVomj42PL7eQsrg
vNNrMo5aebgQeXytfUcgp7D/7xZ08xmuGnnABcTA+aTXZLxj5ff73YwfsM5MjJDLCVj4AmWb+V7zuxm7
XFAMnGEv6jkrv8LvFljhgjoAuSz1KRW4znzP+N2Mt1xQDJwfeE2G6znxeQqmXz1P+lIaMuQS3v+/Ymea
L+zZfumCQnDoMgqXyGV9Z7bDZW17zDVyyOV5n1JGfh3CNb4oQ/8sOdXc41C40LmLZM0d2w/7ogyNuav/
ijoEyEEzWJ8qoRxPmVv+831RgQvNPQ6FK7yvQPZmh+3YGsLl5h4Z5HCRT6VAthaQ7ZMx/Vs0T7kppFBr
7fK4JrAH+1qkEL4Crx9eTjLkEOYtCi0U+2FTWF4sSWG4xK006KEsbGtH/t8hctBapDyluT/KwoekW8JT
AocOphnVTVhpBpUyvajUX9E1HtCL1E78nZ48tMJVP55WkpTeXClPTJWglWy5VeNTpvwH9ZRCrvIydgQA
AAAASUVORK5CYII=
</value>
</data>
<data name="button3.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
YQUAAAPkSURBVHhe7ZuhbxRBFIcrKhCQIBqCqIAEUYFAICoQFQgEggQSEBBKwh9QgSRBIioqEBWIhiAI
qSAEUYlAIAhBIBpUBQISEkqCIKSifL+Zt8vu3u7eXW/2dqfdL/llb9++effu3ZuZvbt2psj+/v4Oiplr
9lIOBgH6Avg4Dj2OQb9RwpK9lINBAAV0mKnzkOqGz9gRrgBw0sydhjzXfLqOcFPATJ2HVPsO8Ok6XAdw
XEaPClpxA+rA6bAU4JU/zbHrBtSB06GYAhwnLwAMdAC2Z+hli3phqaRgK+uAK0jTQErYcQPqkJP3dZQV
YNdfao09SyUFW+0uYHYx+RTA3MUC1O4CZhdBpsBNdLdF3bFUUrA10wEQ7S6QxeyiL4CZqsGpdg3oIqQ6
vTWgi5BnPwV8uo5mCyAbOt2iTlkqKdimtwZgPvL3AUfnThDKCvAd/WpRPy2VFGz9IujTdfQFMHOK2UVf
ADNVg1NfAO/r6Atg5uAQewGto7d2XLBLY8PYZgpgpuAQegn9cU/yH50vmstYMC6uD0PE/eTDD/DBXMaC
cfFMAcX0oSs5bq4jw5ioCnACfXTRy3mNrpv7SOAf1yJI3E0fvpbnaN6GaMx5dM5Oc2CPqgMuoD0XPY92
g+IHLf3svYq23ZlHjy9aOAfn0ykA55eQtqw36HHx+jDwn0XZBVC/3txCbvXnqPVB8csKlOUHmnNBgcfN
F4DHt1Exsa8oTWQY+D50ozy5F5EFu9p9S041pD908rjZAnA8hqq+B1h3A4eAn258snv/DbtUCT5PvWsp
a+Ymv2YKYCbZ1PpVbJtbJfio9d87b8+mXaoFv/vevZRlc5NfszdCHNWSVXx2A2vAR7/NJ1S2fhH81HnZ
BTBB68isuclvKmtA1d2bUAJpQlmwF1f9oa2fBf85pHdY642kRTK3+HI+lQJoDpe9GwnaGXJ3cZwXV/2R
Wn9ciNt8AQTnasnLSDuCpsUTlEUF0gcdbZHa4lSUBL17uXihIO50ClAGPitIL66Ov+ieDQkOsdsrgMBP
u8Q3N6KcoTvFJBC/3QIIfOf9kEpGvmEaF2I3UwAzjQTuWh++uIGD6J7+rLkGh9jd+EIEf21RZWyZSyMQ
v/0pIOSPsnd8QtvgGXNpBOJ3owCCMdr7tVU+QFd1bpcag+foTgHagDz7Avh0He3sAm1CqnF9LR4a8uw7
wGfsCNoByR8bd13vUELQAsRI0F0gRiYugD7eFv/VJCYN3HViSxhegMOIvXgxWQEIsIg0RaRVM3ceck0Y
/h8jdRBAX3clbJi581i+YuIOyBZAn/GTbui6EoJ2QIwE7YAYKRRgZuYf5PAI3yC4DwAAAAAASUVORK5C
YII=
</value>
</data>
</root>
178 New folder/sadProject/PMSboxes.Designer.cs
View file
25 ...oject01/sadProject/sadProject/PMSboxes.cs → New folder/sadProject/PMSboxes.cs
View file
@@ -1,4 +1,5 @@
using System;
using MetroFramework.Forms;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
@@ -10,7 +11,7 @@

namespace sadProject
{
public partial class PMSboxes : Form
public partial class PMSboxes : MetroForm
{
private static PMSboxes _instance;
public PMSboxes()
@@ -43,10 +44,6 @@ private void button2_Click(object sender, EventArgs e)
spf.ShowDialog(this);
}

private void PMSboxes_Load(object sender, EventArgs e)
{

}

private void PMSboxes_closed(object sender, FormClosedEventArgs e)
{
@@ -77,10 +74,20 @@ private void button6_Click(object sender, EventArgs e)
mr.ShowDialog(this);
}

private void button7_Click(object sender, EventArgs e)
private void pictureBox1_Click(object sender, EventArgs e)
{
createPrescription cp = new createPrescription();
cp.ShowDialog(this);

}

private void metroButton1_Click(object sender, EventArgs e)
{

}

private void PMSboxes_Load(object sender, EventArgs e)
{

}

}
}
271 New folder/sadProject/PMSboxes.resx
View file

Large diffs are not rendered by default.

0 ...roject01/sadProject/sadProject/Program.cs → New folder/sadProject/Program.cs
View file
File renamed without changes.
0 ...ect/sadProject/Properties/AssemblyInfo.cs → ...der/sadProject/Properties/AssemblyInfo.cs
View file
File renamed without changes.
0 ...dProject/Properties/Resources.Designer.cs → ...dProject/Properties/Resources.Designer.cs
View file
File renamed without changes.
0 ...ject/sadProject/Properties/Resources.resx → ...lder/sadProject/Properties/Resources.resx
View file
File renamed without changes.
0 ...adProject/Properties/Settings.Designer.cs → ...adProject/Properties/Settings.Designer.cs
View file
File renamed without changes.
0 ...t/sadProject/Properties/Settings.settings → ...r/sadProject/Properties/Settings.settings
View file
File renamed without changes.
142 New folder/sadProject/Referral_Form.Designer.cs
View file
66 ...t01/sadProject/sadProject/editPMR_Form.cs → New folder/sadProject/Referral_Form.cs
View file
@@ -14,35 +14,63 @@

namespace sadProject
{
public partial class editPMR_Form : MetroForm
public partial class Referral_Form : MetroForm
{

MySqlConnection mcon = new MySqlConnection("server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root");
MySqlCommand mcd;
public editPMR_Form()

private string PassID;
private string PassName;

public string Pass_ID
{
get { return PassID; }
set { PassID = value; }
}
public string Pass_Name
{
get { return PassName; }
set { PassName = value; }
}
public Referral_Form()
{
InitializeComponent();
}



private void metroButton1_Click(object sender, EventArgs e)
private void Referral_Form_Load(object sender, EventArgs e)
{
metroLabel2.Text = PassID;
metroLabel3.Text = PassName;
}

string Query = "UPDATE checkup set Complaint= '" + this.richTextBox1.Text + "', Treatment= '" + this.richTextBox2.Text + "' WHERE CheckupID='" + this.metroTextBox1.Text + "';";
ExecuteQuery(Query);

private void metroButton1_Click(object sender, EventArgs e)
{
string Query = "INSERT INTO patient_refferal (CheckUp_PatientID, RefferalDate, RefferalDescription) VALUES ('"
+ this.metroLabel2.Text + "','"
+ this.metroDateTime1.Value.ToString("yyyy/MM/dd") + "','"
+ this.richTextBox1.Text +
"');";
if(richTextBox1.Text == "")
{
MessageBox.Show("no text");
}
else
{
ExecuteQuery(Query);
}



}

public void openCon()
{
if (mcon.State == ConnectionState.Closed)
{
mcon.Open();
}
}


//function to Close connection
public void closeCon()
@@ -52,7 +80,7 @@ public void closeCon()
mcon.Close();
}
}


//function to execute the insert update and delete query
public void ExecuteQuery(string q)
@@ -61,26 +89,26 @@ public void ExecuteQuery(string q)
{
openCon();
mcd = new MySqlCommand(q, mcon);
if (mcd.ExecuteNonQuery() == 1)

if (MessageBox.Show("Are you sure you want to save?", "?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (MessageBox.Show("Are you sure you want to save?", "?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
this.Close();
}
mcd.ExecuteNonQuery();
MessageBox.Show("Referral description created", "success");
}
else
{
MessageBox.Show("Query Not Executed");

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}finally{
}
finally
{
closeCon();
}
}

}

}
0 ...roject/sadProject/InventorySubsystem.resx → New folder/sadProject/Referral_Form.resx
View file
File renamed without changes.
91 New folder/sadProject/ViewForm.Designer.cs
View file
41 New folder/sadProject/ViewForm.cs
View file
@@ -0,0 +1,41 @@
using MetroFramework.Forms;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
using MySql.Data.MySqlClient;

namespace sadProject
{
public partial class ViewForm : MetroForm
{

MySqlConnection mcon = new MySqlConnection("server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root");
MySqlCommand mcd;

private string PassName;

public string Pass_Name
{
get { return PassName; }
set { PassName = value; }
}

public ViewForm()
{
InitializeComponent();
}

private void ViewForm_Load(object sender, EventArgs e)
{
metroLabel3.Text = PassName;
}
}
}
0 ...01/sadProject/sadProject/MCInventory.resx → New folder/sadProject/ViewForm.resx
View file
File renamed without changes.
1 ...sadProject/addNewParticipants.Designer.cs → ...sadProject/addNewParticipants.Designer.cs
View file
0 ...dProject/sadProject/addNewParticipants.cs → New folder/sadProject/addNewParticipants.cs
View file
File renamed without changes.
0 ...roject/sadProject/addNewParticipants.resx → ...folder/sadProject/addNewParticipants.resx
View file
File renamed without changes.
0 ...oject/bin/Debug/MetroFramework.Design.dll → ...oject/bin/Debug/MetroFramework.Design.dll
View file
File renamed without changes.
0 ...roject/bin/Debug/MetroFramework.Fonts.dll → ...roject/bin/Debug/MetroFramework.Fonts.dll
View file
File renamed without changes.
0 ...t/sadProject/bin/Debug/MetroFramework.dll → ...r/sadProject/bin/Debug/MetroFramework.dll
View file
File renamed without changes.
0 ...oject/sadProject/bin/Debug/MySql.Data.dll → ...older/sadProject/bin/Debug/MySql.Data.dll
View file
File renamed without changes.
BIN +136 KB New folder/sadProject/bin/Debug/sadProject.exe
View file
Binary file not shown.
0 ...adProject/bin/Debug/sadProject.exe.config → ...adProject/bin/Debug/sadProject.exe.config
View file
File renamed without changes.
BIN +212 KB New folder/sadProject/bin/Debug/sadProject.pdb
View file
Binary file not shown.
0 ...Project/bin/Release/sadProject.vshost.exe → ...adProject/bin/Debug/sadProject.vshost.exe
View file
File renamed without changes.
0 ...ct/bin/Debug/sadProject.vshost.exe.config → ...ct/bin/Debug/sadProject.vshost.exe.config
View file
File renamed without changes.
0 .../bin/Debug/sadProject.vshost.exe.manifest → .../bin/Debug/sadProject.vshost.exe.manifest
View file
File renamed without changes.
0 ...ect/bin/Release/MetroFramework.Design.dll → ...ect/bin/Release/MetroFramework.Design.dll
View file
File renamed without changes.
0 ...ject/bin/Release/MetroFramework.Fonts.dll → ...ject/bin/Release/MetroFramework.Fonts.dll
View file
File renamed without changes.
0 ...sadProject/bin/Release/MetroFramework.dll → ...sadProject/bin/Release/MetroFramework.dll
View file
File renamed without changes.
BIN +126 KB New folder/sadProject/bin/Release/sadProject.exe
View file
Binary file not shown.
0 ...Project/bin/Release/sadProject.exe.config → ...Project/bin/Release/sadProject.exe.config
View file
File renamed without changes.
BIN +198 KB New folder/sadProject/bin/Release/sadProject.pdb
View file
Binary file not shown.
BIN +22.4 KB ...adProject/bin/Debug/sadProject.vshost.exe → ...Project/bin/Release/sadProject.vshost.exe
View file
Binary file not shown.
0 .../bin/Release/sadProject.vshost.exe.config → .../bin/Release/sadProject.vshost.exe.config
View file
File renamed without changes.
0 ...in/Release/sadProject.vshost.exe.manifest → ...in/Release/sadProject.vshost.exe.manifest
View file
File renamed without changes.
1 ...ct/sadProject/checkupSchedule.Designer.cs → ...er/sadProject/checkupSchedule.Designer.cs
View file
0 .../sadProject/sadProject/checkupSchedule.cs → New folder/sadProject/checkupSchedule.cs
View file
File renamed without changes.
0 ...adProject/sadProject/checkupSchedule.resx → New folder/sadProject/checkupSchedule.resx
View file
File renamed without changes.
138 New folder/sadProject/createPrescription.Designer.cs
View file
122 New folder/sadProject/createPrescription.cs
View file
@@ -0,0 +1,122 @@
using MetroFramework.Forms;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
using MySql.Data.MySqlClient;


namespace sadProject
{
public partial class createPrescription : MetroForm
{

MySqlConnection mcon = new MySqlConnection("server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root");
MySqlCommand mcd;

private string PassID;
private string PassName;

public string Pass_ID
{
get { return PassID; }
set { PassID = value; }
}
public string Pass_Name
{
get { return PassName; }
set { PassName = value; }
}


public createPrescription()
{
InitializeComponent();
}

private void createPrescription_Load(object sender, EventArgs e)
{
metroLabel4.Text = PassID;
metroLabel3.Text = PassName;
}

private void metroButton1_Click(object sender, EventArgs e)
{
string Query = "INSERT INTO prescription (patientId, PrescriptionDate, PrescriptionDetails) VALUES ('"
+ this.metroLabel4.Text + "','"
+ this.metroDateTime1.Value.ToString("yyyy/MM/dd") + "','"
+ this.richTextBox1.Text +
"');";

string Query2 = "INSERT INTO patient_refferal (CheckUp_PatientID, RefferalDate, RefferalDescription) VALUES ('"
+ this.metroLabel4.Text + "','"
+ this.metroDateTime1.Value.ToString("yyyy/MM/dd") + "','"
+ this.richTextBox1.Text +
"');";

if (richTextBox1.Text == "")
{
MessageBox.Show("no text");
}
else
{
ExecuteQuery(Query);
ExecuteQuery(Query2);
}
}

public void openCon()
{
if (mcon.State == ConnectionState.Closed)
{
mcon.Open();
}
}


//function to Close connection
public void closeCon()
{
if (mcon.State == ConnectionState.Open)
{
mcon.Close();
}
}


//function to execute the insert update and delete query
public void ExecuteQuery(string q)
{
try
{
openCon();
mcd = new MySqlCommand(q, mcon);

if (MessageBox.Show("Are you sure you want to save?", "?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
mcd.ExecuteNonQuery();
MessageBox.Show("prescription created", "success");
}
else
{

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
closeCon();
}
}
}
}
0 ...roject/sadProject/createPrescription.resx → ...folder/sadProject/createPrescription.resx
View file
File renamed without changes.
1 ...dProject/createnewOrientation.Designer.cs → ...dProject/createnewOrientation.Designer.cs
View file
0 ...roject/sadProject/createnewOrientation.cs → ...folder/sadProject/createnewOrientation.cs
View file
File renamed without changes.
0 ...ject/sadProject/createnewOrientation.resx → ...lder/sadProject/createnewOrientation.resx
View file
File renamed without changes.
9 .../sadProject/createpatientform.Designer.cs → .../sadProject/createpatientform.Designer.cs
View file
29 ...adProject/sadProject/createpatientform.cs → New folder/sadProject/createpatientform.cs
View file
@@ -16,20 +16,20 @@ namespace sadProject
{
public partial class createpatientform : MetroForm
{
private static createpatientform _instance;
public createpatientform()
{
InitializeComponent();
}


string MyConnection2 = "server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root";

private void metroButton1_Click(object sender, EventArgs e)
{

try
{

string MyConnection2 = "server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root";
//This is my insert query in which i am taking input from the user through windows forms
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);

string Query = "INSERT INTO client (FirstName, MiddleName, LastName, Birthdate, Gender, LotNumber, Street, City, BarangayName) VALUES ('"
+ this.fNameTB.Text + "','"
+ this.mNameTB.Text + "','"
@@ -43,9 +43,9 @@ private void metroButton1_Click(object sender, EventArgs e)
"');";

if (fNameTB.Text == "" || mNameTB.Text == "" || lNameTB.Text == "" )
{
{
MessageBox.Show("Full Name is not complete, Please complete");
}
}
else if (lotNumberTB.Text == "" || streetTB.Text == "" || cityTB.Text == "" || barangayNameTB.Text == "")
{
MessageBox.Show("No lot number OR street OR city OR barangay name inputted");
@@ -56,20 +56,17 @@ private void metroButton1_Click(object sender, EventArgs e)
}
else
{
//This is MySqlConnection here i have created the object and pass my connection string.
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
//This is command class which will handle the query and connection object.


MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;

MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database.
if (MessageBox.Show("Are you sure you want to save?", "?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
MyCommand2.ExecuteReader();
MessageBox.Show("Successfully created new patient profile!");

while (MyReader2.Read())
{
}

MyConn2.Close();
fNameTB.Text = "";
mNameTB.Text = "";
@@ -106,7 +103,7 @@ private void metroTextBox2_Click(object sender, EventArgs e)

private void createpatientform_Load(object sender, EventArgs e)
{

birthDT.MaxDate = DateTime.Now;
}

private void genderBox_SelectedIndexChanged(object sender, EventArgs e)
0 ...Project/sadProject/createpatientform.resx → New folder/sadProject/createpatientform.resx
View file
File renamed without changes.
193 New folder/sadProject/distributeMeds.Designer.cs
View file
131 New folder/sadProject/distributeMeds.cs
View file
@@ -0,0 +1,131 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
using MySql.Data.MySqlClient;
using MetroFramework.Forms;

namespace sadProject
{
public partial class distributeMeds : MetroForm
{
public distributeMeds()
{
InitializeComponent();
}

string MyConnection2 = "server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root";
private void loadData()
{
string MyConnection2 = "server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root";
MySqlConnection myconn = new MySqlConnection(MyConnection2);

DataTable dt1 = new DataTable();
string PatientReference = "SELECT CONCAT(mn.MedicineName , ', ' , mn.UnitType) AS Medicine, SupplyID, totalQuantity FROM medicine_name mn LEFT JOIN medical_supplies_inventory msi ON msi.idMedicineName = mn.idMedicineName WHERE msi.idMedicineName = mn.idMedicineName;";
MySqlCommand medCom = new MySqlCommand(PatientReference, myconn);
MySqlDataAdapter da2 = new MySqlDataAdapter(medCom);
da2.Fill(dt1);

medicineName.DataSource = dt1;
medicineName.DisplayMember = "Medicine";
medicineName.ValueMember = "SupplyID";

comboBox1.DataSource = dt1;
comboBox1.DisplayMember = "totalQuantity";


medicineName.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
medicineName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
medicineName.AutoCompleteSource = AutoCompleteSource.ListItems;

DataTable dispensetb = new DataTable();
//string dispenseDisplay = "SELECT i.DateOfIssuance as Date_of_Issuance, CONCAT(mn.MedicineName, ',' ,mn.UnitType) as Medicine, SUM(il.Quantity) as Quantity FROM issuance i LEFT JOIN issuance_line il ON i.IssuanceID = il.IssuanceID LEFT JOIN medical_supplies_inventory msi ON msi.SupplyID = il.SupplyID LEFT JOIN medicine_name mn ON mn.idMedicineName = msi.idMedicineName GROUP BY il.SupplyID;";
string dispenseDisplay = "SELECT i.DateOfIssuance as Date_of_Issuance, CONCAT(mn.MedicineName, ',' ,mn.UnitType) as Medicine, il.Quantity as Quantity, il.ExpirationDate as Expiration_Date FROM issuance i LEFT JOIN issuance_line il ON i.IssuanceID = il.IssuanceID LEFT JOIN medical_supplies_inventory msi ON msi.SupplyID = il.SupplyID LEFT JOIN medicine_name mn ON mn.idMedicineName = msi.idMedicineName GROUP BY i.IssuanceID ORDER BY i.IssuanceID desc;";
MySqlCommand disCom = new MySqlCommand(dispenseDisplay, myconn);
MySqlDataAdapter da5 = new MySqlDataAdapter(disCom);
da5.Fill(dispensetb);
dataGridView1.DataSource = dispensetb;

}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}

private void button1_Click(object sender, EventArgs e)
{
string myConnection = "server=localhost;database=healthcenter;Persist Security Info = True; User Id=root; password=root";

try
{
string update_totalQuantity = "UPDATE medical_supplies_inventory SET totalQuantity = (totalQuantity - '" + this.quantity.Text + "') WHERE SupplyID =" + this.medicineName.SelectedValue + ";";

string issuanceQuery = "INSERT INTO issuance (DateOfIssuance) VALUES ('"
+ this.dispenseDate.Value.ToString("yyyy/MM/dd") +
"');";

string issuance_line = "INSERT INTO issuance_line (IssuanceID, SupplyID, Quantity, ExpirationDate) VALUES ((SELECT IssuanceID FROM issuance ORDER BY IssuanceID desc limit 1),'"
+ this.medicineName.SelectedValue + "','"
+ this.quantity.Text + "','"
+this.expirationDate.Value.ToString("yyyy/MM/dd") +
"');";

MySqlConnection myConn = new MySqlConnection(myConnection);
MySqlCommand issCom = new MySqlCommand(issuanceQuery, myConn);
myConn.Open();

MySqlConnection myConn2 = new MySqlConnection(myConnection);
MySqlCommand isslineCom = new MySqlCommand(issuance_line, myConn2);
myConn2.Open();

MySqlConnection myConn3 = new MySqlConnection(myConnection);
MySqlCommand updateCom = new MySqlCommand(update_totalQuantity, myConn3);
myConn3.Open();

issCom.ExecuteReader();
isslineCom.ExecuteReader();
updateCom.ExecuteReader();
MessageBox.Show("SUCCESSFULLY DISPENSE");
myConn.Close();

loadData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

private void distributeMeds_Load(object sender, EventArgs e)
{
loadData();
}

private void quantity_SelectedIndexChanged(object sender, EventArgs e)
{
/*if(medicineName.SelectedValue == this.medicineName.SelectedValue)
{
DataTable dtt = new DataTable();
string query = "select * from medical_supplies_inventory where SupplyID= "+this.medicineName.SelectedValue+";";
MySqlConnection conn = new MySqlConnection(MyConnection2);
MySqlCommand medCom = new MySqlCommand(query, conn);
MySqlDataAdapter sda = new MySqlDataAdapter(medCom);
sda.Fill(dtt);
for(int i = 0; i < dtt.Rows[0]["totalQuantity"].ToString(); i++)
{
}
}*/
}
}
}
0 ...sadProject/sadProject/distributeMeds.resx → New folder/sadProject/distributeMeds.resx
View file
File renamed without changes.