public ExpandoObject MYPS55(
int PI_1I,
int PI_2I,
string PI_3S,
string PI_4S,
string PI_5S
)
{
try
{
// Data Validations
using (TestBLL tbl = new TestBLL())
{
return(tbl.Test_MYPS55(
PI_1I,
PI_2I,
PI_3S,
PI_4S,
PI_5S
));
}
}
catch (Exception ex)
{
// Exceptions Handler
throw new Exception("Errorn Ma : " + ex.Message);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
ImageButton imgEdit = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgEdit.NamingContainer;
string id = Convert.ToString(row.Cells[0].Text);
Session["T_Id"] = Convert.ToInt32(id);
DataTable tblEmp = new TestBLL().SelectTestParaForEdit(id);
if (tblEmp.Rows.Count > 0)
{
txtParaName.Text = Convert.ToString(tblEmp.Rows[0]["ParaName"]);
txtMinPara.Text = Convert.ToString(tblEmp.Rows[0]["MinPara"]);
txtMaxPara.Text = Convert.ToString(tblEmp.Rows[0]["MaxPara"]);
ListItem item = ddlTestName.Items.FindByText(Convert.ToString(tblEmp.Rows[0]["TestName"]));
ddlTestName.SelectedValue = item.Value;
GetTestsWithPara();
btnUpdate.Visible = true;
BtnSave.Visible = false;
MultiView1.SetActiveView(View2);
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void testOlustur_btn_Click(object sender, EventArgs e)
{
sesCalmaClassBLL.PlayClickSound();
ns1.BunifuThinButton2 testOlustur_btn = sender as ns1.BunifuThinButton2;
TestEkleUC testEkleUC = testOlustur_btn.Parent as TestEkleUC;
int sinavSuresi = 0;
if (testEkleUC.sinavIsim_txt.Visible)
{
sinavSuresi = Convert.ToInt32(testEkleUC.sinavSure_txt.Text);
}
int konuSecme_cmb_SelectedValue = Convert.ToInt32(testEkleUC.konuSecme_cmb.SelectedValue);
soruBLL = new SoruBLL();
if (testEkleUC.sinavIsim_txt.Visible)
{
testBLL = new TestBLL()
{
Isim = testEkleUC.sinavIsim_txt.Text, KonuId = (int)testEkleUC.konuSecme_cmb.SelectedValue, Sure = sinavSuresi, SoruSayisi = testEkleUC.eklenenSorular_flwpnl.Controls.Count
}
}
;
else
{
testBLL = new TestBLL()
{
Isim = testEkleUC.konuSecme_cmb.SelectedText + " - Konu Kavrama Testi - ", KonuId = (int)testEkleUC.konuSecme_cmb.SelectedValue, Sure = sinavSuresi, SoruSayisi = testEkleUC.eklenenSorular_flwpnl.Controls.Count
}
};
bool islemBasariliMi = testBLL.AddData();
foreach (EklenenSoruUC soru in testEkleUC.eklenenSorular_flwpnl.Controls)
{
soruBLL.Icerik = soru.Icerik;
soruBLL.SinavId = testBLL.Id;
soruBLL.KonuId = soru.KonuId;
soruBLL.GuncellenecekSoruId = soruBLL.GetDataByExpression(x => x.Soru_SinavId == soru.SinavId && x.Soru_KonuId == soru.KonuId && x.Soru_Icerik == soru.Icerik).Id;
islemBasariliMi = soruBLL.UpdateData();
}
if (islemBasariliMi)
{
islemSureci_tslbl.Text = "Test ekleme işlemi başarılı";
}
else
{
islemSureci_tslbl.Text = "Test ekleme işlemi başarısız tekrar deneyin";
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
TestBLL test = new TestBLL();
DateTime dt = Convert.ToDateTime("24/06/2013");
DataTable dtExcel = new DataTable();
dtExcel = test.GetTypeWiseStockSummary("1", "1", dt);
ExporttoExcel(dtExcel);
}
public Form2()
{
InitializeComponent();
_testBLL = new TestBLL();
lbStu.DataSource = _testBLL.GetAllStudents().Select(x => x.StuNo).ToList();
lbStu.SelectedIndex = -1;
lbRoom.DataSource = _testBLL.GetAllRooms().Select(x => x.Name).ToList();
lbRoom.SelectedIndex = -1;
lbStuRoom.SelectedIndex = -1;
}
public IEnumerable <dept> GetData(
string T_NAME
)
{
try
{
using (TestBLL tbl = new TestBLL())
{
return(tbl.GetDeptHelper(
T_NAME
));
}
}
catch (Exception ex)
{
throw new Exception("Errorn Ma : " + ex.Message);
}
}
private void BindTests()
{
DataTable ldtShift = new TestBLL().GetAllTest();
if (ldtShift.Rows.Count > 0)
{
dgvAllTests.DataSource = ldtShift;
dgvAllTests.DataBind();
Session["DepartmentDetail"] = ldtShift;
int lintRowcount = ldtShift.Rows.Count;
//lblRowCount.Text = "<b>Total Records:</b> " + lintRowcount.ToString();
pnlShow.Style.Add(HtmlTextWriterStyle.Display, "");
hdnPanel.Value = "";
}
else
{
hdnPanel.Value = "none";
}
}
public XElement CH_P_ESTBLSH_REG_INFO(
int P_REG_ID
)
{
try
{
/// Data Validations
//if (String.IsNullOrEmpty(PI_1I))
//throw new FaultException<ValidationFault>(new ValidationFault());
using (TestBLL tbl = new TestBLL())
{
return(tbl.CH_P_ESTBLSH_REG_INFO(
P_REG_ID
));
}
}
catch (FaultException <ValidationFault> e)
{
ValidationFault fault = new ValidationFault
{
Result = true,
Message = "Parameter not correct",
Description = "Invalid Parameter Name or All Parameters are nullu"
};
throw new FaultException <ValidationFault>(
fault);
}
catch (Exception ex)
{
ValidationFault fault = new ValidationFault
{
Result = false,
Message = ex.Message,
Description = "Service have an internal error please contact service administartor [email protected]"
};
throw new FaultException <ValidationFault>(fault);
}
}
public R_View GetSP(
int dept_no,
string dept_sec_name
)
{
try
{
using (TestBLL tbl = new TestBLL())
{
return(tbl.GetSP(
dept_no,
dept_sec_name
));
}
}
catch (Exception ex)
{
throw new Exception("Errorn Ma : " + ex.Message);
}
}
private void BindTestName()
{
try
{
DataTable tblCat = new TestBLL().GetAllTest();
DataRow dr = tblCat.NewRow();
dr["TestId"] = 0;
dr["TestName"] = "---Select---";
tblCat.Rows.InsertAt(dr, 0);
ddlTestName.DataSource = tblCat;
ddlTestName.DataValueField = "TestId";
ddlTestName.DataTextField = "TestName";
ddlTestName.DataBind();
}
catch (Exception ex)
{
// lblMessage.Text = ex.Message;
}
}
public ExpandoObject Test_MYPS55_2(
int PI_1I
)
{
try
{
// Data Validations
using (TestBLL tbl = new TestBLL())
{
return(tbl.Test_MYPS55_2(
PI_1I
));
}
}
catch (Exception ex)
{
// Exceptions Handler
throw new Exception("Errorn Ma : " + ex.Message);
}
}
private void ismeGoreSecme_txt_TextChanged(object sender, EventArgs e)
{
soruBLL = new SoruBLL();
testBLL = new TestBLL();
secenekBLL = new SecenekBLL();
ListelenenSoru_btn button;
int sayac = 1;
secenekler_flwpnl.Visible = true;
listelenenSorular_flwpnl.Visible = true;
soruIcerik_txt.Visible = true;
listelenenSorular_flwpnl.Controls.Clear();
foreach (var test in testBLL.GetAllByExpression(x => x.Sinav_Ismi.Contains(ismeGoreSorgulama_txt.Text)))
{
foreach (var soru in soruBLL.GetAllByExpression(x => x.Soru_SinavId == test.Id))
{
button = new ListelenenSoru_btn();
button.SoruIcerik = soru.Soru_Icerik;
button.SoruSecenekler = new List <string>();
button.SoruId = soru.Id;
foreach (var secenek in secenekBLL.GetAllByExpression(x => x.Secenek_SoruId == soru.Id))
{
button.SoruSecenekler.Add(secenek.Secenek_Ismi + " ) " + secenek.Secenek_Icerik);
}
button.Text = testBLL.GetDataByExpression(x => x.Id == soru.Soru_SinavId).Sinav_Ismi + " - " + sayac.ToString() + ". Soru";
button.Size = new Size(185, 100);
button.FlatAppearance.BorderSize = 2;
button.FlatStyle = FlatStyle.Flat;
button.Click += new EventHandler(listelenenSoru_btn_Click);
button.FlatAppearance.BorderColor = Color.FromArgb(150, 150, 150);
button.BackColor = Color.FromArgb(0, 133, 181);
button.ForeColor = Color.Silver;
button.Font = konuSecme_cmb.Font;
listelenenSorular_flwpnl.Controls.Add(button);
sayac++;
}
sayac = 1;
}
}
private void konuyaGoreSorgulama_cmb_SelectedIndexChanged(object sender, EventArgs e)
{
soruBLL = new SoruBLL();
testBLL = new TestBLL();
secenekBLL = new SecenekBLL();
ListelenenSoru_btn button;
short sayac = 1;
secenekler_flwpnl.Visible = true;
listelenenSorular_flwpnl.Visible = true;
soruIcerik_txt.Visible = true;
listelenenSorular_flwpnl.Controls.Clear();
foreach (var soru in soruBLL.GetAllByExpression(x => x.Soru_KonuId == (int)konuyaGoreSorgulama_cmb.SelectedValue))
{
button = new ListelenenSoru_btn();
button.SoruIcerik = soru.Soru_Icerik;
button.SoruSecenekler = new List <string>();
button.SoruId = soru.Id;
foreach (var secenek in secenekBLL.GetAllByExpression(x => x.Secenek_SoruId == soru.Id))
{
button.SoruSecenekler.Add(secenek.Secenek_Ismi + " ) " + secenek.Secenek_Icerik);
}
button.Text = testBLL.GetDataByExpression(x => x.Id == soru.Soru_SinavId).Sinav_Ismi + " " + sayac.ToString() + ". Soru";
button.Size = new Size(190, 60);
button.FlatAppearance.BorderSize = 2;
button.FlatStyle = FlatStyle.Flat;
button.Click += new EventHandler(listelenenSoru_btn_Click);
button.FlatAppearance.BorderColor = Color.FromArgb(150, 150, 150);
button.BackColor = sorgulamaCümlesi_lbl.ForeColor;
button.ForeColor = Color.Silver;
button.Font = konuyaGoreSorgulama_cmb.Font;
listelenenSorular_flwpnl.Controls.Add(button);
sayac++;
}
sayac = 1;
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'ingilizcePerformansVeritabaniDataSet.Konular' table. You can move, or remove it, as needed.
//this.konularTableAdapter.Fill(this.ingilizcePerformansVeritabaniDataSet.Konular);
/*SinifBLL sinifBLL = new SinifBLL();
* sinifBLL.SilinecekSinifId = 18;
* sinifBLL.DeleteData();*/
TestBLL testBLL = new TestBLL();
testBLL.GuncellenecekTestId = 22;
testBLL.SoruSayisi = 1;
testBLL.TestCozulduMu = true;
testBLL.UpdateData();
foreach (Button button in flowLayoutPanel1.Controls)
{
if (button.Name == "buton")
{
button.ForeColor = Color.Green;
}
}
}
public XElement Test_MYPS55_4(
int PI_1I
)
{
try
{
// Data Validations
if (true)
{
}
using (TestBLL tbl = new TestBLL())
{
return(tbl.Test_MYPS55_4(
PI_1I
));
}
}
catch (Exception ex)
{
// Exceptions Handler
throw new Exception("Errorn Ma : " + ex.Message);
}
}
public object FunctionTest(string type)
{
TestBLL testBLL = new TestBLL();
return(testBLL.FunctionTest(type));
}
public HomeController(TestBLL testBLL)
{
this.testBLL = testBLL;
}
/// <summary>
/// 建構函式
/// </summary>
/// <param name="resultModel">回傳格式</param>
/// <param name="settings">Configuration設定檔</param>
public TestController(ResultModel resultModel, TestBLL testBLL)
{
this.resultModel = resultModel;
this.testBLL = testBLL;
}
