/*public static IEnumerable<Entity> SelectPaged
(
int startRowIndex,
int maximumRows
)
{
return Select().Skip(startRowIndex).Take(maximumRows);
}*/
public static int Insert(Entity entityToInsert)
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
db.Entities.InsertOnSubmit(entityToInsert);
db.SubmitChanges();
return entityToInsert.Entity_ID;
}
public static IEnumerable<Volunteer> SelectVolunteerSchedule(DateTime dateSelected, string selectedShift)
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
var date = db.Shifts.Single(s => s.Shift_Date == dateSelected && s.Shift_Name == selectedShift);
var query = date.Volunteers;
return query;
}
public static void Delete(Entity entityToDelete)
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
db.Entities.Attach(entityToDelete);
db.Entities.DeleteOnSubmit(entityToDelete);
db.SubmitChanges();
}
public static int Insert(Shift shiftToInsert)
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
db.Shifts.InsertOnSubmit(shiftToInsert);
db.SubmitChanges();
return shiftToInsert.Shift_ID;
}
protected void Page_Load(object sender, EventArgs e)
{
// convert textbox entry to type int
int IDtxtbx;
IDtxtbx = Convert.ToInt32(textBox1.Text);
//int IDtxtbx = int.Parse(textBox1.Text);
// Create a gridview to display entity attributes to user to
// verify if this is the correct selection
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
Confirm_grdView.DataSource = db.Entities.Where(n => n.Entity_ID == (IDtxtbx));
Confirm_grdView.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
grdEntity.Visible = true;
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
grdEntity.DataSource = db.Entities.Where(n =>
n.Entity_Contact_LName == (lnameBox.Text) &&
n.Entity_Contact_FName == (fnameBox.Text)&&
n.Entity_Contact_MName == (middleIBox.Text));
grdEntity.DataBind();
}
}
protected void btnClient_Click(object sender, EventArgs e)
{
pnlBinaryField2.Visible = false;
pnlSelect.Visible = true;
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
var shiftID = db.Shifts.Where(s =>s.Shift_Name == rblSelectedLiteral.Text && s.Shift_Date == Calendar1.SelectedDate).Select(s => new {s.Shift_ID});
int shift_ID = int.Parse(shiftID.ToString());
byte CommuServ;
if (cbxCommServ.Checked)
{
CommuServ = 1;
}
else
{
CommuServ = 0;
}
byte isClient;
if (cbxClient.Checked)
{
isClient = 1;
}
else
{
isClient = 0;
}
/*System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();
//Convert to binary data
byte[] binaryData = encoding.GetBytes(CommuServ);*/
srcIndividual.InsertParameters["EntID"].DefaultValue = grdIndividual_Entity.SelectedValue.ToString();
srcIndividual.InsertParameters["ShiftID"].DefaultValue = shiftID.ToString();
//srcIndividual.InsertParameters["CommServ"].DefaultValue = CommuServ.ToString();
// Convert.ToByte(srcIndividual.InsertParameters["CommServ"].DefaultValue= CommuServ);
//srcIndividual.InsertParameters.Add("Client", SqlDbType.Binary);
// Convert.ToByte(srcIndividual.InsertParameters["Client"].DefaultValue = isClient);
srcIndividual.Insert();
grdSelect.Visible = true;
}
public static void Update(Entity oldEntity, Entity newEntity)
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
db.Entities.Attach(newEntity, oldEntity);
db.SubmitChanges();
}
public static IEnumerable<Entity> Select()
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
return db.Entities.OrderByDescending(e => e.Entity_ID);
}
public static IEnumerable<Shift> Select()
{
VolunteerDatabaseDataContext db = new VolunteerDatabaseDataContext();
return db.Shifts.OrderByDescending(s => s.Shift_ID);
}