protected void btnInsert_Click(object sender, EventArgs e)
{
tProductsTableAdapter sda = new tProductsTableAdapter();
DstProducts ds = new DstProducts();
string ImgExtention = "";
if (FileUpload1.HasFile)
{
ImgExtention = System.IO.Path.GetExtension(FileUpload1.FileName);
}
string FileNme = "";
if (ImgExtention != "")
{
FileNme = GetNameForFile();
}
if (dg.SelectedIndex > -1 && txtName.Text.Trim() != "")
{
bool Success = sda.FillByCode(ds.tProducts, int.Parse(ddlGroups.SelectedValue.ToString())) > 0;
if (Success)
{
ds.tProducts.Rows[0][ds.tProducts.fCodeGroupColumn] = ddlGroups.SelectedValue.ToString();
ds.tProducts.Rows[0][ds.tProducts.fNameColumn] = txtName.Text.Trim();
ds.tProducts.Rows[0][ds.tProducts.fDescColumn] = txtDesc.Text.Trim();
ds.tProducts.Rows[0][ds.tProducts.fPriceColumn] = txtPrice.Text.Trim();
if (FileUpload1.HasFile)
{
ImageUpload(FileNme, ImgExtention);
ds.tProducts.Rows[0][ds.tProducts.fImageNameColumn] = "IMG/" + FileNme.Trim() + ImgExtention;
}
sda.Update(ds.tProducts);
Label6.Text = "ویرایش محصول با موفقیت در سیستم ذخیره گردید";
}
}
else
{
DataRow MyRow = ds.tProducts.NewRow();
MyRow[ds.tProducts.fCodeGroupColumn] = ddlGroups.SelectedValue.ToString();
MyRow[ds.tProducts.fNameColumn] = txtName.Text.Trim();
MyRow[ds.tProducts.fPriceColumn] = txtPrice.Text.Trim();
MyRow[ds.tProducts.fDescColumn] = txtDesc.Text.Trim();
if (FileUpload1.HasFile)
{
ImageUpload(FileNme, ImgExtention);
MyRow[ds.tProducts.fImageNameColumn] = "IMG/" + FileNme.Trim() + ImgExtention;
}
ds.tProducts.Rows.Add(MyRow);
sda.Update(ds.tProducts);
Label6.Text = "اطلاعات محصول جدید با موفقیت در سیستم ذخیره گردید";
}
ClearTextBox();
//BindGrid();
dg.SelectedIndex = -1;
}
private void BindGrid()
{
tProductsTableAdapter sda = new tProductsTableAdapter();
DstProducts ds = new DstProducts();
string ss = ddlGroups.SelectedValue.ToString();
sda.FillByCodeGroup(ds.tProducts, int.Parse(ddlGroups.SelectedValue.ToString()));
dg.DataSource = ds.tProducts;
dg.DataBind();
}