private void btnDelete_Click(object sender, EventArgs e)
{
if (txtIMGid.Text.Equals(""))
{
picImage.Image = null;
}
else
{
if (ComImgBC.Equals("Company Image"))
{
int delImage = ClassManagment.deleteComImage(int.Parse(txtIMGid.Text));
dt = ClassManagment.selectAllIMGOneCompany(int.Parse(ComID));
}
else if (ComImgBC.Equals("Business Card"))
{
int delImage = ClassManagment.DeleteBCCompany(int.Parse(txtIMGid.Text));
dt = ClassManagment.selectAllComBCImage(int.Parse(ComID));
}
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
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 btnUpdate_Click(object sender, EventArgs e)
{
if (txtname.Text.Equals(""))
{
MessageBox.Show("Please Insert Product Name.");
}
else
{
int i = ClassManagment.UpdateOneProduct(ProductId, (int)cmbCategory.SelectedValue, txtname.Text, txtBarcode.Text, (int)cmbType.SelectedValue, (int)cmbColor.SelectedValue);
int updProduct = ClassManagment.UpdateOneProductinGal(ProductId, (int)cmbCategory.SelectedValue, (int)cmbType.SelectedValue, (int)cmbColor.SelectedValue);
MessageBox.Show("Done");
this.Close();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtName.Text.Equals(""))
{
MessageBox.Show("Select One Please . .");
}
else
{
int UpNameCom = ClassManagment.UpdateCompanyName(int.Parse(dgvAllCompany.CurrentRow.Cells[0].Value.ToString()), txtName.Text);
txtName.Text = "";
display();
MessageBox.Show("Done . .");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals("") || txtName.Text.Equals(""))
{
MessageBox.Show("Select one . . ");
}
else
{
int i = ClassManagment.UpdateNameType(int.Parse(txtID.Text), txtName.Text);
txtID.Text = txtName.Text = "";
display();
MessageBox.Show("Done . . ");
}
}
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) { }
}
public FRM_Com_Image(string s)
{
InitializeComponent();
ComID = s;
if (ComImgBC.Equals("Company Image"))
{
dt = ClassManagment.selectAllIMGOneCompany(int.Parse(s));
}
else if (ComImgBC.Equals("Business Card"))
{
dt = ClassManagment.selectAllComBCImage(int.Parse(ComID));
}
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 !!!"); }
}
void display()
{
dgvCity.DataSource = ClassManagment.AllCityDisplay();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvType.DataSource = ClassManagment.SearchNameTypeDisplay(txtSearch.Text);
}
void display()
{
dgvType.DataSource = ClassManagment.SelectAllTypeDisplay();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvCategory.DataSource = ClassManagment.SearchCategory(txtSearch.Text);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvAllCompany.DataSource = ClassManagment.SearchAllCompany(txtSearch.Text);
txtName.Text = "";
}
void display()
{
dgvAllCompany.DataSource = ClassManagment.selectAllCompany();
}
void display()
{
dgvCountry.DataSource = ClassManagment.selectAllCountry();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvCity.DataSource = ClassManagment.searchCityDisplay(txtSearch.Text);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvColor.DataSource = ClassManagment.SearchNameColor(txtSearch.Text);
}
void display()
{
dgvColor.DataSource = ClassManagment.DisplayAllColor();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvCountry.DataSource = ClassManagment.searchAllCountry(txtSearch.Text);
}
