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
}
}
