public Admin_Members[] GetMembersDetails() { U_USR_MASTERDAL obj1 = new U_USR_MASTERDAL(); var data = obj1.GetMembersDetailsDb(); return(data); }
public A_USR_MASTER_V2 GetSingleMemberDetails(string id) { U_USR_MASTERDAL obj = new U_USR_MASTERDAL(); A_USR_MASTER_V2 data = obj.GetSingleMemberDetailsDb(id); return(data); }
public MemberContacts[] GetMemberContacts(string Id) { U_USR_MASTERDAL UsrDAL = new U_USR_MASTERDAL(); MemberContacts[] data = UsrDAL.GetMemberContactsDb(Id); return(data); }
public bool UpdateMember(A_USR_MASTER_V2 Memb) { U_USR_MASTERDAL UsrDAL = new U_USR_MASTERDAL(); A_USR_MASTER_V2 OldData = GetSingleMemberDetails(Memb.Uid); U_USR_MASTER NewData = new U_USR_MASTER(); //Memb.Updated_By = "22"; //Memb.Dob = OldData.Dob; //Memb.WedAnvrsry = OldData.WedAnvrsry; NewData.Usr_Id = Memb.Uid; NewData.First_Name = string.IsNullOrEmpty(Memb.FirstName) ? OldData.FirstName : Memb.FirstName; NewData.Last_Name = string.IsNullOrEmpty(Memb.LastName) ? OldData.LastName : Memb.LastName; NewData.Alt_Email_Id = string.IsNullOrEmpty(Memb.EmailId) ? OldData.EmailId : Memb.EmailId; NewData.Gender = string.IsNullOrEmpty(Memb.Gender) ? OldData.Gender : Memb.Gender; NewData.Date_Of_Birth = Memb.Dob; NewData.About_member = ""; NewData.Is_married = string.IsNullOrEmpty(Convert.ToString(Memb.IsMarried)) ? OldData.IsMarried : Memb.IsMarried; NewData.Wed_anniversary = Memb.WedAnvrsry; NewData.Rating = "5"; NewData.Address_Id = 1; NewData.Usr_role_Id = "3"; NewData.Media_Id_Img = "1"; NewData.Updated_by = Memb.Updated_By; NewData.Created_by = Memb.Updated_By; //NewData.Created_Date = OldData.Create_Date; NewData.Updated_Date = DateTime.Now; NewData.Created_Date = DateTime.Now; return(UsrDAL.Update_UserProfile(NewData)); }
public bool InsertSubAdmin(A_ModelGroupsList SubAdmin) { U_USR_MASTERDAL obj = new U_USR_MASTERDAL(); U_USR_LgnDAL obj1 = new U_USR_LgnDAL(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); DateTime now = System.DateTime.Now; imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = SubAdmin.MasterData.Media_Id_Img; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = SubAdmin.MasterData.Created_by; imgData.Updated_by = SubAdmin.MasterData.Updated_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); SubAdmin.MasterData.Usr_Id = System.Guid.NewGuid().ToString(); SubAdmin.MasterData.Address_Id = 1; SubAdmin.MasterData.Media_Id_Img = imgData.Media_Id; SubAdmin.MasterData.Created_Date = DateTime.Now; SubAdmin.MasterData.Updated_Date = DateTime.Now; SubAdmin.MasterData.Alt_Email_Id = SubAdmin.LoginData.Email_ID; SubAdmin.MasterData.Gender = SubAdmin.MasterData.Gender; SubAdmin.MasterData.About_member = ""; SubAdmin.MasterData.Rating = "1"; SubAdmin.LoginData.Login_Id = System.Guid.NewGuid().ToString(); SubAdmin.LoginData.Usr_Mst_Id = SubAdmin.MasterData.Usr_Id; SubAdmin.LoginData.Updated_Date = DateTime.Now; SubAdmin.LoginData.Last_Login_Date = DateTime.Now; SubAdmin.LoginData.Created_Date = DateTime.Now; SubAdmin.LoginData.Ip_Address = ""; SubAdmin.LoginData.Login_status = 1; SubAdmin.LoginData.Created_by = SubAdmin.MasterData.Created_by; SubAdmin.LoginData.Updated_by = SubAdmin.MasterData.Updated_by; SubAdmin.MasterData.Date_Of_Birth = DateTime.Now; SubAdmin.MasterData.Wed_anniversary = DateTime.Now; if (obj.InsertU_USR_MASTER(SubAdmin.MasterData)) { if (obj1.InsertU_USR_Lgn(SubAdmin.LoginData)) { return(true); } } return(false); }
public string UpdateProfile(Profile odetails) { try { string mediaId = string.Empty; var userprofile = GetUserProfile(odetails.Usr_Id); if (!string.IsNullOrEmpty(odetails.Media_Id_Img)) { mediaId = Guid.NewGuid().ToString(); U_ADM_MEDIA_MASTERDAL omediaDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER omaster = new U_ADM_MEDIA_MASTER(); omaster.Media_Id = mediaId; omaster.Media_Oth_Dtl = ""; omaster.Media_Source = ""; omaster.Media_Type = "Image"; omaster.Updated_by = odetails.Usr_Id; omaster.Updated_Date = DateTime.Now; omaster.Created_by = odetails.Usr_Id; omaster.Created_Date = DateTime.Now; omaster.Media_File_Location = odetails.Media_Id_Img; omediaDAL.InsertU_ADM_MEDIA_MASTER(omaster); } U_USR_MASTERDAL ousrDAL = new U_USR_MASTERDAL(); U_USR_MASTER ousr = new U_USR_MASTER(); ousr.Usr_Id = odetails.Usr_Id; ousr.About_member = string.IsNullOrEmpty(odetails.About_member)?userprofile.About_member:odetails.About_member; ousr.First_Name = string.IsNullOrEmpty(odetails.First_Name)?userprofile.First_Name:odetails.First_Name; ousr.Last_Name = string.IsNullOrEmpty(odetails.Last_Name)?userprofile.Last_Name:odetails.Last_Name; ousr.Gender = string.IsNullOrEmpty(odetails.Gender)?userprofile.Gender:odetails.Gender; ousr.Is_married = odetails.Is_married; ousr.Wed_anniversary = string.IsNullOrEmpty(Convert.ToString(odetails.Wed_anniversary))?userprofile.Wed_anniversary:odetails.Wed_anniversary; ousr.Updated_by = odetails.Usr_Id; ousr.Updated_Date = DateTime.Now; ousr.Date_Of_Birth = string.IsNullOrEmpty(Convert.ToString(odetails.Date_Of_Birth))?DateTime.Now:odetails.Date_Of_Birth; ousr.Created_Date = DateTime.Now; ousr.Alt_Email_Id = string.IsNullOrEmpty(odetails.Alt_Email_Id)?userprofile.Alt_Email_Id:odetails.Alt_Email_Id; ousr.Address_Id = string.IsNullOrEmpty(odetails.Address_Id)?userprofile.Address_Id:odetails.Address_Id; ousr.Media_Id_Img = string.IsNullOrEmpty(mediaId)?userprofile.Extn:mediaId; ousrDAL.Update_UserProfile(ousr); return("1"); } catch { return("0"); // 0 indicates unsuccessfull } }
public DashboardMember[] GetRecent5Membors() { U_USR_MASTERDAL memDAL = new U_USR_MASTERDAL(); return(memDAL.GetRecent5MemborsDb()); }
public string GetMembersCount() { U_USR_MASTERDAL memDAL = new U_USR_MASTERDAL(); return(memDAL.GetMembersCountDb()); }
public bool GetUpdateSubAdmin(SubAdmin usr) { U_USR_MASTERDAL userDAL = new U_USR_MASTERDAL(); U_USR_LgnDAL logDAL = new U_USR_LgnDAL(); SubAdmin NewData = new SubAdmin(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); U_USR_MASTER NewData1 = new U_USR_MASTER(); var OldData = userDAL.GetSingleSubAdminDetailsDb(usr.Usr_Id); if (!(string.IsNullOrEmpty(usr.Media_File_Location))) { imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = usr.Media_File_Location; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = usr.Created_by; imgData.Updated_by = usr.Updated_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); NewData.Media_File_Location = imgData.Media_Id; } else { NewData.Media_File_Location = userDAL.GetMemberMediaIdDb(usr.Usr_Id); } NewData.Usr_Id = usr.Usr_Id; NewData.First_Name = string.IsNullOrEmpty(usr.First_Name) ? OldData.First_Name : usr.First_Name; NewData.Last_Name = string.IsNullOrEmpty(usr.Last_Name) ? OldData.Last_Name : usr.Last_Name; NewData.Alt_Email_Id = string.IsNullOrEmpty(usr.Alt_Email_Id) ? OldData.Alt_Email_Id : usr.Alt_Email_Id; NewData.Gender = string.IsNullOrEmpty(usr.Gender) ? OldData.Gender : usr.Gender; NewData.Usr_role_Id = string.IsNullOrEmpty(Convert.ToString(usr.Usr_role_Id)) ? OldData.Usr_role_Id : usr.Usr_role_Id; NewData.Mobile_Number = string.IsNullOrEmpty(usr.Mobile_Number) ? OldData.Mobile_Number : usr.Mobile_Number; NewData.Login_status = string.IsNullOrEmpty(Convert.ToString(usr.Login_status)) ? OldData.Login_status : usr.Login_status; NewData.Created_Date = OldData.Created_Date; NewData.Updated_Date = DateTime.Now; NewData.Created_by = OldData.Created_by; NewData.Updated_by = string.IsNullOrEmpty(usr.Updated_by) ? OldData.Updated_by : usr.Updated_by; NewData1.Usr_Id = NewData.Usr_Id; NewData1.First_Name = NewData.First_Name; NewData1.Last_Name = NewData.Last_Name; NewData1.Gender = NewData.Gender; NewData1.Usr_role_Id = NewData.Usr_role_Id; NewData1.Media_Id_Img = NewData.Media_File_Location; NewData1.Updated_Date = NewData.Updated_Date; NewData1.Updated_by = NewData.Updated_by; NewData1.Date_Of_Birth = DateTime.Now; NewData1.Wed_anniversary = DateTime.Now; NewData1.Created_Date = DateTime.Now; bool status = logDAL.UpdateMobileStatusDb(NewData.Usr_Id, NewData.Mobile_Number, NewData.Login_status, NewData.Updated_Date, NewData.Updated_by); status = userDAL.Update_SubAdminProfileDb(NewData1); return(true); }
public SubAdmin GetSingleSubAdminDetails(string Id) { U_USR_MASTERDAL userDAL = new U_USR_MASTERDAL(); return(userDAL.GetSingleSubAdminDetailsDb(Id)); }
public bool GetUnblockThisUser(string Id) { U_USR_MASTERDAL obj = new U_USR_MASTERDAL(); return(obj.GetUnblockThisUserDb(Id)); }
public Login AddMembers_ThirdParty(SocialRegistration obj) { try { U_USR_LgnDAL ologonDAL = new U_USR_LgnDAL(); U_USR_MASTERDAL oMstDAL = new U_USR_MASTERDAL(); U_USR_Lgn Lgnobj = new U_USR_Lgn(); U_USR_MASTER Mstobj = new U_USR_MASTER(); string user_id = ologonDAL.CheckLoginId_Exist(obj.Id); if (string.IsNullOrEmpty(user_id)) { Mstobj.Usr_Id = Guid.NewGuid().ToString(); Mstobj.Usr_role_Id = ""; Mstobj.Date_Of_Birth = DateTime.Now; Mstobj.First_Name = obj.First_Name; Mstobj.Alt_Email_Id = string.Empty; Mstobj.Gender = string.Empty; Mstobj.Is_married = 0; Mstobj.Last_Name = string.Empty; Mstobj.Media_Id_Img = "1"; Mstobj.Address_Id = "1"; Mstobj.Rating = string.Empty; Mstobj.Updated_by = string.Empty; Mstobj.Updated_Date = DateTime.Now; Mstobj.Wed_anniversary = DateTime.Now; Mstobj.About_member = string.Empty; Mstobj.Created_by = string.Empty; Mstobj.Created_Date = DateTime.Now; var status = oMstDAL.InsertU_USR_MASTER(Mstobj); if (status) { Lgnobj.Login_Id = obj.Id; Lgnobj.Login_status = 2; Lgnobj.Email_ID = obj.Email_Id; Lgnobj.Mobile_Number = obj.Phone_No; Lgnobj.Pwd = string.Empty; Lgnobj.Created_by = string.Empty; Lgnobj.Updated_by = string.Empty; Lgnobj.Updated_Date = DateTime.Now; Lgnobj.Created_Date = DateTime.Now; Lgnobj.Last_Login_Date = DateTime.Now; Lgnobj.Ip_Address = string.Empty; Lgnobj.Usr_Mst_Id = Mstobj.Usr_Id; status = ologonDAL.InsertU_USR_Lgn(Lgnobj); } if (status == true) { Login ologin = new Login(); user_id = ologonDAL.CheckLoginId_Exist(obj.Id); ologin.First_Name = obj.First_Name; ologin.Id = user_id; return(ologin); } else { return(null); // indicates unsuccessfull } } else { Login ologin = new Login(); ologin.First_Name = obj.First_Name; ologin.Id = user_id; return(ologin); // indicates LoginId already exists } } catch { return(null); // indicates unsuccessfull } }
public Profile GetUserProfile(string UserId) { U_USR_MASTERDAL odal = new U_USR_MASTERDAL(); return(odal.Select_UserProfile(UserId)); }
public string AddMembers(Registration obj) { try { U_USR_LgnDAL ologonDAL = new U_USR_LgnDAL(); U_USR_MASTERDAL oMstDAL = new U_USR_MASTERDAL(); U_USR_Lgn Lgnobj = new U_USR_Lgn(); U_USR_MASTER Mstobj = new U_USR_MASTER(); if (string.IsNullOrEmpty(ologonDAL.CheckEmail_Exist(obj.Email_Id))) { Mstobj.Usr_Id = Guid.NewGuid().ToString(); Mstobj.Usr_role_Id = ""; Mstobj.Date_Of_Birth = DateTime.Now; Mstobj.First_Name = obj.First_Name; Mstobj.Alt_Email_Id = string.Empty; Mstobj.Gender = string.Empty; Mstobj.Is_married = 0; Mstobj.Last_Name = string.Empty; Mstobj.Media_Id_Img = "1"; Mstobj.Address_Id = "1"; Mstobj.Rating = string.Empty; Mstobj.Updated_by = string.Empty; Mstobj.Updated_Date = DateTime.Now; Mstobj.Wed_anniversary = DateTime.Now; Mstobj.About_member = string.Empty; Mstobj.Created_by = string.Empty; Mstobj.Created_Date = DateTime.Now; var status = oMstDAL.InsertU_USR_MASTER(Mstobj); if (status) { Lgnobj.Login_Id = Guid.NewGuid().ToString(); Lgnobj.Login_status = 0; Lgnobj.Email_ID = obj.Email_Id; Lgnobj.Mobile_Number = obj.Phone_No; Lgnobj.Pwd = obj.Password; Lgnobj.Created_by = string.Empty; Lgnobj.Updated_by = string.Empty; Lgnobj.Updated_Date = DateTime.Now; Lgnobj.Created_Date = DateTime.Now; Lgnobj.Last_Login_Date = DateTime.Now; Lgnobj.Ip_Address = string.Empty; Lgnobj.Usr_Mst_Id = Mstobj.Usr_Id; status = ologonDAL.InsertU_USR_Lgn(Lgnobj); } if (status == true) { return("1"); } else { return("0"); // 0 indicates unsuccessfull } } else { return("2"); // 2 indicates email id already exists } } catch { return("0"); // 0 indicates unsuccessfull } }