protected void gvSer_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(gvSer.Rows[e.RowIndex].Cells[7].Text);
using (ClubDBEntities club = new ClubDBEntities())
{
// check that the service is not attached
var att = club.InvoiceServices.Where(a => a.ServiceID == id).FirstOrDefault();
var re = club.Services.Where(a => a.ServiceID == id).First();
if (att == null)
{
club.Services.DeleteObject(re);
club.SaveChanges();
}
else
{
re.Deleted = true;
club.SaveChanges();
}
gvSer.DataSource = club.getServices();
gvSer.DataBind();
string Message = " تم الحذف ";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');", Message), true);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
switch (rbAdd.SelectedIndex)
{
case 0:
pnlEmp.Visible = true;
pnlDep.Visible = false;
pnlService.Visible = false;
pnlWith.Visible = false;
using (ClubDBEntities club = new ClubDBEntities())
{
gvEmp.DataSource = club.getEmployees();
gvEmp.DataBind();
}
break;
case 1:
pnlEmp.Visible = false;
pnlDep.Visible = false;
pnlService.Visible = true;
pnlWith.Visible = false;
using (ClubDBEntities club = new ClubDBEntities())
{
var r = club.getServices();
gvSer.DataSource = r;
gvSer.DataBind();
}
break;
case 2:
pnlEmp.Visible = false;
pnlDep.Visible = true;
pnlService.Visible = false;
pnlWith.Visible = false;
using (ClubDBEntities club = new ClubDBEntities())
{
var r = from i in club.Departments
orderby i.DepID
select i
;
gvDep.DataSource = r;
gvDep.DataBind();
}
break;
case 3:
pnlEmp.Visible = false;
pnlDep.Visible = false;
pnlService.Visible = false;
pnlWith.Visible = true;
using (ClubDBEntities club = new ClubDBEntities())
{
var result = club.getWithTypes();
gvWith.DataSource = result;
gvWith.DataBind();
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (ClubDBEntities club = new ClubDBEntities())
{
GridView1.DataSource = club.getServices();
GridView1.DataBind();
}
//ReportDocument report = new ReportDocument();
//report.Load(Server.MapPath("DischargeCR.rpt"));
//using (ClubDBEntities club = new ClubDBEntities())
//{
// DateTime date = new DateTime(2011, 12, 29);
// report.SetDataSource(club.getDischargeReport(1));
// CrystalReportViewer1.ReportSource = report;
//}
//ReportDocument report = new ReportDocument();
//report.Load(Server.MapPath("test.rpt"));
//ClubDBEntities club = new ClubDBEntities();
//report.SetDataSource(club.getInvoiceHeader(102));
//CrystalReportViewer1.ReportSource = report;
//Roles.CreateRole(ERoles.InternalS.ToString());
//Roles.CreateRole(ERoles.Manager.ToString());
//Roles.CreateRole(ERoles.Nutritionist.ToString());
//Roles.CreateRole(ERoles.PhysicalS.ToString());
//Roles.CreateRole(ERoles.Receptionist.ToString());
}
protected void btnSAdd_Click(object sender, EventArgs e)
{
bool sub = (rbSType.SelectedIndex == 0) ? false : true;
string name = tbSName.Text;
decimal price = Convert.ToDecimal(tbPrice.Text);
int days = string.IsNullOrEmpty(tbDays.Text)?0:Convert.ToInt32(tbDays.Text);
int dep = Convert.ToInt32(ddlSDep.SelectedValue);
using (ClubDBEntities club = new ClubDBEntities())
{
var ser = club.Services.Where(a => a.ServiceID == EditSer).First();
ser.Name = name;
ser.Sub = sub;
ser.Price = price;
ser.TotalDays = days;
ser.DepID = dep;
club.SaveChanges();
gvSer.DataSource = club.getServices();
gvSer.DataBind();
resetSer();
}
}
protected void gvSer_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(gvSer.Rows[e.RowIndex].Cells[7].Text);
using (ClubDBEntities club = new ClubDBEntities())
{
try
{
var re = club.Services.Where(a => a.ServiceID == id).First();
club.Services.DeleteObject(re);
club.SaveChanges();
gvSer.DataSource = club.getServices();
gvSer.DataBind();
string Message = " تم الحذف ";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');", Message), true);
}
catch
{
lblError.Text = "لايمكن الحذف";
lblError.Visible = true;
}
}
}
