protected void Button4_Click(object sender, EventArgs e)
{
string strSrch = TextBox1.Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch);
OdbcConnection connection = new OdbcConnection(ConTecdoc);
connection.ConnectionTimeout = 600;
connection.Open();
OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT
TOF_ARTICLES.ART_ID,
TOF_ARTICLES.ART_ARTICLE_NR,
TOF_DES_TEXTS.TEX_TEXT,
TOF_ARTICLE_CRITERIA.ACR_VALUE
FROM
TOF_ARTICLES
LEFT OUTER JOIN TOF_ARTICLE_CRITERIA ON (TOF_ARTICLES.ART_ID = TOF_ARTICLE_CRITERIA.ACR_ART_ID)
INNER JOIN TOF_CRITERIA ON (TOF_ARTICLE_CRITERIA.ACR_CRI_ID = TOF_CRITERIA.CRI_ID)
INNER JOIN TOF_DESIGNATIONS ON (TOF_CRITERIA.CRI_DES_ID = TOF_DESIGNATIONS.DES_ID)
INNER JOIN TOF_DES_TEXTS ON (TOF_DESIGNATIONS.DES_TEX_ID = TOF_DES_TEXTS.TEX_ID)
WHERE
TOF_ARTICLES.ART_ID = 4325174 AND
TOF_CRITERIA.CRI_TYPE IN ('A','B','D','N') AND
TOF_DESIGNATIONS.DES_LNG_ID = 16", connection);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
string txt1 = TextBox1.Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(txt1);
if (!string.IsNullOrEmpty(strRepl))
{
OdbcConnection conn_tec = new OdbcConnection(ConTecdoc);
OdbcDataAdapter da_arls = new OdbcDataAdapter(@"SELECT *
FROM TOF_ART_LOOKUP ARL
INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID)
LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID)
INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID)
INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID)
WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "' ", conn_tec);
DataTable dt_arls = new DataTable();
da_arls.Fill(dt_arls);
GridView2.DataSource = dt_arls;
GridView2.DataBind();
if (dt_arls.Rows.Count < 1)
{
img_btn_Kia.Visible = true;
}
else
{
img_btn_Kia.Visible = false;
}
}
}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{
string strSrch = TextBox2.Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch);
OdbcConnection connection = new OdbcConnection(ConTecdoc);
connection.ConnectionTimeout = 600;
connection.Open();
OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT TOF_ART_LOOKUP.ARL_SEARCH_NUMBER,
TOF_ART_LOOKUP.ARL_KIND,
TOF_ART_LOOKUP.ARL_ART_ID,
TOF_ART_LOOKUP.ARL_DISPLAY_NR,
TOF_ARTICLES.ART_SUP_ID,
TOF_SUPPLIERS.SUP_BRAND,
TOF_DES_TEXTS.TEX_TEXT AS ART_COMPLETE_DES_TEXT
FROM TOF_ART_LOOKUP
LEFT JOIN TOF_BRANDS ON TOF_BRANDS.BRA_ID = TOF_ART_LOOKUP.ARL_BRA_ID
INNER JOIN TOF_ARTICLES ON TOF_ARTICLES.ART_ID = TOF_ART_LOOKUP.ARL_ART_ID
INNER JOIN TOF_SUPPLIERS ON TOF_SUPPLIERS.SUP_ID = TOF_ARTICLES.ART_SUP_ID
INNER JOIN TOF_DESIGNATIONS ON TOF_DESIGNATIONS.DES_ID = TOF_ARTICLES.ART_COMPLETE_DES_ID
INNER JOIN TOF_DES_TEXTS ON TOF_DES_TEXTS.TEX_ID = TOF_DESIGNATIONS.DES_TEX_ID
WHERE TOF_DESIGNATIONS.DES_LNG_ID = 16 AND (TOF_ART_LOOKUP.ARL_KIND = '1' ) AND TOF_ART_LOOKUP.ARL_ART_ID = 177531", connection);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
// Response.Write("<SCRIPT language='JavaScript'> alert('"+ TextBox2.Text +"') </SCRIPT>");
}
protected void Replace_ImgBtn_Click(object sender, ImageClickEventArgs e)
{
ImageButton ReplaceImgBtn = (ImageButton)sender;
GridViewRow GrdViewRow = (GridViewRow)ReplaceImgBtn.NamingContainer;
string strSrch = GrdViewRow.Cells[4].Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch);
OdbcConnection connection = new OdbcConnection(ConTecdoc);
connection.ConnectionTimeout = 600;
connection.Open();
OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT *
FROM TOF_ART_LOOKUP ARL
INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID)
LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID)
INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID)
INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID)
WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "'", connection);
DataTable dt = new DataTable();
da.Fill(dt);
GRD_Replacement.DataSource = dt;
GRD_Replacement.DataBind();
if (dt.Rows.Count > 0)
{
ShowReplacement_popupextender.Show();
}
else
{
Response.Write("<SCRIPT language='JavaScript'> alert('შემცვლელის მოძებნა ვერ მოხერხდა !!!') </SCRIPT>");
}
}
protected void Generate_WB_Num()
{
string tmp_wbn = string.Empty;
string tmp_wbn_converted = string.Empty;
tmp_wbn = DateTime.Now.ToString();
tmp_wbn_converted = RemoveElementsFrom.RmvSomeElements(tmp_wbn);
WaybillNumber_inputID.Value = tmp_wbn_converted.Replace("PM", "").Replace("AM", ""); // waybill number
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
ImageButton ReplaceImgBtn2 = (ImageButton)sender;
GridViewRow GrdViewRow2 = (GridViewRow)ReplaceImgBtn2.NamingContainer;
string strArtBrand2 = GrdViewRow2.Cells[3].Text;
string strArtNum2 = RemoveElementsFrom.RmvSomeElements(GrdViewRow2.Cells[4].Text);
//Response.Write("<SCRIPT language='JavaScript'> alert('"+ strArtNum.ToString()+"') </SCRIPT>");
Response.Redirect("http://vedro.pro/search/?pcode=" + strArtNum2 + " ");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ImageButton ReplaceImgBtn = (ImageButton)sender;
GridViewRow GrdViewRow = (GridViewRow)ReplaceImgBtn.NamingContainer;
string strArtBrand = GrdViewRow.Cells[3].Text;
string strArtNum = RemoveElementsFrom.RmvSomeElements(GrdViewRow.Cells[4].Text);
//Response.Write("<SCRIPT language='JavaScript'> alert('"+ strArtNum.ToString()+"') </SCRIPT>");
Response.Redirect("http://old.tegetamotors.ge/ka/products/act/partsGetResultsByCode2/?make=&makeName=&model=&modelName=&typ=&typName=&pcat=" + strArtNum + "&pcatName=&brand=" + strArtBrand + "");
// Response.Write("<a href='tegetamotors.ge/ka/products/act/partsGetResultsByCode2/?make=&makeName=&model=&modelName=&typ=&typName=&pcat=" + strArtNum + "&pcatName=&brand=" + strArtBrand + "'></a>");
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridView gvParts = e.Row.FindControl("GridView2") as GridView;
// Retrieve the underlying data item. In this example
// the underlying data item is a DataRowView object.
DataRowView rowView = (DataRowView)e.Row.DataItem;
// Retrieve the key value for the current row. Here it is an int.
string myDataKey = rowView["ARL_DISPLAY_NR"].ToString();
string Art_Num = RemoveElementsFrom.RmvSomeElements(myDataKey);
// ... do more work ...
OdbcConnection connection = new OdbcConnection(ConTecdoc);
connection.ConnectionTimeout = 600;
connection.Open();
OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT *
FROM
TOF_ART_LOOKUP ARL
INNER JOIN
TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID)
LEFT OUTER JOIN
TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID)
INNER JOIN
TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID)
INNER JOIN
TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID)
WHERE
DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '3') AND
ARL.ARL_SEARCH_NUMBER = '" + Art_Num + "' FIRST(1)", connection);
DataTable dt = new DataTable();
da.Fill(dt);
gvParts.DataSource = dt;
gvParts.DataBind();
}
}
protected void Query_InTecdoc_Click(object sender, ImageClickEventArgs e)
{
string strSrch = txt_editgoodsCode.Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch);
OdbcConnection connection = new OdbcConnection(ConTecdoc);
connection.ConnectionTimeout = 600;
connection.Open();
OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT TOF_ART_LOOKUP.ARL_SEARCH_NUMBER,
TOF_ART_LOOKUP.ARL_KIND,
TOF_ART_LOOKUP.ARL_ART_ID,
TOF_ART_LOOKUP.ARL_DISPLAY_NR,
TOF_ARTICLES.ART_SUP_ID,
TOF_SUPPLIERS.SUP_BRAND,
TOF_DES_TEXTS.TEX_TEXT AS ART_COMPLETE_DES_TEXT
FROM TOF_ART_LOOKUP
LEFT JOIN TOF_BRANDS ON TOF_BRANDS.BRA_ID = TOF_ART_LOOKUP.ARL_BRA_ID
INNER JOIN TOF_ARTICLES ON TOF_ARTICLES.ART_ID = TOF_ART_LOOKUP.ARL_ART_ID
INNER JOIN TOF_SUPPLIERS ON TOF_SUPPLIERS.SUP_ID = TOF_ARTICLES.ART_SUP_ID
INNER JOIN TOF_DESIGNATIONS ON TOF_DESIGNATIONS.DES_ID = TOF_ARTICLES.ART_COMPLETE_DES_ID
INNER JOIN TOF_DES_TEXTS ON TOF_DES_TEXTS.TEX_ID = TOF_DESIGNATIONS.DES_TEX_ID
WHERE TOF_DESIGNATIONS.DES_LNG_ID = 16 AND (TOF_ART_LOOKUP.ARL_KIND = '1') AND TOF_ART_LOOKUP.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "'", connection);
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
string Brand_Name = dt.Rows[i]["SUP_BRAND"].ToString();
string Category_Name = dt.Rows[i]["ART_COMPLETE_DES_TEXT"].ToString();
txt_edit_Brand_Manufacturer.Text = Brand_Name.ToString();
txt_editgoodsCategory.Text = Category_Name;
}
edt_mod_popupextender.Show();
}
private void test1()
{
string txt1 = TextBox1.Text;
string strRepl = RemoveElementsFrom.RmvSomeElements(txt1);
OdbcConnection connection = new OdbcConnection(ConTecdoc);
OdbcDataAdapter da2 = new OdbcDataAdapter(@"SELECT *
FROM TOF_ART_LOOKUP ARL
INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID)
LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID)
INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID)
INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID)
WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "' ", connection);
DataTable dt2 = new DataTable();
da2.Fill(dt2);
for (int i = 0; i < dt2.Rows.Count; i++)
{
var StringValue = dt2.Rows[i]["ART_ARTICLE_NR"].ToString();
var StringText = dt2.Rows[i]["ARL_SEARCH_NUMBER"].ToString();
var StringBrand = dt2.Rows[i]["SUP_BRAND"].ToString();
var StringCategory = dt2.Rows[i]["TEX_TEXT"].ToString();
con.Open();
string str = @" INSERT INTO tmpTable (name, brand, category) VALUES ('" + StringValue + "', '" + StringBrand + "', N'" + StringCategory + "')";
SqlCommand cmd = new SqlCommand(str, con);
int insNum = cmd.ExecuteNonQuery();
if (insNum == 0)
{
Response.Write("<script type='text/javascript'>alert(' არ დამატებულა!')</script>");
}
SqlCommand command = new SqlCommand(@"select *
from
(select Id, name as Gname, price, product_code, description from goods) T1
INNER JOIN
(select * from tmpTable) T2
ON(T2.name = T1.product_code OR T2.name = T1.Gname OR T2.name = T1.description)", con);
SqlDataReader dr = command.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
else if (dt.Rows.Count == 0)
{
SqlCommand command1 = new SqlCommand(@"select brand, name, name AS Gname, category, REPLACE(brand, brand, N'შეკვეთით' ) price from tmpTable order by brand", con);
SqlDataReader dtr = command1.ExecuteReader();
DataTable dt_t = new DataTable();
dt_t.Load(dtr);
GridView1.DataSource = dt_t;
GridView1.DataBind();
}
// string strdel = "DELETE from tmpTable ";
// SqlCommand strCmd1 = new SqlCommand(strdel, con);
con.Close();
// Response.Write("<script type='text/javascript'>alert('"+ArtNum+"-"+ArtBrand+"')</script>");
}
}
