//public void InsertFichier(UtilisateurDB fichier)
//{
// using (DataAccesDataContext dbContext = new DataAccesDataContext())
// {
// Utilisateur newfichier = new Utilisateur
// {
// ContentType = fichier.ContentType,
// Data = fichier.Data,
// Name = fichier.Name,
// code_service = fichier.code_service
// };
// dbContext.fichierService.InsertOnSubmit(newfichier);
// dbContext.SubmitChanges();
// }
//}
public List <destinationDB> GetDestination()
{
try
{
DataAccesDataContext dbContext = new DataAccesDataContext();
destinationDB ls = new destinationDB();
var pm = (from c in dbContext.destination
join d in dbContext.profil on c.LibelleDest.ToString().Trim() equals d.description_profil.ToString().Trim()
select new destinationDB
{
codeDest = c.code_dest,
libelleDest = c.LibelleDest,
codeProfil = d.code_profil,
descriptionProfil = d.description_profil
});
return(pm.ToList());
}
catch (Exception ex)
{
string msg = ex.Message;
return(null);
}
}
protected void gv_Reclamation_SelectedIndexChanged(object sender, EventArgs e)
{
Btnsave.Visible = false;
AstreeDonnees a = new AstreeDonnees();
GridViewRow row = gv_Reclamation.SelectedRow;
serviceDB serv = a.GetServices().Where(w => w.code_service == Convert.ToInt32(row.Cells[1].Text)).FirstOrDefault();
UtilisateurDB user = a.GetUser(Convert.ToInt16(serv.codeUtilisateur));
TxtCode.Text = serv.codeUtilisateur.ToString();
List <destinationDB> lstDestination = a.GetDestination();
destinationDB dest = lstDestination.Where(w => w.codeDest == Convert.ToInt16(row.Cells[5].Text.Trim())).FirstOrDefault();
if (dest != null)
{
ddlDest.SelectedItem.Text = dest.libelleDest;
}
TxtCommentaire.Text = row.Cells[4].Text.Trim();
notificationDB notif = a.GetNotification().Where(w => w.codeService == serv.code_service).FirstOrDefault();
if (notif != null)
{
if (notif.etatNotif == "N")
{
notif.etatNotif = "L";
a.maj_notification(notif);
row.ForeColor = System.Drawing.Color.Black;
Label x = (Label)Master.FindControl("lblNotifReclamation") as Label;
List <serviceDB> lsNotification = a.GetServices().Where(w => (w.libelleService != null) && (w.etatNotif.Trim() == "N") && (w.codeUtilisateur == Convert.ToInt16(Session["code_utilisateur"]))).ToList();
x.Text = lsNotification.Where(w => w.libelleService.Trim() == "Reclamation").Count().ToString();
Label nbNotification = (Label)Master.FindControl("nbNotification") as Label;
nbNotification.Text = (Convert.ToInt16(nbNotification.Text) - 1).ToString();
}
}
BindGrid();
}
private void BindGrid()
{
AstreeDonnees a = new AstreeDonnees();
List <serviceDB> ls = a.GetServices().Where(w => w.libelleService.Trim() == "Reclamation" && w.codeUtilisateur == Convert.ToInt16(Session["Code_utilisateur"])).OrderBy(w => w.etat).ThenByDescending(w => w.code_service).ToList();
List <destinationDB> lstDestination = a.GetDestination();
foreach (serviceDB serv in ls)
{
destinationDB dest = lstDestination.Where(w => w.codeDest == serv.codeDest).FirstOrDefault();
if (dest != null)
{
serv.libelleDest = dest.libelleDest;
}
}
List <serviceDB> lsFin = ls.OrderBy(w => w.etat.Trim()).ThenByDescending(w => w.etatNotif).ThenByDescending(w => w.dateReponse).ToList();
Session["lstReclamation"] = lsFin;
gv_Reclamation.DataSource = lsFin;
gv_Reclamation.DataBind();
}
