protected void Button1_Click(object sender, EventArgs e)
{
if (txtMeruzeninAdi.Text.Trim().Length > 2)
{
if (Session["ConfranceID"].ToString() == "0" && Session["PersonalProfilID"].ToString() != "0" && Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"insert into KonfranslardaIshtirak values(@MeruzeninAdi
,@KonfransinAdi
,@TypeOlkeBeynelxalq
,@Olke
,@TeshkilatinAdi
,@Cildi
,@CildNomre
,@KecrildiyiTarix
,@Sehifeilk
,@SehifeSon
,@LinkURL
,@ShexsiProfilID
,@KonfransIndex
,@Muellifler
,@KonfIlkTarix
,@KonfSonTarix)", clSsql.sqlconn);
cmd.Parameters.AddWithValue("MeruzeninAdi", txtMeruzeninAdi.Text);
cmd.Parameters.AddWithValue("KonfransinAdi", txtKonfransinAdi.Text);
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("KecrildiyiTarix", 0);
cmd.Parameters.AddWithValue("Sehifeilk", txtsehifeIlk.Text);
cmd.Parameters.AddWithValue("SehifeSon", txtsehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtLink.Text);
cmd.Parameters.AddWithValue("TypeOlkeBeynelxalq", DDLStatusu.SelectedValue);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
cmd.Parameters.AddWithValue("KonfransIndex", DDLIndexs.SelectedValue);
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
DateTime d;
if (DateTime.TryParse((DateIlkTarix.Text).ToString(), out d) == true)
{
cmd.Parameters.AddWithValue("KonfIlkTarix", DateTime.Parse(DateIlkTarix.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("KonfIlkTarix", DBNull.Value);
}
if (DateTime.TryParse((DateSonTarix.Text).ToString(), out d) == true)
{
cmd.Parameters.AddWithValue("KonfSonTarix", DateTime.Parse(DateSonTarix.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("KonfSonTarix", DBNull.Value);
}
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
DataRow dr = clSsql.getDT(@"Select * from KonfranslardaIshtirak where ID=(select MAX(ID) from KonfranslardaIshtirak where ShexsiProfilID=" + Session["PersonalProfilID"].ToString() + ")").Rows[0];
Session["ConfranceID"] = dr["ID"].ToString();
if (Session["ConfranceID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtar"] != null)
{
txtAxtar.Text = Session["txtAxtar"].ToString();
}
GetConfrance(txtAxtar.Text);
txtMeruzeninAdi.Text = "";
txtKonfransinAdi.Text = "";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtTeshkilatAdi.Text = "";
txtsehifeIlk.Text = "";
txtsehifeSon.Text = "";
txtLink.Text = "";
// txtHemmuellif.Text = "";
DateSonTarix.Text = "";
DateIlkTarix.Text = "";
DDLStatusu.SelectedIndex = 0;
DDLIndexs.SelectedIndex = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
else if (Session["ConfranceID"].ToString() != "0" && Session["PersonalProfilID"].ToString() != "0" && Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"Update KonfranslardaIshtirak set MeruzeninAdi=@MeruzeninAdi
,KonfransinAdi=@KonfransinAdi
,TypeOlkeBeynelxalq=@TypeOlkeBeynelxalq
,Olke=@Olke
,TeshkilatinAdi=@TeshkilatinAdi
,Cildi=@Cildi
,CildNomre=@CildNomre
,KecrildiyiTarix=@KecrildiyiTarix
,Sehifeilk=@Sehifeilk
,SehifeSon=@SehifeSon
,LinkURL=@LinkURL
,ShexsiProfilID=@ShexsiProfilID
,KonfransIndex=@KonfransIndex
,Muellifler=@Muellifler
,KonfIlkTarix=@KonfIlkTarix
,KonfSonTarix=@KonfSonTarix
where ID=@ID", clSsql.sqlconn);
cmd.Parameters.AddWithValue("MeruzeninAdi", txtMeruzeninAdi.Text);
cmd.Parameters.AddWithValue("KonfransinAdi", txtKonfransinAdi.Text);
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("KecrildiyiTarix", 0);
cmd.Parameters.AddWithValue("Sehifeilk", txtsehifeIlk.Text);
cmd.Parameters.AddWithValue("SehifeSon", txtsehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtLink.Text);
cmd.Parameters.AddWithValue("TypeOlkeBeynelxalq", DDLStatusu.SelectedValue);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
cmd.Parameters.AddWithValue("KonfransIndex", DDLIndexs.SelectedValue);
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
DateTime d;
if (DateTime.TryParse((DateIlkTarix.Text).ToString(), out d) == true)
{
cmd.Parameters.AddWithValue("KonfIlkTarix", DateTime.Parse(DateIlkTarix.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("KonfIlkTarix", DBNull.Value);
}
if (DateTime.TryParse((DateSonTarix.Text).ToString(), out d) == true)
{
cmd.Parameters.AddWithValue("KonfSonTarix", DateTime.Parse(DateSonTarix.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("KonfSonTarix", DBNull.Value);
}
cmd.Parameters.AddWithValue("ID", Session["ConfranceID"].ToString());
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
SqlCommand cmd1 = new SqlCommand("Delete from HemmuellifKonfrans where ConfranceID=" + Session["ConfranceID"].ToString(), clSsql.sqlconn);
clSsql.sqlconn.Open();
cmd1.ExecuteNonQuery();
clSsql.sqlconn.Close();
if (Session["ConfranceID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtar"] != null)
{
txtAxtar.Text = Session["txtAxtar"].ToString();
}
GetConfrance(txtAxtar.Text);
txtMeruzeninAdi.Text = "";
txtKonfransinAdi.Text = "";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtTeshkilatAdi.Text = "";
txtsehifeIlk.Text = "";
txtsehifeSon.Text = "";
txtLink.Text = "";
DateSonTarix.Text = "";
DateIlkTarix.Text = "";
DDLStatusu.SelectedIndex = 0;
DDLIndexs.SelectedIndex = 0;
Session["ConfranceID"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
else
{
ClSsql.MsgBox("Xəta baş verdi", Page);
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openModal();", true);
}
}
else
{
ClSsql.MsgBox("Məlumat tam deyil", Page);
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openModal();", true);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["MonoqrafiyaID"].ToString() == "0" && txtAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"insert into MonoqrafiyaKitab (Adi
,NeshriyyatinAdi
,Olke
,TeshkilatinAdi
,Cildi
,CildNomre
,NeshrIli
,Sehifeilk
,LinkURL
,ShexsiProfilID
,Muellifler,MonoqrafiyaIndex) values(@Adi
,@NeshriyyatinAdi
,@Olke
,@TeshkilatinAdi
,@Cildi
,@CildNomre
,@NeshrIli
,@Sehifeilk
,@LinkURL
,@ShexsiProfilID
,@Muellifler
,@MonoqrafiyaIndex)", clSsql.sqlconn);
cmd.Parameters.AddWithValue("Adi", txtAdi.Text);
if (CheckboxNeshriyyatinAdi.Checked == false)
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", DDLNeshriyyatinAdi.SelectedValue);
}
else
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", txtNeshriyyatinAdi.Text);
}
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatinAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrIli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
// cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtLink.Text);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
cmd.Parameters.AddWithValue("MonoqrafiyaIndex", DDLIndex.SelectedValue);
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
DataRow dr = clSsql.getDT(@"Select * from MonoqrafiyaKitab where ID=(select MAX(ID) from MonoqrafiyaKitab where ShexsiProfilID=" + Session["PersonalProfilID"].ToString() + ")").Rows[0];
Session["MonoqrafiyaID"] = dr["ID"].ToString();
if (Session["MonoqrafiyaID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarKitab"] != null)
{
txtAxtar.Text = Session["txtAxtarKitab"].ToString();
}
GetMonoqrafiya(txtAxtar.Text);
txtAdi.Text = "";
DDLNeshriyyatinAdi.SelectedValue = "Yoxdur";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrIli.Text = "";
txtSehifeIlk.Text = "";
// txtHemmuellif.Text = "";
txtNeshriyyatinAdi.Text = "";
txtLink.Text = "";
DDLIndex.SelectedIndex = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
else if (Session["MonoqrafiyaID"].ToString() != "0" && txtAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"Update MonoqrafiyaKitab set Adi=@Adi
,NeshriyyatinAdi=@NeshriyyatinAdi
,Olke=@Olke
,TeshkilatinAdi=@TeshkilatinAdi
,Cildi=@Cildi
,CildNomre=@CildNomre
,NeshrILi=@NeshrILi
,Sehifeilk=@Sehifeilk
,LinkURL=@LinkURL
,Muellifler=@Muellifler
,MonoqrafiyaIndex=@MonoqrafiyaIndex
where ID=@ID", clSsql.sqlconn);
cmd.Parameters.AddWithValue("Adi", txtAdi.Text);
if (CheckboxNeshriyyatinAdi.Checked == false)
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", DDLNeshriyyatinAdi.SelectedValue);
}
else
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", txtNeshriyyatinAdi.Text);
}
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatinAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrIli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
// cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtLink.Text);
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
cmd.Parameters.AddWithValue("ID", Session["MonoqrafiyaID"].ToString());
cmd.Parameters.AddWithValue("MonoqrafiyaIndex", DDLIndex.SelectedValue.ToString());
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
SqlCommand cmd1 = new SqlCommand("Delete from HemmuellifKitabMonoqrafiya where KitabMonoqrafiyaID=" + Session["MonoqrafiyaID"].ToString(), clSsql.sqlconn);
clSsql.sqlconn.Open();
cmd1.ExecuteNonQuery();
clSsql.sqlconn.Close();
if (Session["MonoqrafiyaID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarKitab"] != null)
{
txtAxtar.Text = Session["txtAxtarKitab"].ToString();
}
GetMonoqrafiya(txtAxtar.Text);
txtAdi.Text = "";
DDLNeshriyyatinAdi.SelectedValue = "Yoxdur";
txtNeshriyyatinAdi.Text = "";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrIli.Text = "";
txtSehifeIlk.Text = "";
txtLink.Text = "";
DDLIndex.SelectedIndex = 0;
Session["MonoqrafiyaID"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtMeqaleAdi.Text.Trim().Length > 2)
{
if (Session["ScienceArticleID"].ToString() == "0" && Session["PersonalProfilID"].ToString() != "0" && Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"insert into TBScienceArticle values(@Adi
,@JurnalinAdi
,@NeshriyyatinAdi
,@Olke
,@TeshkilatinAdi
,@Cildi
,@CildNomre
,@NeshrIli
,@Sehifeilk
,@SehifeSon
,@LinkURL
,@IndexArticle
,@ShexsiProfilID
,@Muellifler)", clSsql.sqlconn); //,@Muellifler
cmd.Parameters.AddWithValue("Adi", txtMeqaleAdi.Text);
cmd.Parameters.AddWithValue("JurnalinAdi", TxtJurnalinAdi.Text);
if (CheckboxNeshriyyatinAdi.Checked == false)
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", DDLNeshriyyatinAdi.SelectedValue);
}
else
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", txtNeshriyyatinAdi.Text);
}
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrİli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtlink.Text);
cmd.Parameters.AddWithValue("IndexArticle", DDLIndex.SelectedValue);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
cmd.Parameters.AddWithValue("Muellifler", s);
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
DataRow dr = clSsql.getDT(@"Select * from TBScienceArticle where ID=(select MAX(ID) from TBScienceArticle where ShexsiProfilID=" + Session["PersonalProfilID"].ToString() + ")").Rows[0];
Session["ScienceArticleID"] = dr["ID"].ToString();
if (Session["ScienceArticleID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
GetHemmuellif();
txtnameMuellif.Text = "";
txtsiramuellif.Text = "";
clSsql.sqlconn.Close();
if (Session["txtAxtarMql"] != null)
{
txtAxtar.Text = Session["txtAxtarMql"].ToString();
}
GetScienceArticle(txtAxtar.Text);
txtMeqaleAdi.Text = "";
TxtJurnalinAdi.Text = "";
DDLNeshriyyatinAdi.SelectedValue = "Yoxdur";
txtNeshriyyatinAdi.Text = "";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrİli.Text = "";
txtSehifeIlk.Text = "";
txtSehifeSon.Text = "";
txtlink.Text = "";
txtTeshkilatAdi.Text = "";
// txtHemmuellif.Text = "";
DDLIndex.SelectedIndex = 0;
ViewState["addedBooks"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
else if (Session["ScienceArticleID"].ToString() != "0" && Session["PersonalProfilID"].ToString() != "0" && Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"Update TBScienceArticle set Adi=@Adi,
JurnalinAdi=@JurnalinAdi
,NeshriyyatinAdi=@NeshriyyatinAdi
,Olke=@Olke
,TeshkilatinAdi=@TeshkilatinAdi
,Cildi=@Cildi
,CildNomre=@CildNomre
,NeshrIli=@NeshrIli
,Sehifeilk=@Sehifeilk
,SehifeSon=@SehifeSon
,LinkURL=@LinkURL
,IndexArticle=@IndexArticle
,Muellifler=@Muellifler
where ID=@ID", clSsql.sqlconn); //
cmd.Parameters.AddWithValue("Adi", txtMeqaleAdi.Text);
cmd.Parameters.AddWithValue("JurnalinAdi", TxtJurnalinAdi.Text);
if (CheckboxNeshriyyatinAdi.Checked == false)
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", DDLNeshriyyatinAdi.SelectedValue);
}
else
{
cmd.Parameters.AddWithValue("NeshriyyatinAdi", txtNeshriyyatinAdi.Text);
}
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Olke", DDLOlke.SelectedValue);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtTeshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrİli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("LinkURL", txtlink.Text);
cmd.Parameters.AddWithValue("IndexArticle", DDLIndex.SelectedValue);
cmd.Parameters.AddWithValue("Muellifler", s);
cmd.Parameters.AddWithValue("ID", Session["ScienceArticleID"].ToString());
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
SqlCommand cmd1 = new SqlCommand("Delete from HemmuellifArticle where ArticleID=" + Session["ScienceArticleID"].ToString(), clSsql.sqlconn);
clSsql.sqlconn.Open();
cmd1.ExecuteNonQuery();
clSsql.sqlconn.Close();
if (Session["ScienceArticleID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarMql"] != null)
{
txtAxtar.Text = Session["txtAxtarMql"].ToString();
}
GetScienceArticle(txtAxtar.Text);
txtMeqaleAdi.Text = "";
TxtJurnalinAdi.Text = "";
DDLNeshriyyatinAdi.SelectedValue = "Yoxdur";
DDLOlke.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrİli.Text = "";
txtSehifeIlk.Text = "";
txtSehifeSon.Text = "";
txtlink.Text = "";
DDLIndex.SelectedIndex = 0;
txtTeshkilatAdi.Text = "";
// txtHemmuellif.Text = "";
txtNeshriyyatinAdi.Text = "";
Session["ScienceArticleID"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
else
{
ClSsql.MsgBox("Xəta baş verdi", Page);
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openModal();", true);
}
}
else
{
ClSsql.MsgBox("Məlumat tam deyil", Page);
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openModal();", true);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["PatentIxtiraID"].ToString() == "0" && txtPatentinAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"insert into TBPatentIxtiralar values(@PatentinAdi
,@PatentinKodu
,@SenedinNomresi
,@IlkinlikTarixi
,@ReystrTarix
,@PatentinSahibi
,@ShexsiProfilID
,@Muellifler)", clSsql.sqlconn);
cmd.Parameters.AddWithValue("PatentinAdi", txtPatentinAdi.Text);
cmd.Parameters.AddWithValue("PatentinKodu", txtPatentinKodu.Text);
cmd.Parameters.AddWithValue("SenedinNomresi", txtIddiaNomresi.Text);
DateTime d;
if (DateTime.TryParse(txtIlkinlikTarixi.Text, out d) == true)
{
cmd.Parameters.AddWithValue("IlkinlikTarixi", DateTime.Parse(txtIlkinlikTarixi.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("IlkinlikTarixi", DBNull.Value);
}
if (DateTime.TryParse(txtRegstrTarixi.Text, out d) == true)
{
cmd.Parameters.AddWithValue("ReystrTarix", DateTime.Parse(txtRegstrTarixi.Text).ToString("yyyy-MM-dd"));
}
else
{
cmd.Parameters.AddWithValue("ReystrTarix", DBNull.Value);
}
cmd.Parameters.AddWithValue("PatentinSahibi", txtSahibi.Text);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
DataRow dr = clSsql.getDT(@"Select * from TBPatentIxtiralar where ID=(select MAX(ID) from TBPatentIxtiralar where ShexsiProfilID=" + Session["PersonalProfilID"].ToString() + ")").Rows[0];
Session["PatentIxtiraID"] = dr["ID"].ToString();
if (Session["PatentIxtiraID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarPatent"] != null)
{
txtAxtar.Text = Session["txtAxtarPatent"].ToString();
}
GetPatentIxtira(txtAxtar.Text);
txtPatentinAdi.Text = "";
txtPatentinKodu.Text = "";
txtIddiaNomresi.Text = "";
txtIlkinlikTarixi.Text = "";
txtRegstrTarixi.Text = "";
txtSahibi.Text = "";
//txtHemmuellif.Text = "";
Response.Redirect(Request.Url.AbsoluteUri);
}
else if (Session["PatentIxtiraID"].ToString() != "0" && txtPatentinAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"Update TBPatentIxtiralar set PatentinAdi=@PatentinAdi,
PatentinKodu=@PatentinKodu
,SenedinNomresi=@SenedinNomresi
,IlkinlikTarixi=@IlkinlikTarixi
,ReystrTarix=@ReystrTarix
,PatentinSahibi=@PatentinSahibi
,Muellifler=@Muellifler
where ID=@ID", clSsql.sqlconn);
cmd.Parameters.AddWithValue("PatentinAdi", txtPatentinAdi.Text);
cmd.Parameters.AddWithValue("PatentinKodu", txtPatentinKodu.Text);
cmd.Parameters.AddWithValue("SenedinNomresi", txtIddiaNomresi.Text);
cmd.Parameters.AddWithValue("IlkinlikTarixi", DateTime.Parse(txtIlkinlikTarixi.Text).ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("ReystrTarix", DateTime.Parse(txtRegstrTarixi.Text).ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("PatentinSahibi", txtSahibi.Text);
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
cmd.Parameters.AddWithValue("ID", Session["PatentIxtiraID"].ToString());
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
SqlCommand cmd1 = new SqlCommand("Delete from HemmuellifPatentIxtira where PatentID=" + Session["PatentIxtiraID"].ToString(), clSsql.sqlconn);
clSsql.sqlconn.Open();
cmd1.ExecuteNonQuery();
clSsql.sqlconn.Close();
if (Session["PatentIxtiraID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarPatent"] != null)
{
txtAxtar.Text = Session["txtAxtarPatent"].ToString();
}
GetPatentIxtira(txtAxtar.Text);
txtPatentinAdi.Text = "";
txtPatentinKodu.Text = "";
txtIddiaNomresi.Text = "";
txtIlkinlikTarixi.Text = "";
txtRegstrTarixi.Text = "";
txtSahibi.Text = "";
//txtHemmuellif.Text = "";
Session["PatentIxtiraID"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["DerslikID"].ToString() == "0" && txtDersliyinAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"insert into Derslikler (DerslikAdi, ResursunNovu
,Fenn
,TeshkilatinAdi
,Cildi
,CildNomre
,NeshrIli
,Sehifeilk
,TedrisDili
,ShexsiProfilID
,Muellifler)
values(@DerslikAdi
,@ResursunNovu
,@Fenn
,@TeshkilatinAdi
,@Cildi
,@CildNomre
,@NeshrIli
,@Sehifeilk
,@TedrisDili
,@ShexsiProfilID
,@Muellifler)", clSsql.sqlconn);
cmd.Parameters.AddWithValue("DerslikAdi", txtDersliyinAdi.Text);
cmd.Parameters.AddWithValue("ResursunNovu", DDLResursunNovu.SelectedValue);
cmd.Parameters.AddWithValue("Fenn", txtFenn.Text);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtteshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrIli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
// cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("TedrisDili", DDLTedrisDili.SelectedValue);
cmd.Parameters.AddWithValue("ShexsiProfilID", Session["PersonalProfilID"].ToString());
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
DataRow dr = clSsql.getDT(@"Select * from Derslikler where ID=(select MAX(ID) from Derslikler where ShexsiProfilID=" + Session["PersonalProfilID"].ToString() + ")").Rows[0];
Session["DerslikID"] = dr["ID"].ToString();
if (Session["DerslikID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarDerslik"] != null)
{
txtAxtar.Text = Session["txtAxtarDerslik"].ToString();
}
GetDerslikler(txtAxtar.Text);
txtDersliyinAdi.Text = "";
DDLResursunNovu.SelectedIndex = 0;
DDLTedrisDili.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrIli.Text = "";
txtSehifeIlk.Text = "";
// txtSehifeSon.Text = "";
//txtHemmuellif.Text = "";
txtFenn.Text = "";
Response.Redirect(Request.Url.AbsoluteUri);
}
else if (Session["DerslikID"].ToString() != "0" && txtDersliyinAdi.Text != "" && Session["PersonalProfilID"].ToString() != "0" &&
Session["PersonalProfilID"] != null)
{
SqlCommand cmd = new SqlCommand(@"Update Derslikler set DerslikAdi=@DerslikAdi
,ResursunNovu=@ResursunNovu
,Fenn=@Fenn
,TeshkilatinAdi=@TeshkilatinAdi
,Cildi=@Cildi
,CildNomre=@CildNomre
,NeshrILi=@NeshrILi
,Sehifeilk=@Sehifeilk
,TedrisDili=@TedrisDili
,Muellifler=@Muellifler
where ID=@ID", clSsql.sqlconn);
cmd.Parameters.AddWithValue("DerslikAdi", txtDersliyinAdi.Text);
cmd.Parameters.AddWithValue("ResursunNovu", DDLResursunNovu.SelectedValue);
cmd.Parameters.AddWithValue("Fenn", txtFenn.Text);
cmd.Parameters.AddWithValue("TeshkilatinAdi", txtteshkilatAdi.Text);
cmd.Parameters.AddWithValue("Cildi", txtCildi.Text);
cmd.Parameters.AddWithValue("CildNomre", txtCildNomre.Text);
cmd.Parameters.AddWithValue("NeshrIli", txtNeshrIli.Text);
cmd.Parameters.AddWithValue("Sehifeilk", txtSehifeIlk.Text);
// cmd.Parameters.AddWithValue("SehifeSon", txtSehifeSon.Text);
cmd.Parameters.AddWithValue("TedrisDili", DDLTedrisDili.SelectedValue);
string s = "";
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
s += txtmuellifarray.Text + ", ";
}
if (s.Length > 2)
{
s = s.Substring(0, s.Length - 2);
}
cmd.Parameters.AddWithValue("Muellifler", s);
cmd.Parameters.AddWithValue("ID", Session["DerslikID"].ToString());
clSsql.sqlconn.Open();
cmd.ExecuteNonQuery();
clSsql.sqlconn.Close();
int n = 0;
SqlCommand cmd1 = new SqlCommand("Delete from HemmuellifDerslik where DerslikID=" + Session["DerslikID"].ToString(), clSsql.sqlconn);
clSsql.sqlconn.Open();
cmd1.ExecuteNonQuery();
clSsql.sqlconn.Close();
if (Session["DerslikID"] != null)
{
foreach (TextBox txtmuellifarray in divMuellif.Controls.OfType <TextBox>())
{
n++;
TextBox t = (TextBox)NumdivMuellif.FindControl("NomTxtMuellif" + n.ToString());
TextBox t1 = (TextBox)divMuellif.FindControl("TxtMuellif" + n.ToString());
if (t.Text != "")
{
insertMuellif(t1.Text, int.Parse(t.Text));
}
else
{
insertMuellif(t1.Text, 1);
}
}
}
ViewState["addedBooks"] = 0;
if (Session["txtAxtarDerslik"] != null)
{
txtAxtar.Text = Session["txtAxtarDerslik"].ToString();
}
GetDerslikler(txtAxtar.Text);
txtDersliyinAdi.Text = "";
DDLResursunNovu.SelectedIndex = 0;
DDLTedrisDili.SelectedIndex = 0;
txtCildi.Text = "";
txtCildNomre.Text = "";
txtNeshrIli.Text = "";
txtSehifeIlk.Text = "";
// txtSehifeSon.Text = "";
txtFenn.Text = "";
//txtHemmuellif.Text = "";
Session["DerslikID"] = 0;
Response.Redirect(Request.Url.AbsoluteUri);
}
}
