public FRM_ShowImage(int id, string s)
{
InitializeComponent();
DocID = id;
ss = s;
if (s.Equals("ShowQ"))
{
btnSave.Visible = btnDelete.Visible = btnSelectOne.Visible = btnExport.Visible = btnPrint.Visible = false;
dt = ClassQute.selectimgforQute(DocID);
}
if (s.Equals("ShowO"))
{
btnSave.Visible = btnDelete.Visible = btnSelectOne.Visible = btnExport.Visible = btnPrint.Visible = false;
dt = ClassOrder.selectImgOrder(DocID);
}
if (s.Equals("ShowQManag"))
{
dt = ClassQute.selectimgforQute(DocID);
}
if (s.Equals("ShowOManag"))
{
dt = ClassOrder.selectImgOrder(DocID);
}
numOfImag = dt.Rows.Count;
try
{
txtIMGid.Text = dt.Rows[0][0].ToString();
byte[] arr = (byte[])(dt.Rows[0][1]);
MemoryStream ms = new MemoryStream(arr);
picImage.Image = Image.FromStream(ms);
}
catch (Exception) { }
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ss.Equals("ShowQManag"))
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassQute.AddImgQute(arr, DocID);
dt = ClassQute.selectimgforQute(DocID);
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
else if (ss.Equals("ShowOManag"))
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassOrder.AddImageOrder(arr, DocID);
dt = ClassOrder.selectImgOrder(DocID);
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtIMGid.Text.Equals(""))
{
picImage.Image = null;
}
else
{
if (ss.Equals("ShowQManag"))
{
int delImage = ClassQute.deleteQuteImg(int.Parse(txtIMGid.Text));
dt = ClassQute.selectimgforQute(DocID);
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
else if (ss.Equals("ShowOManag"))
{
int delImage = ClassOrder.deleteImgForOrder(int.Parse(txtIMGid.Text));
dt = ClassOrder.selectImgOrder(DocID);
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
}
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtType.Text.Equals("") || txtOwnDoc.Text.Equals(""))
{
MessageBox.Show("الرجاء ملئ الحقول الضرورية");
}
else
{
int addDoc = ClassOrder.AddNewOrder(txtType.Text, txtOwnDoc.Text, txtNumber.Text, dtpDoc.Value, rtxtNote.Text, 1, Qute_Id, FRM_Main.emp_fname + " " + FRM_Main.emp_lname);
if (NumOfImage > 0)
{
DataTable LastOne = ClassOrder.selectlastOrder();
for (int i = 0; i < images.Count; i++)
{
int AddImg = ClassOrder.AddImageOrder(images[i], int.Parse(LastOne.Rows[0][0].ToString()));
}
}
int updateQute = ClassQute.UpdateStatQute(Qute_Id);
Qute_Id = 0;
txtNumber.Text = txtOwnDoc.Text = txtType.Text = rtxtNote.Text = "";
lbNumIMG.Text = "0";
NumOfImage = 0;
images.Clear();
label7.Text = "0";
MessageBox.Show("تمت عملية الحفظ بنجاح");
}
}
catch (Exception) { MessageBox.Show("يجب اختيار عرض اسعار مرتبط بالطلبية"); }
}
private void button2_Click(object sender, EventArgs e)
{
int found = 0;
DataTable dt = ClassQute.selectStateOFQute(int.Parse(txtID.Text));
if (dt.Rows[0][0].ToString().Equals("Done"))
{
found = 1;
}
if (txtID.Text.Equals(""))
{
MessageBox.Show("الرجاء تحديد عرض اسعار");
}
else
{
if (found == 0)
{
int delIMG = ClassQute.deleteQutewithAllIMG(int.Parse(txtID.Text));
int i = ClassQute.deleteQute(int.Parse(txtID.Text));
MessageBox.Show("تمت عملية الحذف بنجاح");
display();
txtID.Text = txtnum.Text = txtown.Text = txttype.Text = rtxtNote.Text = "";
}
else
{
MessageBox.Show("لا يمكن حذف هذا العرض هناك طلبية مرتبطة به");
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals("") || txttype.Text.Equals("") || txtown.Text.Equals("") || txtnum.Text.Equals(""))
{
MessageBox.Show("الرجاء ملئ جميع الحقول");
}
else
{
int i = ClassQute.updateQuteManag(int.Parse(txtID.Text), txttype.Text, txtown.Text, txtnum.Text, dtpdate.Value, rtxtNote.Text, cmbState.Text);
MessageBox.Show("تمت عملية التعديل بنجاح");
display();
txtID.Text = txtnum.Text = txtown.Text = txttype.Text = rtxtNote.Text = "";
}
}
private void button2_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals(""))
{
MessageBox.Show("الرجاء تحديد طلبية اولا");
}
else
{
int delImg = ClassOrder.deleteImgWithIDOrder(int.Parse(txtID.Text));
int delOrder = ClassOrder.deleteOrder(int.Parse(txtID.Text));
int updateQutestate = ClassQute.FreeStatQuteOrder(QuteID);
MessageBox.Show("تمت عملية الحذف بنجاح");
display();
txtID.Text = txtnum.Text = txtown.Text = txttype.Text = rtxtNote.Text = "";
QuteID = 0;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtType.Text.Equals("") || txtOwnDoc.Text.Equals(""))
{
MessageBox.Show("الرجاء ملئ الحقول الضرورية");
}
else
{
int addDoc = ClassQute.AddNewQute(txtType.Text, txtOwnDoc.Text, txtNumber.Text, dtpDoc.Value, rtxtNote.Text, "ready", FRM_Main.emp_fname + " " + FRM_Main.emp_lname);
if (NumOfImage > 0)
{
DataTable LastOne = ClassQute.selectLastQute();
for (int i = 0; i < images.Count; i++)
{
int AddImg = ClassQute.AddImgQute(images[i], int.Parse(LastOne.Rows[0][0].ToString()));
}
}
txtNumber.Text = txtOwnDoc.Text = txtType.Text = rtxtNote.Text = "";
lbNumIMG.Text = "0";
NumOfImage = 0;
images.Clear();
MessageBox.Show("تمت عملية الحفظ بنجاح");
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvQute.DataSource = ClassQute.searchAllQuteManag(txtSearch.Text);
}
void display()
{
dgvQute.DataSource = ClassQute.selectAllQuteManag();
}
