public int InsertmRoute(mRoute rut, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mRoutes.AddObject(rut);
ce.SaveChanges();
return(1);
}
public int UpdatemRoute(mRoute updaterut, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mRoutes.Attach(updaterut);
ce.ObjectStateManager.ChangeObjectState(updaterut, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetRouteList is providing List of Route
/// </summary>
/// <returns></returns>
///
public mRoute GetRouteListByID(int RouteId, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mRoute RouteList = new mRoute();
RouteList = (from p in ce.mRoutes
where p.ID == RouteId
select p).FirstOrDefault();
ce.Detach(RouteList);
return(RouteList);
}