public static hizmet Select(int Id)
{
OleDbCommand komut = new OleDbCommand("usp_hizmetSelect");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pId", Id)
};
komut.Parameters.AddRange(parametreler);
return(ClassDAL.Selecthizmet(komut));
}
public HttpResponseMessage SelectDepartmentName()
{
HttpResponseMessage message;
try
{
ClassDAL dal = new ClassDAL();
var dynobj = new { result = dal.SelectDepartmentName() };
message = Request.CreateResponse(HttpStatusCode.OK, dynobj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" });
}
return(message);
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Visible = true;
if (DropDownList2.SelectedIndex == 0 || DropDownList1.SelectedIndex == 0)
{
Label1.Text = "Select a Valid value";
}
else
{
objBEL = new MasterBEL();
objDAL = new ClassDAL();
objBEL.branch = TextBox1.Text;
objBEL.course = DropDownList1.SelectedValue;
Label1.Text = objDAL.AddBranch(objBEL);
}
GridView1.DataBind();
}
protected void Button1_Click1(object sender, EventArgs e)
{
Label1.Visible = true;
if (DropDownList2.SelectedIndex == 0)
{
Label1.Text = "Select a Valid value";
}
else
{
objBEL = new MasterBEL();
objDAL = new ClassDAL();
objBEL.designation = TextBox1.Text;
Label1.Visible = true;
Label1.Text = objDAL.AddDesignation(objBEL);
GridView1.DataBind();
}
}
public static void HandleDeleteClass(ListView lvwClass, string id_class)
{
foreach (ListViewItem item in lvwClassState.Items)
{
if (item.SubItems[0].Text == id_class)
{
bool result = ClassDAL.DeleteClassWithId(id_class);
if (result)
{
lvwClassState.Items.Remove(item);
RenderListViewWithCourseAndFaculty(lvwClass);
}
return;
}
}
MessageBox.Show(MessageBoxText.NotSelectListView, MessageBoxText.CaptionWarning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
private void btnConfirm_Click(object sender, EventArgs e)
{
ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem;
ClassDAL classDAL = new ClassDAL();
classDAL.ConnectToDatabase();
try
{
if (classDAL.DeleteClass(currentObject.ClassId))
{
MessageBox.Show("Xoá lớp thành công!!!");
}
}
catch (Exception)
{
MessageBox.Show("Xoá lớp thất bại!!!");
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
Label1.Visible = true;
if (DropDownList2.SelectedIndex == 0 || DropDownList1.SelectedIndex == 0)
{
Label1.Text = "Select a Valid value";
}
else
{
objBEL = new MasterBEL();
objDAL = new ClassDAL();
objBEL.examType = TextBox1.Text;
objBEL.course = DropDownList1.SelectedValue;
objBEL.dur = int.Parse(TextBox2.Text);
Label1.Text = objDAL.AddExamType(objBEL);
GridView1.DataBind();
}
}
public Result <int> Delete()
{
OleDbCommand komut = new OleDbCommand("usp_epostaListDelete");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pId", this.Id)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(ClassDAL.ExecuteWithResult(komut));
}
private void btnDelete_Click(object sender, EventArgs e)
{
//xoa lop hoc
//if (this.dgvListClass.SelectedRows.Count > 0)
//{
// ClassDAL classDAL = new ClassDAL();
// classDAL.ConnectToDatabase();
// ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem;
// if(classDAL.DeleteClass(currentObject.ClassId))
// {
// classDAL = new ClassDAL();
// classDAL.ConnectToDatabase();
// dgvListClass.DataSource = classDAL.GetAllClass();
// dgvListClass.Update();
// dgvListClass.Refresh();
// }
//}
//DeleteClassForm f = new DeleteClassForm();
//this.Hide();
//f.ShowDialog();
//this.Show();
ClassDAL classDAL = new ClassDAL();
SignupDAL signupDAL = new SignupDAL();
classDAL.ConnectToDatabase();
ClassDTO currentObject = (ClassDTO)dgvListClass.CurrentRow.DataBoundItem;
nameClass = currentObject.ClassId.ToUpperInvariant();
DialogResult dialogResult = MessageBox.Show("Bạn có chắc xoá lớp học: " + nameClass, "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
signupDAL.DeleteSignup(nameClass);
classDAL.DeleteClass(nameClass);
MessageBox.Show("Xoá lớp học thành công!!!");
this.Close();
ClassForm f = new ClassForm();
f.Show();
}
;
}
protected void Button1_Click(object sender, EventArgs e)
{
objBEL = new stuwork();
objDAL = new ClassDAL();
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
TextBox txtrow = (row.Cells[0].FindControl("TextBox1") as TextBox);
DropDownList droprow = (row.Cells[0].FindControl("DropDownList1") as DropDownList);
objBEL.fbCate = droprow.SelectedValue;
Label name = (row.Cells[0].FindControl("Label1") as Label);
Label teacher = (row.Cells[0].FindControl("Label2") as Label);
objBEL.name = teacher.Text;
objBEL.emailId = name.Text;
objBEL.remark = txtrow.Text;
Label1.Text = objDAL.AddFeedback(objBEL);
}
}
}
public static void HandleUpdateClass(ListView lvwClass, Class classModel)
{
bool courseResult = ClassDAL.UpdateClassWithId(classModel);
if (courseResult)
{
foreach (ListViewItem item in lvwClassState.Items)
{
if (item.SubItems[0].Text == classModel.IdClass)
{
ListViewItem itemUser = ClassModelToListViewItem(classModel);
for (int i = 0; i < item.SubItems.Count; i++)
{
item.SubItems[i].Text = i < itemUser.SubItems.Count ?
itemUser.SubItems[i].Text ?? null : string.Empty;
}
}
}
RenderListViewWithCourseAndFaculty(lvwClass);
}
}
public Result <int> Update()
{
OleDbCommand komut = new OleDbCommand("usp_markaUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pId", Id)
, new OleDbParameter("pResim", Resim)
, new OleDbParameter("pAdi", Adi)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(ClassDAL.ExecuteWithResult(komut));
}
public Result <int> Update()
{
OleDbCommand komut = new OleDbCommand("usp_epostaListUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pId", Id)
, new OleDbParameter("pEposta", Eposta)
, new OleDbParameter("pTarih", Tarih.ToString())
, new OleDbParameter("pTelefon", Telefon)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(ClassDAL.ExecuteWithResult(komut));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_markaInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
//new OleDbParameter("pId", Id)
new OleDbParameter("pResim", Resim)
, new OleDbParameter("pAdi", Adi)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
OleDbCommand komutIdentity = new OleDbCommand("SELECT @@Identity FROM marka");
return(ClassDAL.ExecuteReturnIdentity(komut, komutIdentity));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_sayacInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pTarih", Tarih)
//,new OleDbParameter("pGunluk", Gunluk)
//,new OleDbParameter("pAylik", Aylik)
, new OleDbParameter("pYillik", Yillik)
, new OleDbParameter("pToplam", Toplam)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(ClassDAL.ExecuteWithResult(komut));
}
private void btConfim_Click(object sender, EventArgs e)
{
ClassDAL classDAL = new ClassDAL();
classDAL.ConnectToDatabase();
ClassDTO classDTO = new ClassDTO(textboxClassID.Text, textboxClassName.Text, textboxStartingHour.Text, startDate.Value, endDate.Value, ((ProgramDTO)comboBoxProgram.SelectedItem).ProgramId.ToString());
try
{
if (classDAL.UpdateClass(classDTO))
{
MessageBox.Show("Đổi lớp thành công!!!");
this.Close();
ClassForm f = new ClassForm();
f.Show();
}
}
catch (Exception)
{
MessageBox.Show("Thay đổi thất bại!!!");
}
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_epostaListInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
//new OleDbParameter("pId", Id)
new OleDbParameter("pEposta", Eposta)
, new OleDbParameter("pTarih", Tarih.ToString())
, new OleDbParameter("pTelefon", Telefon)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
OleDbCommand komutIdentity = new OleDbCommand("SELECT @@Identity FROM epostaList");
return(ClassDAL.ExecuteReturnIdentity(komut, komutIdentity));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_haberInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pBaslik", Baslik)
, new OleDbParameter("pResim", Resim)
, new OleDbParameter("pYazi", Yazi)
, new OleDbParameter("pTarih", Tarih)
, new OleDbParameter("pAktif", Aktif)
, new OleDbParameter("pAltBaslik", AltBaslik)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(ClassDAL.ExecuteWithResult(komut));
}
// Delete Class
public static string deleteClass(long CL)
{
int val = ClassDAL.isClassIDUsed(CL);
if (val > 0)
{
return("This Class can't be deleted as it is used in other files!");
}
else
{
// Delete Query
SqlParameter para = new SqlParameter("@CL", CL);
string SQLRDelete = "delete from Classes where ClassID=@CL";
int rt = SqlHelper.ExecuteNonQuery(SqlHelper.Connect, CommandType.Text, SQLRDelete, para);
if (rt > 0)
{
return("Class Deleted Successfully");
}
else
{
return("Class not deleted or doesn't exist");
}
}
}
//public static ObservableCollection<Class> GetAllId(long idClass)
//{
// return (ClassDAL.GetAllId(idClass));
//}
public bool CheckRegistration(long id)
{
bool res = ClassDAL.CheckRegistration(id);
return(res);
}
public static ObservableCollection <Class> GetAll()
{
return(ClassDAL.GetAll());
}
public bool Update()
{
return(ClassDAL.Update(this));
}
/// <summary>
/// 分页
///</summary>
public static List <Class> PageSelectClass(int pageSize, int pageIndex, string WhereSrc, string PXzd, string PXType)
{
pageIndex = pageIndex - 1;
return(ClassDAL.PageSelectClass(pageSize, pageIndex, WhereSrc, PXzd, PXType));
}
/// <summary>
/// 修改
///</summary>
public static int UpdateClass(Class ClassModel)
{
return(ClassDAL.UpdateClass(ClassModel));
}
public bool addClass(Dictionary <string, string> kv)
{
ClassDAL ClassDAL = new ClassDAL();
return(ClassDAL.addClass(kv));
}
public ClassBLL()
{
classDAL = new ClassDAL();
}
/// <summary>
/// 查询全部
///</summary>
public static List <Class> AllData(string WhereSrc, string PXzd, string PXType)
{
return(ClassDAL.AllData(WhereSrc, PXzd, PXType));
}
/// <summary>
/// 查询条数
///</summary>
public static int CountNumber(string NewWHere)
{
return(ClassDAL.CountNumber(NewWHere));
}
/// <summary>
/// 根据主键查询实体
///</summary>
public static Class GetIdByClass(int Id)
{
return(ClassDAL.GetIdByClass(Id));
}
/// <summary>
/// 根据主键删除
///</summary>
public static int DeleteClass(int Id)
{
return(ClassDAL.DeleteClass(Id));
}
