public static string getmodulNamebyid(int Lg)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select MODUL_NAME from MODUL where MODUL_ID in (select MODUL_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@log))", new SqlParameter[] { new SqlParameter("@log", Lg) }, CommandType.Text);
List <MODUL> ms = new List <MODUL>();
foreach (DataRow item in dt.Rows)
{
MODUL m = new MODUL();
m.MODUL_NAME = item["MODUL_NAME"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public static string GetHasModules(int C)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select MODUL_ID, MODUL_NAME from MODUL where MODUL_ID in(select MODUL_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID in(select LOG_IN_ID from ACCOUNT where CLIENT_ID=@C)))", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text);
List <MODUL> ms = new List <MODUL>();
foreach (DataRow item in dt.Rows)
{
MODUL m = new MODUL();
m.MODUL_NAME = item["MODUL_NAME"].ToString();
m.MODUL_ID = Convert.ToInt32(item["MODUL_ID"]);
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
private void Button3_Click(object sender, EventArgs e)
{
// Sil
DialogResult dr = MessageBox.Show("Silmek istediğinize emin misiniz?", "DİKKAT", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.No)
{
return;
}
if (txtMODUL_REFNO.Text != "")
{
MODUL m = new MODUL();
m.MODUL_REFNO = Convert.ToInt32(txtMODUL_REFNO.Text);
m.Delete();
dbtables.MODULS = MODUL.Load();
dataGridView1.DataSource = dbtables.MODULS;
}
}
private void Button2_Click(object sender, EventArgs e)
{
// Kaydet
MODUL m = new MODUL();
if (txtMODUL_REFNO.Text != "")
{
m.MODUL_REFNO = Convert.ToInt32(txtMODUL_REFNO.Text);
m.MODUL_ADI = txtMODUL_ADI.Text;
m.Update();
}
else
{
m.MODUL_ADI = txtMODUL_ADI.Text;
m.Insert();
}
dbtables.MODULS = MODUL.Load();
dataGridView1.DataSource = dbtables.MODULS;
}
