protected void updateBtn_Click(object sender, EventArgs e)
{
int idContact = int.Parse(Request.QueryString["id"]);
using (EntityExeEntities context = new EntityExeEntities())
{
try
{
ObjectDataSource1.UpdateParameters["firstName"].DefaultValue = ((TextBox)contactDV.FindControl("firstNameETB")).Text;
ObjectDataSource1.UpdateParameters["Original_id"].DefaultValue = Request.QueryString["id"];
ObjectDataSource1.Update();
Contact_Service contact_Service = context.Contact_Service.FirstOrDefault(cs => cs.ContactsId == idContact);
if (contact_Service != null)
{
context.Contact_Service.Remove(contact_Service);
}
//Ajouter les données dans la table contact_service
setRowDataForGridCS();
DataTable csTable = (DataTable)ViewState["currentTableService"];
for (int i = 0; i < csTable.Rows.Count; i++)
{
Contact_Service cs = new Contact_Service();
cs.ContactsId = idContact;
cs.Tag_servicesId = Int32.Parse(csTable.Rows[i][0].ToString());
cs.ContactTypeId = Int32.Parse(csTable.Rows[i][1].ToString());
context.Contact_Service.Add(cs);
}
context.SaveChanges();
}
catch (Exception ex)
{
}
}
}
protected void contactODS_Updated(object sender, ObjectDataSourceStatusEventArgs e)
{
int idContact = int.Parse(Request.QueryString["id"]);
using (EntityExeEntities context = new EntityExeEntities())
{
try
{
Contact_Service contact_Service = context.Contact_Service.FirstOrDefault(cs => cs.ContactsId == idContact);
if (contact_Service != null)
{
context.Contact_Service.Remove(contact_Service);
}
//Ajouter les données dans la table contact_service
setRowDataForGridCS();
DataTable csTable = (DataTable)ViewState["currentTableService"];
for (int i = 0; i < csTable.Rows.Count; i++)
{
Contact_Service cs = new Contact_Service();
cs.ContactsId = idContact;
cs.Tag_servicesId = Int32.Parse(csTable.Rows[i][0].ToString());
cs.ContactTypeId = Int32.Parse(csTable.Rows[i][1].ToString());
context.Contact_Service.Add(cs);
}
context.SaveChanges();
GridView gv = (GridView)contactDV.FindControl("serviceGV");
ObjectDataSource ods = (ObjectDataSource)contactDV.FindControl("serviceODS");
//gv.DataSource = csTable;
//gv.DataBind();
}
catch (Exception ex)
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
EntityExeEntities entityExeEntities = new EntityExeEntities();
if (!Page.IsPostBack)
{
// ContactsTableAdapter
int id = Convert.ToInt32((Request["id"] ?? "1"));
List <Contact> ts = entityExeEntities.Contacts.Where(c => c.Id == id).ToList();
contactDV.DataSource = ts;
contactDV.DataBind();
rowForGridService("serviceGV", "ObjectDataSource2", "currentTableService", new string[] { "Tag_servicesId", "ContactTypeId" });
}
else
{
int id = Convert.ToInt32((Request["id"] ?? "1"));
List <Contact> ts = entityExeEntities.Contacts.Where(c => c.Id == id).ToList();
contactDV.DataSource = ts;
contactDV.DataBind();
}
}
