public static bool AddViewerProfilesDAL(ViewerProfileEntity newViewerProfile) { bool viewerProfileAdded = false; try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var ObjViewerProfile = new ViewerProfile(); ObjViewerProfile.FirstName = newViewerProfile.FirstName; ObjViewerProfile.LastName = newViewerProfile.LastName; ObjViewerProfile.MobileNo = newViewerProfile.MobileNo; ObjViewerProfile.EmailId = newViewerProfile.EmailId; ObjViewerProfile.UserName = newViewerProfile.UserName; ObjContext.ViewerProfiles.Add(ObjViewerProfile); int NoOfRowsAffected = ObjContext.SaveChanges(); if (NoOfRowsAffected > 0) { newViewerProfile.ViewersId = ObjViewerProfile.ViewersId; viewerProfileAdded = true; } else { viewerProfileAdded = false; } } catch (Exception ex) { throw new MovieExceptions(ex.Message); } return(viewerProfileAdded); }
//public static List<ViewerProfile> GetAllViewerProfilesDAL() //{ // List<ViewerProfile> ObjViewerProfileList = new List<ViewerProfile>(); // try // { // CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); // var Query = from ViewerProfile in ObjContext.ViewerProfiles // select ViewerProfile; // ViewerProfile ObjTempViewerProfile = null; // foreach (var obj in Query) // { // ObjTempViewerProfile = new ViewerProfile(); // ObjTempViewerProfile.ViewersId = obj.ViewersId; // ObjTempViewerProfile.FirstName = obj.FirstName; // ObjTempViewerProfile.LastName = obj.LastName; // ObjTempViewerProfile.MobileNo = obj.MobileNo; // ObjTempViewerProfile.EmailId = obj.EmailId; // ObjTempViewerProfile.UserName = obj.UserName; // ObjViewerProfileList.Add(ObjTempViewerProfile); // } // } // catch (Exception ex) // { // throw new MovieExceptions("Error : Reading data", ex); // } // return ObjViewerProfileList; //} //public static bool UpdateViewerProfileDAL(ViewerProfile updateViewerProfile) //{ // bool viewerProfileUpdated = false; // try // { // CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); // var ObjViewerProfile = ObjContext.ViewerProfiles.Find(updateViewerProfile.ViewersId); // if (ObjViewerProfile != null) // { // ObjViewerProfile.FirstName = updateViewerProfile.FirstName; // ObjViewerProfile.LastName = updateViewerProfile.LastName; // ObjViewerProfile.MobileNo = updateViewerProfile.MobileNo; // ObjViewerProfile.EmailId = updateViewerProfile.EmailId; // ObjViewerProfile.UserName = updateViewerProfile.UserName; // int NoOfRowsAffected = ObjContext.SaveChanges(); // viewerProfileUpdated = NoOfRowsAffected > 0; // } // else // { // viewerProfileUpdated = false; // } // } // catch (Exception ex) // { // throw new MovieExceptions(ex.Message); // } // return viewerProfileUpdated; //} public static ViewerProfileEntity SearchViewerProfileByUsernameDAL(string id) { ViewerProfileEntity searchViewerProfile = new ViewerProfileEntity(); try { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var query = from item in ObjContext.ViewerProfiles where item.UserName.Equals(id) select item; ViewerProfile profile = query.FirstOrDefault(); int Viewerid = profile.ViewersId; var ObjViewerProfile = ObjContext.ViewerProfiles.Find(Viewerid); if (ObjViewerProfile != null) { searchViewerProfile.ViewersId = ObjViewerProfile.ViewersId; searchViewerProfile.FirstName = ObjViewerProfile.FirstName; searchViewerProfile.LastName = ObjViewerProfile.LastName; searchViewerProfile.MobileNo = ObjViewerProfile.MobileNo; searchViewerProfile.EmailId = ObjViewerProfile.EmailId; searchViewerProfile.UserName = ObjViewerProfile.UserName; } } catch (Exception ex) { throw new MovieExceptions("Error : Reading searching data", ex); } return(searchViewerProfile); }