/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Check user credentials and retrieve records for UserDetails . /// </summary> #region Select_Records_CreateUserDetailsforlogin public List <UserDetails> UserDetailsSelectforLogin(string UserName, string Password) { objEmailCampDataContext = new EmailCampDataContext(); lstUserDetails = new List <UserDetails>(); var Select = (from cde in objEmailCampDataContext.spUserLogin_AllActions(null, null, null, null, UserName, null, null, null, null, null, null, null, UserName, null, null, null, null, null, null, null, null, null, null, null, null, null, null, Password, null, null, null, "p") select cde).ToList(); if (Select.Count > 0) { lstUserDetails = new List <UserDetails>(); foreach (var item in Select) { objUserDetails = new UserDetails(); objUserDetails.PK_UserID = item.PK_UserID; objUserDetails.FK_CompanyID = Convert.ToInt16(item.FK_CompanyID); objUserDetails.LastName = item.LastName; objUserDetails.FirstName = item.FirstName; objUserDetails.UserName = item.UserName; objUserDetails.UserType = Convert.ToInt16(item.UserType); objUserDetails.Addressline1 = item.addressline1; objUserDetails.City1 = item.city1; objUserDetails.State1 = item.state1; objUserDetails.Country1 = item.country1; objUserDetails.Designation = item.Designation; objUserDetails.DateOfBirth = item.DateOfBirth; objUserDetails.Email_id = item.email_id; objUserDetails.ContactNo = item.ContactNo; objUserDetails.AlternativeNo = item.AlternativeNo; objUserDetails.MemberSince = Convert.ToDateTime(item.MemberSince); objUserDetails.MemberTill = Convert.ToDateTime(item.MemberTill); objUserDetails.IsActive = item.IsActive; objUserDetails.CreatedBy = item.CreatedBy; objUserDetails.CreatedOn = item.CreatedOn; objUserDetails.UpdatedBy = item.UpdatedBy; objUserDetails.UpdatedOn = item.UpdatedOn; objUserDetails.ReportID = item.ReportID; objUserDetails.FK_RoleID = item.FK_RoleID; objUserDetails.TotalMailCount = item.TotalMailCount; objUserDetails.TotalContactsCount = item.TotalContactsCount; objUserDetails.FK_UserPlanID = item.FK_UserPlanID; objUserDetails.UserPassword = item.UserPassword; objUserDetails.UserPhoto = item.UserPhoto; objUserDetails.AccountActivated = Convert.ToBoolean(item.AccountActivated); objUserDetails.SendNewsLetter = Convert.ToBoolean(item.SendNewsLetter); lstUserDetails.Add(objUserDetails); } } objEmailCampDataContext = null; objUserDetails = null; return(lstUserDetails); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 7-4-2015 /// Comments :: Select maximum primary key records for User Login details. /// </summary> #region Get_UserLogin_MAx_ID public int UserLoginMaxID() { objEmailCampDataContext = new EmailCampDataContext(); var Select = (from cde in objEmailCampDataContext.spUserLogin_AllActions(null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "a") select cde).ToList(); int lastUserLogin = 0; if (Select.Count > 0) { lastUserLogin = Convert.ToInt16(Select.LastOrDefault().PK_UserID); } objEmailCampDataContext = null; Select = null; return(lastUserLogin); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Updation function of UserDetails details. /// </summary> #region Delete_UserDetailsCreation public void UserDetailsDelete(int UserDetailsid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spUserLogin_AllActions(UserDetailsid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objUserDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Updation function of UserDetails details. /// </summary> #region Update_UserDetailsCreation public void UserDetailsUpdate(UserDetails objUserDetails) { try { objEmailCampDataContext = new EmailCampDataContext(); var Update = (from cde in objEmailCampDataContext.spUserLogin_AllActions(objUserDetails.PK_UserID, objUserDetails.FK_CompanyID, objUserDetails.LastName, objUserDetails.FirstName, objUserDetails.UserName, objUserDetails.UserType, objUserDetails.Addressline1, objUserDetails.City1, objUserDetails.State1, objUserDetails.Country1, objUserDetails.Designation, objUserDetails.DateOfBirth, objUserDetails.Email_id, objUserDetails.ContactNo, objUserDetails.AlternativeNo, objUserDetails.MemberSince, objUserDetails.MemberTill, objUserDetails.IsActive, objUserDetails.CreatedBy, objUserDetails.CreatedOn, objUserDetails.UpdatedBy, objUserDetails.UpdatedOn, objUserDetails.ReportID, objUserDetails.FK_RoleID, objUserDetails.TotalMailCount, objUserDetails.TotalContactsCount, objUserDetails.FK_UserPlanID, objUserDetails.UserPassword, objUserDetails.UserPhoto, objUserDetails.AccountActivated, objUserDetails.SendNewsLetter, "u") select cde).ToList(); Update = null; objUserDetails = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 10-4-2015 /// Comments :: Verify User FileName Exist. /// </summary> #region Select_Records_VerifyUserFileNameExist public int VerifyUserFileNameExist(string FileName) { int status = 0; objEmailCampDataContext = new EmailCampDataContext(); var Select = (from cde in objEmailCampDataContext.spUserLogin_AllActions(null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, FileName, null, null, "t") select cde).ToList(); if (Select.Count > 0) { status = 1; } Select = null; objEmailCampDataContext = null; return(status); }