protected void btnSave_Click(object sender, EventArgs e)
{
tbl_WorkShop Wp = new tbl_WorkShop();
Wp.WorkShopTitle = txtWorkShopTitle.Text;
Wp.WorkShopDate = DateTime.Parse(txtWorkShopDate.Text);
Wp.WorkShopTopics = txtWorkShopTopics.Text;
Wp.WorkShopDuration = txtWorkShopDuration.Text;
List <int> Ls = new List <int>();
foreach (ListItem item in ckbLTrainers.Items)
{
int TrainerId;
if (item.Selected)
{
TrainerId = int.Parse(item.Value);
Ls.Add(TrainerId);
}
}
WorkShopBusiness WB = new WorkShopBusiness();
if (WB.InsertWorkShop(Wp, Ls))
{
lblMessage.Text = "Saved Successfully";
ClearData();
}
GetWorkShops();
}
private void GetWorkShops()
{
WorkShopBusiness WB = new WorkShopBusiness();
List <tbl_WorkShop> Ls = WB.GetWorkShops();
GridView1.DataSource = Ls;
GridView1.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
WorkShopBusiness Wb = new WorkShopBusiness();
int id = int.Parse(gridviewWorkShop.SelectedValue.ToString());
Wb.DeleteWorkShopById(id);
GetWorkShops();
}
private void GetWorkShopRequest()
{
WorkShopBusiness WB = new WorkShopBusiness();
List <WorkShopRequest> Ls = WB.GetWorkShopRequestForStudent();
grdWorkShopRequest.DataSource = Ls;
grdWorkShopRequest.DataBind();
}
private void GetWorkShops()
{
WorkShopBusiness WB = new WorkShopBusiness();
List <tbl_WorkShop> Ls = WB.GetWorkShops();
ddlWorkShop.DataSource = Ls;
ddlWorkShop.DataValueField = "WorkShopId";
ddlWorkShop.DataTextField = "WorkShopTitle";
ddlWorkShop.DataBind();
}
protected void gridviewWorkShop_SelectedIndexChanged(object sender, EventArgs e)
{
int id = int.Parse(gridviewWorkShop.SelectedValue.ToString());
WorkShopBusiness WB = new WorkShopBusiness();
tbl_WorkShop Wp = WB.GetWorkShopById(id);
txtWorkShopTitle.Text = Wp.WorkShopTitle;
txtWorkShopDuration.Text = Wp.WorkShopDuration;
txtWorkShopDate.Text = Wp.WorkShopDate.ToString();
txtWorkShopTopics.Text = Wp.WorkShopTopics;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
WorkShopBusiness WB = new WorkShopBusiness();
int id = int.Parse(GridView1.SelectedValue.ToString());
if (WB.DeleteWorkShopById(id))
{
lblMessage.Text = "Deleted Successfully";
ClearData();
}
GetWorkShops();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int id = int.Parse(GridView1.SelectedValue.ToString());
WorkShopBusiness WB = new WorkShopBusiness();
tbl_WorkShop Wp = WB.GetWorkShopById(id);
txtWorkShopTitle.Text = Wp.WorkShopTitle;
txtWorkShopDate.Text = Wp.WorkShopDate.Date.ToString();
txtWorkShopDuration.Text = Wp.WorkShopDuration;
txtWorkShopTopics.Text = Wp.WorkShopTopics;
ckbLTrainers.ClearSelection();
}
protected void btnSave_Click(object sender, EventArgs e)
{
tbl_WorkShop Wp = new tbl_WorkShop();
Wp.WorkShopTitle = txtWorkShopTitle.Text;
Wp.WorkShopDate = DateTime.Parse(txtWorkShopDate.Text);
Wp.WorkShopDuration = txtWorkShopDuration.Text;
Wp.WorkShopTopics = txtWorkShopTopics.Text;
WorkShopBusiness Wb = new WorkShopBusiness();
Wb.InsertWorkShop(Wp);
GetWorkShops();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
tbl_WorkShop Wp = new tbl_WorkShop();
Wp.WorkShopTitle = txtWorkShopTitle.Text;
Wp.WorkShopDate = DateTime.Parse(txtWorkShopDate.Text);
Wp.WorkShopDuration = txtWorkShopDuration.Text;
Wp.WorkShopTopics = txtWorkShopTopics.Text;
WorkShopBusiness Wb = new WorkShopBusiness();
int id = int.Parse(gridviewWorkShop.SelectedValue.ToString());
Wb.UpdateWorkShopById(Wp, id);
GetWorkShops();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string Title = (txtWorkShopTitle.Text != "") ? txtWorkShopTitle.Text : null;
DateTime?Date = null;
if (txtWorkShopDate.Text != "")
{
Date = DateTime.Parse(txtWorkShopDate.Text);
}
string Duration = (txtWorkShopDuration.Text != "") ? txtWorkShopDuration.Text : null;
WorkShopBusiness Wb = new WorkShopBusiness();
var result = Wb.SearchWorkShop(Title, Date, Duration);
grdworkshop.DataSource = result;
grdworkshop.DataBind();
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
int Sid = int.Parse(grdWorkShopRequest.DataKeys[grdWorkShopRequest.SelectedIndex].Values["UserId"].ToString());
int Wid = int.Parse(grdWorkShopRequest.DataKeys[grdWorkShopRequest.SelectedIndex].Values["WorkShopId"].ToString());
bool IsAppOrRej = bool.Parse(rblApproveReject.SelectedValue.ToString());
tbl_Student_WorkShop_Mapping swp = new tbl_Student_WorkShop_Mapping();
swp.StudentId = Sid;
swp.WorkShopId = Wid;
swp.IsApproved = IsAppOrRej;
WorkShopBusiness WB = new WorkShopBusiness();
WB.AppOrRejectWorkShopRequest(swp);
GetWorkShopRequest();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
tbl_WorkShop Wp = new tbl_WorkShop();
Wp.WorkShopTitle = txtWorkShopTitle.Text;
Wp.WorkShopDate = DateTime.Parse(txtWorkShopDate.Text);
Wp.WorkShopTopics = txtWorkShopTopics.Text;
Wp.WorkShopDuration = txtWorkShopDuration.Text;
WorkShopBusiness WB = new WorkShopBusiness();
int id = int.Parse(GridView1.SelectedValue.ToString());
if (WB.UpdateWorkShopById(Wp, id))
{
lblMessage.Text = "Updated Successfully";
ClearData();
}
GetWorkShops();
}
protected void Button1_Click(object sender, EventArgs e)
{
List <tbl_Trainer_WorkShop_Mapping> Ls = new List <tbl_Trainer_WorkShop_Mapping>();
int WorkShopId = int.Parse(grdworkshop.SelectedValue.ToString());
foreach (ListItem item in ckbLTrainers.Items)
{
if (item.Selected)
{
int TrainerId = int.Parse(item.Value);
tbl_Trainer_WorkShop_Mapping twm = new tbl_Trainer_WorkShop_Mapping();
twm.WorkShopId = WorkShopId;
twm.TrainerId = TrainerId;
Ls.Add(twm);
}
}
if (Ls.Count > 0)
{
WorkShopBusiness WB = new WorkShopBusiness();
WB.AssignTrainersToWorkShop(Ls);
}
}
