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();
WB.InsertWorkshop(Wp, Ls);
GetWorkShops();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
WorkshopBusiness WB = new WorkshopBusiness();
int id = int.Parse(GridView1.SelectedValue.ToString());
WB.DeleteWorkshopById(id);
GetWorkShops();
}
private void GetWorkShops()
{
WorkshopBusiness WB = new WorkshopBusiness();
List <tbl_Workshop> Ls = WB.GetWorkshops();
GridView1.DataSource = Ls;
GridView1.DataBind();
}
private void GetWorkShopRequest()
{
WorkshopBusiness WB = new WorkshopBusiness();
List <WorkShopRequest> Ls = WB.GetWorkshopRequest();
grdWorkShopRequest.DataSource = Ls;
grdWorkShopRequest.DataBind();
}
private void UpdateWorkshopsGrid()
{
List <tbl_Workshop> lstWorkshops = new List <tbl_Workshop>();
WorkshopBusiness workshopBusiness = new WorkshopBusiness();
lstWorkshops = workshopBusiness.GetWorkshops();
gvWorkshops.DataSource = lstWorkshops;
gvWorkshops.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 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.ToString();
txtWorkShopDuration.Text = Wp.WorkShopDuration;
txtWorkShopTopics.Text = Wp.WorkShopTopics;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
WorkshopBusiness workshopBusiness = new WorkshopBusiness();
int workshopId;
if (int.TryParse(Convert.ToString(gvWorkshops.SelectedValue), out workshopId))
{
workshopBusiness.DeleteWorkshop(workshopId);
UpdateWorkshopsGrid();
ClearInputs();
}
}
protected void gvWorkshops_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedRowWorkshopId = int.Parse(gvWorkshops.SelectedValue.ToString());
WorkshopBusiness workshopBusiness = new WorkshopBusiness();
tbl_Workshop workshop = workshopBusiness.GetWorkshopById(selectedRowWorkshopId);
txtWorkshopTitle.Text = workshop.WorkshopTitle;
txtWorkshopDate.Text = workshop.WorkshopDate.ToShortDateString();
txtWorkshopDuration.Text = workshop.WorkshopDuration;
txtWorkshopTopics.Text = workshop.WorkshopTopics;
}
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;
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.WorkShopTopics = txtWorkShopTopics.Text;
Wp.WorkShopDuration = txtWorkShopDuration.Text;
WorkshopBusiness WB = new WorkshopBusiness();
int id = int.Parse(GridView1.SelectedValue.ToString());
WB.UpdateWorkshopById(Wp, id);
GetWorkShops();
}
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 btnSave_Click(object sender, EventArgs e)
{
tbl_Workshop workshop = new tbl_Workshop();
workshop.WorkshopTitle = txtWorkshopTitle.Text;
workshop.WorkshopDate = DateTime.Parse(txtWorkshopDate.Text);
workshop.WorkshopDuration = txtWorkshopDuration.Text;
workshop.WorkshopTopics = txtWorkshopTopics.Text;
WorkshopBusiness workshopBusiness = new WorkshopBusiness();
if (workshopBusiness.InsertWorkshop(workshop))
{
UpdateWorkshopsGrid();
ClearInputs();
}
else
{
}
}
protected void btnAssign_Click(object sender, EventArgs e)
{
List <tbl_Trainer_WorkShop_Mapping> Ls = new List <tbl_Trainer_WorkShop_Mapping>();
int WorkShopId = int.Parse(GridView1.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);
}
}
