private void Btn_update_Click(object sender, EventArgs e)
{
Site site = new Site();
Staff_Allocated_Site staff_Allocated_Site = new Staff_Allocated_Site();
site.site_id = _site_id;
site.title = _title;
site.address = _address;
site.description = _description;
site.estimated_cost = float.Parse(_estimated_cost.ToString());
site.start_date = Convert.ToDateTime(_start_date);
site.deadline = Convert.ToDateTime(_end_date);
staff_Allocated_Site.staff_allocated_site_id = _staff_allocated_site_id;
staff_Allocated_Site.site_id = _site_id;
staff_Allocated_Site.staff_id = _supervisor_id;
staff_Allocated_Site.end_date = Convert.ToDateTime(_end_date);
DataExchanger.site = site;
DataExchanger.staff_Allocated_Site = staff_Allocated_Site;
Form_Update_Site form_Update_Site = new Form_Update_Site();
form_Update_Site.Show();
}
private void AddToTheContainer(List <Site> siteList)
{
foreach (Site site in siteList)
{
UserControl_Site_Item siteItem = new UserControl_Site_Item();
siteItem.SiteId = site.site_id;
siteItem.Title = site.title;
siteItem.Description = site.description;
siteItem.Address = site.address;
siteItem.StartDate = Convert.ToDateTime(site.start_date).ToString("yyyy-MM-dd");
siteItem.EndDate = Convert.ToDateTime(site.deadline).ToString("yyyy-MM-dd");
siteItem.EstimatedCost = site.estimated_cost.ToString();
siteItem.Supervisor = "0";
using (NCOMSEntities db = new NCOMSEntities())
{
Staff_Allocated_Site staff_Allocated_Site = db.Staff_Allocated_Site.Where(s => s.site_id == site.site_id).FirstOrDefault();
Staff supervisor = db.Staffs.Where(s => s.staff_id == staff_Allocated_Site.staff_id).FirstOrDefault();
siteItem.Supervisor = supervisor.first_name + " " + supervisor.last_name;
siteItem.StaffAllocatedSiteId = staff_Allocated_Site.staff_allocated_site_id;
siteItem.SupervisorId = supervisor.staff_id;
}
siteTitles.Add(site.title);
int totalDays = Convert.ToDateTime(site.deadline).Subtract(Convert.ToDateTime(site.start_date)).Days;
int pasedDays = Convert.ToDateTime(site.deadline).Subtract(DateTime.Today).Days;
int percentage;
if (pasedDays <= 0)
{
percentage = 100;
}
else if (Convert.ToDateTime(site.start_date).Subtract(DateTime.Today).Days >= 0)
{
percentage = 0;
}
else
{
percentage = 100 - (Convert.ToInt32(((pasedDays / (double)totalDays) * 100)));
}
siteItem.TimeLine = percentage;
flp_site_item_container.Controls.Add(siteItem);
}
}
private void AddToTheContainer(List <Money_Request> moneyRequestList)
{
foreach (Money_Request moneyRequest in moneyRequestList)
{
UserControl_MoneyRequest_Item_D1 moneyRequestItem = new UserControl_MoneyRequest_Item_D1();
using (NCOMSEntities db = new NCOMSEntities())
{
moneyRequestItem.SiteTitle = db.Sites.Where(m => m.site_id == moneyRequest.site_id).FirstOrDefault().title.ToString();
Staff_Allocated_Site staff_Allocated_Site = db.Staff_Allocated_Site.Where(m => m.site_id == moneyRequest.site_id).FirstOrDefault();
Staff supervisor = db.Staffs.Where(m => m.staff_id == staff_Allocated_Site.staff_id).FirstOrDefault();
moneyRequestItem.SupervisorName = supervisor.first_name + " " + supervisor.last_name;
}
moneyRequestItem.SiteId = moneyRequest.site_id;
moneyRequestItem.Amount = float.Parse(moneyRequest.amount.ToString());
moneyRequestItem.RequestedDate = Convert.ToDateTime(moneyRequest.requested_on).ToString("yyyy-MM-dd");
moneyRequestItem.RequestedTime = moneyRequest.requested_at.ToString();
moneyRequestItem.Description = moneyRequest.description;
moneyRequestItem.MoneyRequestId = moneyRequest.request_id;
flp_money_request_item_container.Controls.Add(moneyRequestItem);
}
}
