public static IList <DetailProductModel> All()
{
var result = HttpContext.Current.Session["DetailProducts"] as IList <DetailProductModel>;
if (result == null)
{
HttpContext.Current.Session["DetailProducts"] = result =
new SampleDataContext().DetailProducts.Select(p => new DetailProductModel
{
ProductID = p.ProductID,
ProductName = p.ProductName,
UnitPrice = (decimal)p.UnitPrice.GetValueOrDefault(),
UnitsInStock = p.UnitsInStock.GetValueOrDefault(),
Discontinued = p.Discontinued,
Category = new CategoryModel()
{
CategoryID = p.Category.CategoryID, CategoryName = p.Category.CategoryName
},
Country = new CountryModel()
{
CountryID = p.Country.CountryID, CountryNameShort = p.Country.CountryNameShort, CountryNameLong = p.Country.CountryNameLong
},
CategoryID = p.CategoryID,
CountryID = p.CountryID,
CustomerRating = p.CustomerRating,
LastSupply = p.LastSupply,
QuantityPerUnit = p.QuantityPerUnit,
TargetSales = p.TargetSales,
UnitsOnOrder = p.UnitsOnOrder
}).ToList();
}
return(result);
}
private void GetComboboxList()
{
using (SampleDataContext db = new SampleDataContext())
{
var List = from ds in db.DetailSchedules
join hs in db.HeaderSchedules
on ds.ScheduleId equals hs.ScheduleId
join s in db.Subjects
on ds.SubjectId equals s.SubjectId
where ds.TeacherId == teacher.TeacherId && hs.Finalize == 1
select new
{
s.SubjectId,
s.Name,
hs.ClassName,
};
foreach (var l in List)
{
string subject = string.Format("{0} - {1}", l.SubjectId, l.Name);
string kelas = l.ClassName;
CbxSubject.Items.Add(subject);
CbxClass.Items.Add(kelas);
}
}
}
private void RefreshDGV()
{
using (SampleDataContext db = new SampleDataContext())
{
DGVStudents.DataSource = from dsc in db.DetailScores
join ds in db.DetailSchedules
on dsc.DetailId equals ds.DetailId
join s in db.Subjects
on ds.SubjectId equals s.SubjectId
join st in db.Students
on dsc.StudentId equals st.StudentId
where st.StudentId == this.student.StudentId
select new
{
s.SubjectId,
Subject = s.Name,
dsc.Assignment,
dsc.MidExam,
dsc.FinalExam
};
//foreach (DataGridViewRow row in DGVStudents.Rows)
//{
// int assignment = Convert.ToInt32(row.Cells["Assignment"].Value.ToString());
// int mid = Convert.ToInt32(row.Cells["MidExam"].Value.ToString());
// int final = Convert.ToInt32(row.Cells["FinalExam"].Value.ToString());
// int? finalscore = ((assignment * subject.Assignment) / 100) + ((mid * subject.MidExam) / 100) + ((final * subject.FinalExam) / 100);
// row.Cells["Final"].Value = finalscore;
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SampleDataContext context = new SampleDataContext();
List <Employee> l = new List <Employee>();
var qry = from a in context.tbl_employees where a.Gender == "Female"
orderby a.Salary ascending
select new Employee()
{
ID = a.Id,
Fname = a.FName,
Lname = a.Lname,
Gender = a.Gender,
Salary = a.Salary,
DepartmentId = a.DeparmentId
};
l = qry.ToList();
var e1 = from emp in context.tbl_employees
where emp.Gender == "Male"
orderby emp.Salary descending
select emp;
GridView1.DataSource = l;
GridView1.DataBind();
}
public SampleService(SampleDataContext dbContext, IHttpContextAccessor httpContextAccessor, IOptions <AppSettings> appSettings, IMapper mapper)
{
_dbContext = dbContext;
_httpContext = httpContextAccessor.HttpContext;
_appSettings = appSettings.Value;
_mapper = mapper;
}
public async Task <IHttpActionResult> Filter([FromUri(Name = "")] QuerySamplesRequest request)
{
if (request == null)
{
request = new QuerySamplesRequest();
}
if (request.Name == "badrequest")
{
return(InvalidRequest("Dude, that's a bad request.", "ValidationError"));
}
QuerySamplesResponse response;
using (var context = new SampleDataContext())
{
IQueryable <Sample> query = context.Samples;
if (!String.IsNullOrEmpty(request.Name))
{
query = query.Where(s => s.Name == request.Name);
}
var page = await query.WithNoLock(q => q.Select(request.Fields).ToPageAsync(request));
return(Page(page));
}
return(Ok(response));
}
public EmployeeFakeRepository(SampleDataContext context) : base(context)
{
#if DEBUG
//Valid if file exists for generated locally before committed
if (!Record.Exists <Employee>())
{
//Load test data
//NOTE: Remember to filter only the data that you need to test
this.FakeData = context.Employees.Select(y => new Employee
{
Id = y.Id,
EmployeeTypeId = y.EmployeeTypeId,
FirstName = y.FirstName,
LastName = y.LastName,
OfficialDocumentId = y.OfficialDocumentId,
EmployeeType = new EmployeeType
{
Id = y.EmployeeType.Id,
Name = y.EmployeeType.Name
}
}).ToList();
//Record the data
Record.RecordData(this.FakeData);
}
#endif
if (!this.FakeData.Any())
{
this.FakeData = Record.LoadData <Employee>().ToList();
}
}
private List <Student> GetStudentList()
{
using (SampleDataContext db = new SampleDataContext())
{
return(db.Students.ToList());
}
}
private void BtnInclude_Click(object sender, EventArgs e)
{
using (SampleDataContext db = new SampleDataContext())
{
if (DGVStudent.SelectedRows.Count > 0)
{
DetailClass detail = db.DetailClasses.Where(dc => dc.StudentId == selectedstudent.StudentId)
.FirstOrDefault();
if (detail == null)
{
db.DetailClasses.InsertOnSubmit(new DetailClass {
ClassName = CbxClass.SelectedItem.ToString(), StudentId = selectedstudent.StudentId
});
db.SubmitChanges();
RefreshDGVStudent();
RefreshDGVParticipate();
}
else if (detail != null)
{
db.DetailClasses.DeleteOnSubmit(detail);
db.DetailClasses.InsertOnSubmit(new DetailClass {
ClassName = CbxClass.SelectedItem.ToString(), StudentId = selectedstudent.StudentId
});
db.SubmitChanges();
RefreshDGVStudent();
RefreshDGVParticipate();
}
}
}
}
private void GetEntry()
{
using (SampleDataContext db = new SampleDataContext())
{
if (student != null)
{
TbxID.Text = student.StudentId;
TbxName.Text = student.Name;
TbxPhone.Text = student.PhoneNumber;
TbxAddress.Text = student.Address;
if (student.Photo != null)
{
PbxPicture.Image = Image.FromFile(Application.StartupPath + "\\Images\\" + student.Photo);
Oldfilename = student.Photo;
}
}
else if (teacher != null)
{
TbxID.Text = teacher.TeacherId;
TbxName.Text = teacher.Name;
TbxPhone.Text = teacher.PhoneNumber;
TbxAddress.Text = teacher.Address;
if (teacher.Photo != null)
{
PbxPicture.Image = Image.FromFile(Application.StartupPath + "\\Images\\" + teacher.Photo);
Oldfilename = teacher.Photo;
}
}
}
}
private void UpdateProfile()
{
using (SampleDataContext db = new SampleDataContext())
{
if (this.student != null)
{
Student student = db.Students.Where(s => s.StudentId == this.student.StudentId)
.FirstOrDefault();
student.Name = TbxName.Text;
student.PhoneNumber = TbxPhone.Text;
student.Address = TbxAddress.Text;
if (newpath != null)
{
student.Photo = filename;
}
this.student = student;
db.SubmitChanges();
}
else if (this.teacher != null)
{
Teacher teacher = db.Teachers.Where(t => t.TeacherId == this.teacher.TeacherId)
.FirstOrDefault();
teacher.Name = TbxName.Text;
teacher.PhoneNumber = TbxPhone.Text;
teacher.Address = TbxAddress.Text;
if (newpath != null)
{
teacher.Photo = filename;
}
this.teacher = teacher;
db.SubmitChanges();
}
}
}
public IHttpActionResult Filter([FromUri(Name = "")] QuerySamplesRequest request)
{
Logger.Trace("Fetching samples.");
if (request == null)
{
request = new QuerySamplesRequest();
}
if (request.Name == "badrequest")
{
return(InvalidRequest("Dude, that's a bad request.", "ValidationError"));
}
QuerySamplesResponse response;
using (var context = new SampleDataContext())
{
IQueryable <Sample> query = context.Samples;
if (!String.IsNullOrEmpty(request.Name))
{
query = query.Where(s => s.Name == request.Name);
}
response = new QuerySamplesResponse(query.WithNoLock(q => q.Select(request.Fields).ToPage(request)));
}
return(Ok(response));
}
protected void btn_Select_OnClick(object sender, EventArgs e)
{
SampleDataContext ctxt = new SampleDataContext();
div_EnterCriteria.Visible = true;
div_DisplayData.Visible = false;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
dbContext.DeleteEmployee();
GetData();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
dbContext.InsertEmployee();
GetData();
}
static async Task Main(string[] args)
{
//This is for demo porpouses, use dependecy injection in a real project...
SampleDataContext context = new SampleDataContext();
//**************************************************************************************
//Here you see how the same generic repo can be used for distinct entities...
GenericRepo <Customer> customersRepo = new GenericRepo <Customer>(context);
GenericRepo <Order> ordersRepo = new GenericRepo <Order>(context);
GenericRepo <Invoice> invoicesRepo = new GenericRepo <Invoice>(context);
//**************************************************************************************
Customer customer = new Customer()
{
FirstName = "Jhon"
};
await customersRepo.AddAsync(customer);
await customersRepo.SaveAsync();
List <Customer> customers = new List <Customer>();
customers = await customersRepo.GetAllAsync();
foreach (var cust in customers)
{
Console.WriteLine($"Customer name: {cust.FirstName}");
}
Console.ReadLine();
}
private void CbxClass_SelectedIndexChanged(object sender, EventArgs e)
{
if (CbxClass.SelectedItem != null)
{
using (SampleDataContext db = new SampleDataContext())
{
schedule = db.HeaderSchedules.Where(s => s.ClassName == CbxClass.SelectedItem.ToString()).FirstOrDefault();
kelas = db.Classes.Where(c => c.ClassName == CbxClass.SelectedItem.ToString()).FirstOrDefault();
CbxSubject.Items.Clear();
GetSubject();
}
if (schedule.Finalize == 1)
{
va.DisableAllControls();
CbxClass.Enabled = true;
CbxDay.Enabled = true;
DGVSchedule.Enabled = true;
}
else if (schedule.Finalize == 0)
{
va.EnableAllControls();
BtnSave.Visible = false;
BtnCancel.Visible = false;
CbxShift.Enabled = false;
CbxTeacher.Enabled = false;
CbxSubject.Enabled = false;
}
}
}
private void GetClass()
{
using (SampleDataContext db = new SampleDataContext())
{
detail = db.DetailClasses.Where(dc => dc.StudentId == student.StudentId).FirstOrDefault();
}
}
private void RefreshDGV()
{
if (CbxClass.SelectedItem != null)
{
using (SampleDataContext db = new SampleDataContext())
{
if (schedule != null)
{
DGVSchedule.DataSource = from ds in db.DetailSchedules
join hs in db.HeaderSchedules
on ds.ScheduleId equals hs.ScheduleId
join s in db.Subjects
on ds.SubjectId equals s.SubjectId
join t in db.Teachers
on ds.TeacherId equals t.TeacherId
where (ds.ScheduleId == schedule.ScheduleId)
select new
{
s.SubjectId,
Subject = s.Name,
t.TeacherId,
Teacher_Name = t.Name,
ds.ShiftId,
ds.DetailId
};
DGVSchedule.Columns["DetailId"].Visible = false;
}
}
}
}
public ICollection <Product> GetAll()
{
using (var db = new SampleDataContext(_configuration))
{
var t = new ProductRepo(db);
return(t.GetProduts());
}
}
private void CbxClass_SelectedIndexChanged(object sender, EventArgs e)
{
using (SampleDataContext db = new SampleDataContext())
{
kelas = db.Classes.Where(c => c.ClassName == CbxClass.SelectedItem.ToString()).FirstOrDefault();
RefreshDGV();
}
}
private static void deleteItem(SampleDataContext context, int updateInput)
{
EntityList <SampleItem> samples = context.GetList <SampleItem>("Sample");
var itemToDelete = (from r in context.Sample where r.Id == updateInput select r).First();
samples.DeleteOnSubmit(itemToDelete);
context.SubmitChanges();
}
private void GetData()
{
SampleDataContext dbContex = new SampleDataContext();
dbContex.Log = Response.Output;
GridView1.DataSource = dbContex.GetEmployee();
GridView1.DataBind();
}
private void CbxSubject_SelectedIndexChanged(object sender, EventArgs e)
{
using (SampleDataContext db = new SampleDataContext())
{
string subject = GlobalUse.GetFirstString(CbxSubject.SelectedItem.ToString());
this.subject = db.Subjects.Where(s => s.SubjectId == subject).FirstOrDefault();
ShowPercentage();
}
}
private void DeleteFromDatabase()
{
using (SampleDataContext db = new SampleDataContext())
{
Database.Message message = db.Messages.Where(m => m.MessageId == selectedMessage.MessageId).FirstOrDefault();
db.Messages.DeleteOnSubmit(message);
db.SubmitChanges();
}
}
public static List <Course> FindCourseAPI(SampleDataContext context, string keyword)
{
return((from c in context.Courses
where
c.Name.Contains(keyword) ||
c.Teacher.FirstName.Contains(keyword) ||
c.Teacher.LastName.Contains(keyword)
select c).ToList());
}
private static void showListItems(SampleDataContext context)
{
//context is the site (in this case this would be the subsite, Raymond)
var res = from r in context.Sample select r;
foreach (var r in res)
{
Console.WriteLine(r.Id + ":" + r.FirstName + ":" + r.LastName);
}
}
static partial void PerformPreDeleteLogic(SampleDataContext context, Course obj)
{
if (obj.Enrollments != null)
{
foreach (DataAccess.Enrollment enrollment in obj.Enrollments)
{
EnrollmentLogic.DeleteEnrollment(context, enrollment.ID);
}
}
}
public void WorksheetNameAttribute()
{
using (var db = new SampleDataContext())
{
var data = db.Orders.OrderBy(x => x.Date).GroupBy(x => x.Date.Month);
var package = Spreadsheet.CreatePackage(data);
Assert.IsTrue(package.Workbook.Worksheets.Count > 1);
Assert.IsTrue(package.Workbook.Worksheets[package.Workbook.Worksheets.Count].Name == DateTime.Now.AddDays(-1).ToString("MMMM"));
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
int id = int.Parse(TextBox1.Text);
Employee employee = dbContext.Employees.SingleOrDefault(x => x.ID == id);
dbContext.Employees.DeleteOnSubmit(employee);
dbContext.SubmitChanges();
}
GetData();
}
protected void btnGetEmployeesByDepartment_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
string deptName = string.Empty;
GridView1.DataSource = dbContext.GetEmployeesByDepartment(DropDownList1.SelectedIndex+1, ref deptName);
GridView1.DataBind();
lblDept.Text = "Department Name = " + deptName;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
int id = int.Parse(TextBox2.Text);
Employee employee = dbContext.Employees.SingleOrDefault(x => x.ID == id);
employee.Salary += employee.Salary*10/100;
dbContext.SubmitChanges();
}
GetData();
}
private void UpdateToDatabase()
{
using (SampleDataContext db = new SampleDataContext())
{
DetailScore detail = db.DetailScores.Where(ds => ds.ScoreDetailId == score.ScoreDetailId).FirstOrDefault();
detail.Assignment = Convert.ToInt32(TbxAssignment.Text);
detail.MidExam = Convert.ToInt32(TbxMidExam.Text);
detail.FinalExam = Convert.ToInt32(TbxFinalExam.Text);
db.SubmitChanges();
}
}
protected void btnAddDept_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Department newDepartment = new Department
{
Name = txtDeptName.Text,
Location = txtDeptLoc.Text
};
dbContext.Departments.InsertOnSubmit(newDepartment);
dbContext.SubmitChanges();
}
Response.Redirect("WebForm3.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee newEmployee = new Employee
{
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
Gender = txtGender.Text,
Salary = int.Parse(txtSalary.Text),
DepartmentId = int.Parse(txtDeptId.Text)
};
dbContext.Employees.InsertOnSubmit(newEmployee);
dbContext.SubmitChanges();
}
Response.Redirect("WebForm2.aspx");
}
private void GetData()
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource = dbContext.GetEmployees();
GridView1.DataBind();
}
