private void btnSave_Click(object sender, EventArgs e)
{
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Insert data Please");
}
else
{
DataTable dt = ClassSetting.searchColorByName(txtname.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (txtname.Text.Equals(dt.Rows[i][0].ToString()))
{
found = 1;
}
}
if (found == 1)
{
MessageBox.Show("This name already exists . .");
}
else
{
int add = ClassSetting.sp_addcolorpro(txtname.Text);
txtname.Text = "";
MessageBox.Show("Done");
}
}
}
public FRM_ProductUpdateDet(string s)
{
ProductId = int.Parse(s);
InitializeComponent();
DataTable dtCat = ClassSetting.sp_allCategory();
cmbCategory.DataSource = dtCat;
cmbCategory.DisplayMember = "catogary_name";
cmbCategory.ValueMember = "catogary_id";
DataTable dttype = ClassSetting.sp_allTypys();
cmbType.DataSource = dttype;
cmbType.DisplayMember = "typePro_name";
cmbType.ValueMember = "typePro_id";
DataTable dtcolor = ClassSetting.sp_allColors();
cmbColor.DataSource = dtcolor;
cmbColor.DisplayMember = "colorPro_name";
cmbColor.ValueMember = "colorPro_id";
DataTable ProductDet = ClassManagment.selectOneProduct(ProductId);
cmbCategory.Text = ProductDet.Rows[0][0].ToString();
txtname.Text = ProductDet.Rows[0][1].ToString();
txtBarcode.Text = ProductDet.Rows[0][2].ToString();
cmbType.Text = ProductDet.Rows[0][3].ToString();
cmbColor.Text = ProductDet.Rows[0][4].ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Insert data Please");
}
else
{
DataTable dt = ClassSetting.searchCityByName(txtname.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (txtname.Text.Equals(dt.Rows[i][0].ToString()))
{
found = 1;
}
}
if (found == 1)
{
MessageBox.Show("This name already exists . .");
}
else
{
int add = ClassLocation.sp_AddCity(txtname.Text, int.Parse(cmbCountry.SelectedValue.ToString()));
txtname.Text = "";
MessageBox.Show("Done");
}
}
}
void fillCity()
{
try
{
DataTable dt = ClassSetting.sp_selectCityOfCountry((int)cmbCountry.SelectedValue);
cmbCity.DataSource = dt;
cmbCity.DisplayMember = "city_name";
cmbCity.ValueMember = "city_id";
}
catch (Exception) { }
}
private void cmbProduct_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable dt = ClassSetting.selectProductDeatail((int)cmbProduct.SelectedValue);
txtColor.Text = dt.Rows[0][3].ToString();
txtType.Text = dt.Rows[0][4].ToString();
cat_id = int.Parse(dt.Rows[0][0].ToString());
color_id = int.Parse(dt.Rows[0][1].ToString());
type_id = int.Parse(dt.Rows[0][2].ToString());
}
catch (Exception) { }
}
void fillProduct()
{
try
{
DataTable dt = ClassSetting.selectAllProduct();
cmbProduct.DataSource = dt;
cmbProduct.DisplayMember = "product_name";
cmbProduct.ValueMember = "Product_id";
cat_id = int.Parse(dt.Rows[0][4].ToString());
color_id = int.Parse(dt.Rows[0][5].ToString());
type_id = int.Parse(dt.Rows[0][6].ToString());
}
catch (Exception) { }
}
public FRM_ProductImageView(string s)
{
InitializeComponent();
ProID = s;
dt = ClassSetting.SelectImageOnePro(int.Parse(s));
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) { MessageBox.Show("No Image Found !!!"); }
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassSetting.sp_imgageProduct(arr, int.Parse(ProID));
dt = ClassSetting.SelectImageOnePro(int.Parse(ProID));
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
private void btnSave_Click(object sender, EventArgs e)
{
int found = 0;
btnSave.Enabled = false;
if (txtCompName.Text.Equals(""))
{
MessageBox.Show("Please Insert Company Name !");
}
else
{
DataTable dt = ClassSetting.searchCompanyByName(txtCompName.Text);
for (int j = 0; j < dt.Rows.Count; j++)
{
if (txtCompName.Text.Equals(dt.Rows[j][0].ToString()))
{
found = 1;
}
}
if (found == 1)
{
MessageBox.Show("This name already exists . .");
}
else
{
int addcom = ClassSetting.sp_Addcompany(txtCompName.Text, (int)cmbCity.SelectedValue, (int)cmbCountry.SelectedValue);
DataTable LastComp = ClassSetting.sp_selectTopCompany();
for (int i = 0; i < images.Count; i++)
{
int addIMG = ClassSetting.sp_AddcompanyIMG(images[i], int.Parse(LastComp.Rows[0][0].ToString()));
}
for (int i = 0; i < imagesBC.Count; i++)
{
int addIMGBC = ClassSetting.sp_AddcompanyBCard(imagesBC[i], int.Parse(LastComp.Rows[0][0].ToString()));
}
MessageBox.Show("Done");
txtCompName.Text = "";
images.Clear();
imagesBC.Clear();
lbBC.Text = lbIMG.Text = "?";
NumOfImage = NumOfImageBC = 0;
}
}
btnSave.Enabled = true;
}
private void btnBackup_Click(object sender, EventArgs e)
{
try
{
string path = string.Format("{0}\\TravelData-{1}{2}.bak", txtPath.Text, DateTime.Now.ToShortDateString().Replace('/', '-'),
DateTime.Now.ToShortTimeString().Replace(':', '-'));
//string path = txtPath.Text + "\\Pharmacy_DB " , DateTime.Now.ToShortDateString().Replace('/', '-') ,
// DateTime.Now.ToShortTimeString().Replace(':', '-') + ".bak";
ClassSetting.Back_up(path);
MessageBox.Show("تم اخذ نسخة احتياطية");
//string.Format(txtPath.Text);
}
catch (Exception ex)
{
MessageBox.Show("يرجى التخزين على قرص اخر مختلف عن قرص النظام ");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtIMGid.Text.Equals(""))
{
picImage.Image = null;
}
else
{
int delImage = ClassSetting.deleteProImage(int.Parse(txtIMGid.Text));
dt = ClassSetting.SelectImageOnePro(int.Parse(ProID));
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
public FRM_AddProduct()
{
InitializeComponent();
DataTable dtCat = ClassSetting.sp_allCategory();
cmbCategory.DataSource = dtCat;
cmbCategory.DisplayMember = "catogary_name";
cmbCategory.ValueMember = "catogary_id";
DataTable dttype = ClassSetting.sp_allTypys();
cmbType.DataSource = dttype;
cmbType.DisplayMember = "typePro_name";
cmbType.ValueMember = "typePro_id";
DataTable dtcolor = ClassSetting.sp_allColors();
cmbColor.DataSource = dtcolor;
cmbColor.DisplayMember = "colorPro_name";
cmbColor.ValueMember = "colorPro_id";
}
private void btnSave_Click(object sender, EventArgs e)
{
int found = 0;
btnSave.Enabled = false;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Insert Product Name Please.");
}
else
{
DataTable dt = ClassSetting.searchProductsByName(txtname.Text);
for (int j = 0; j < dt.Rows.Count; j++)
{
if (txtname.Text.Equals(dt.Rows[j][0].ToString()))
{
found = 1;
}
}
if (found == 1)
{
MessageBox.Show("This name already exists . .");
}
else
{
int AddPro = ClassSetting.sp_addProduct(txtname.Text, txtBarcode.Text, (int)cmbCategory.SelectedValue, (int)cmbColor.SelectedValue, (int)cmbType.SelectedValue);
DataTable lastPro = ClassSetting.sp_lastProID();
for (int i = 0; i < images.Count; i++)
{
int ProImage = ClassSetting.sp_imgageProduct(images[i], int.Parse(lastPro.Rows[0][0].ToString()));
}
txtname.Text = txtBarcode.Text = "";
LbNumOfImg.Text = "0";
images.Clear();
NumOfImage = 0;
MessageBox.Show("Done");
}
}
btnSave.Enabled = true;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
if (ComImgBC.Equals("Company Image"))
{
int addIMG = ClassSetting.sp_AddcompanyIMG(arr, int.Parse(ComID));
dt = ClassManagment.selectAllIMGOneCompany(int.Parse(ComID));
}
else if (ComImgBC.Equals("Business Card"))
{
int addBC = ClassSetting.sp_AddcompanyBCard(arr, int.Parse(ComID));
dt = ClassManagment.selectAllComBCImage(int.Parse(ComID));
}
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cmbCountry.Text.Equals("") || cmbCity.Text.Equals("") || cmbCompany.Equals("") || txtYear.Text.Equals("") || cmbProduct.Text.Equals("") || txtColor.Text.Equals(""))
{
MessageBox.Show("Data not completed...");
}
else
{
btnSave.Enabled = false;
string billS = "";
string QuotS = "";
isbill = NumOfBill;
isQuot = NumOfQuotation;
if (isbill != 0)
{
billS = "B_True";
}
else
{
billS = "B_False";
}
if (isQuot != 0)
{
QuotS = "Q_True";
}
else
{
QuotS = "Q_False";
}
//************************************
int addtogal = ClassSetting.sp_AddToGallery(txtYear.Text, txtSeason.Text, billS, QuotS);
DataTable lastGal = ClassSetting.selectlastGal();
int addtoDet = ClassSetting.AddtoGalDetails(cat_id, (int)cmbProduct.SelectedValue, (int)cmbCompany.SelectedValue, color_id, type_id, int.Parse(lastGal.Rows[0][0].ToString()), (int)cmbCountry.SelectedValue, (int)cmbCity.SelectedValue);
//************************************
for (int iCat = 0; iCat < CatalogIMG.Count; iCat++)
{
int addtocat = ClassSetting.AddtoCataloge(CatalogIMG[iCat], int.Parse(lastGal.Rows[0][0].ToString()));
}
//****************************************
int addBill = ClassSetting.addbill(dtpBill.Value, int.Parse(lastGal.Rows[0][0].ToString()));
DataTable lastBill = ClassSetting.selectLastBill();
for (int ibill = 0; ibill < BillIMG.Count; ibill++)
{
int addBillDet = ClassSetting.addtoBillDetails(BillIMG[ibill], int.Parse(lastBill.Rows[0][0].ToString()));
}
//******************************************
int addQuot = ClassSetting.AddQuot(dtpQuotation.Value, int.Parse(lastGal.Rows[0][0].ToString()));
DataTable lastQuot = ClassSetting.selectLastQuot();
for (int iQuot = 0; iQuot < QuotationIMG.Count; iQuot++)
{
int addQuotDet = ClassSetting.addtoQuotDetails(QuotationIMG[iQuot], int.Parse(lastQuot.Rows[0][0].ToString()));
}
//*****************************************
MessageBox.Show("Done..");
txtYear.Text = txtSeason.Text = txtColor.Text = txtType.Text = "";
CatalogIMG.Clear();
BillIMG.Clear();
QuotationIMG.Clear();
lbCatalog.Text = lbBill.Text = lbQuotation.Text = "0";
NumOfCatalog = NumOfBill = NumOfQuotation = 0;
btnSave.Enabled = true;
}
}
void display()
{
dgvAllProduct.DataSource = ClassSetting.selectAllProductMaang();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvAllProduct.DataSource = ClassSetting.searchAllProductMaang(txtSearch.Text);
txtName.Text = "";
}
void display()
{
dgvCategory.DataSource = ClassSetting.sp_allCategory();
}
