void DeleteRowButtonClick(object sender, EventArgs e) { ImageButton button = (ImageButton)sender; { SaveChanges(); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); var userIdParam = Session["UserID"]; int userId = Convert.ToInt32(userIdParam); var applicationId = Session["ApplicationID"]; int appid = Convert.ToInt32(applicationId); int partnerid = Convert.ToInt32(button.CommandArgument); zPartnersTable currentPartner = (from a in competitionDataBase.zPartnersTable where a.Active == true && a.ID == partnerid join b in competitionDataBase.zApplicationAndPartnersMappingTable on a.ID equals b.FK_PartnersTable where b.Active == true && b.FK_Application == appid select a).FirstOrDefault(); currentPartner.Active = false; competitionDataBase.SubmitChanges(); zApplicationAndPartnersMappingTable currentLink = (from a in competitionDataBase.zApplicationAndPartnersMappingTable where a.Active == true && a.FK_PartnersTable == partnerid && a.FK_Application == appid select a).FirstOrDefault(); currentLink.Active = false; competitionDataBase.SubmitChanges(); Response.Redirect("ChooseApplicationAction.aspx"); } }
protected void AddRowButton_Click(object sender, EventArgs e) { SaveChanges(); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); var userIdParam = Session["UserID"]; int userId = Convert.ToInt32(userIdParam); var applicationId = Session["ApplicationID"]; int appid = Convert.ToInt32(applicationId); zPartnersTable newPartner = new zPartnersTable(); newPartner.Active = true; newPartner.Role = false; competitionDataBase.zPartnersTable.InsertOnSubmit(newPartner); competitionDataBase.SubmitChanges(); zApplicationAndPartnersMappingTable newLink = new zApplicationAndPartnersMappingTable(); newLink.Active = true; newLink.FK_Application = appid; newLink.FK_PartnersTable = newPartner.ID; competitionDataBase.zApplicationAndPartnersMappingTable.InsertOnSubmit(newLink); competitionDataBase.SubmitChanges(); Response.Redirect("ChooseApplicationAction.aspx"); }
public void SaveChanges() { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); foreach (GridViewRow currentRow in PartnersGV.Rows) { Label partnerID = (Label)currentRow.FindControl("ID"); TextBox surname = (TextBox)currentRow.FindControl("Surname"); TextBox name = (TextBox)currentRow.FindControl("Name"); TextBox patronymic = (TextBox)currentRow.FindControl("Patronymic"); CheckBox role = (CheckBox)currentRow.FindControl("Role"); if (partnerID != null) { zPartnersTable currentpartner = (from a in competitionDataBase.zPartnersTable where a.ID == Convert.ToInt32(partnerID.Text) select a).FirstOrDefault(); if (currentpartner != null) { if (surname.Text.Any() && name.Text.Any() && patronymic.Text.Any()) { currentpartner.Surname = surname.Text; currentpartner.Name = name.Text; currentpartner.Patronymic = patronymic.Text; currentpartner.Role = role.Checked; competitionDataBase.SubmitChanges(); } } } } }
public bool IsApplicationReadyToSend(int applicationId) { List <zBlockTable> blockList = (from a in _competitionDataBase.zBlockTable where a.Active == true select a).ToList(); zApplicationTable currentApplication = (from a in _competitionDataBase.zApplicationTable where a.ID == applicationId && a.Active == true select a).FirstOrDefault(); if (currentApplication == null) { return(false); } if (currentApplication.StartProjectDate == null) { return(false); } if (currentApplication.EndProjectDate == null) { return(false); } List <zPartnersTable> one = (from a in _competitionDataBase.zPartnersTable where a.Active == true && a.Role == true select a).ToList(); zPartnersTable currentone = (from a in _competitionDataBase.zPartnersTable where a.Active == true && a.Role == true join b in _competitionDataBase.zApplicationAndPartnersMappingTable on a.ID equals b.FK_PartnersTable where b.Active == true && b.FK_Application == Convert.ToInt32(currentApplication.ID) select a).FirstOrDefault(); if (one != null && currentone != null) { List <int> lider = (from a in one where a.Name == currentone.Name && a.Surname == currentone.Surname && a.Patronymic == currentone.Patronymic select a.ID).ToList(); if (lider.Count > 1) { return(false); } } List <zPartnersTable> two = (from a in _competitionDataBase.zPartnersTable where a.Active == true && a.Role == false select a).ToList(); zPartnersTable currenttwo = (from a in _competitionDataBase.zPartnersTable where a.Active == true && a.Role == false join b in _competitionDataBase.zApplicationAndPartnersMappingTable on a.ID equals b.FK_PartnersTable where b.Active == true && b.FK_Application == Convert.ToInt32(currentApplication.ID) select a).FirstOrDefault(); if (two != null && currenttwo != null) { List <int> teamuser = (from a in two where a.Name == currenttwo.Name && a.Surname == currenttwo.Surname && a.Patronymic == currenttwo.Patronymic select a.ID).ToList(); if (teamuser.Count >= 2) { return(false); } } foreach (zBlockTable block in blockList) { if (GetStatusIdForBlockInApplication(block.ID, applicationId) != statusAllData) { return(false); } } return(true); }
protected void PartnersGV_RowDataBound(object sender, GridViewRowEventArgs e) { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); var userIdParam = Session["UserID"]; int userId = Convert.ToInt32(userIdParam); var applicationId = Session["ApplicationID"]; int appid = Convert.ToInt32(applicationId); Label idLabel = (Label)e.Row.FindControl("ID"); if (idLabel != null) { Label error1 = (Label)e.Row.FindControl("Error1"); Label error2 = (Label)e.Row.FindControl("Error2"); List <zPartnersTable> one = (from a in competitionDataBase.zPartnersTable where a.Active == true && a.Role == true select a).ToList(); zPartnersTable currentone = (from a in competitionDataBase.zPartnersTable where a.Active == true && a.Role == true && a.ID == Convert.ToInt32(idLabel.Text) select a).FirstOrDefault(); if (one != null && currentone != null) { List <int> lider = (from a in one where a.Name == currentone.Name && a.Surname == currentone.Surname && a.Patronymic == currentone.Patronymic select a.ID).ToList(); if (lider.Count > 1) { error1.Visible = true; } else { error1.Visible = false; } } List <zPartnersTable> two = (from a in competitionDataBase.zPartnersTable where a.Active == true && a.Role == false select a).ToList(); zPartnersTable currenttwo = (from a in competitionDataBase.zPartnersTable where a.Active == true && a.Role == false && a.ID == Convert.ToInt32(idLabel.Text) select a).FirstOrDefault(); if (two != null && currenttwo != null) { List <int> teamuser = (from a in two where a.Name == currenttwo.Name && a.Surname == currenttwo.Surname && a.Patronymic == currenttwo.Patronymic select a.ID).ToList(); if (teamuser.Count >= 2) { error2.Visible = true; } else { error2.Visible = false; } } } }