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); } }