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 Reset_Password(string LoginId, string Pwd)
{
try
{
U_USR_LgnDAL odal = new U_USR_LgnDAL();
return(odal.ResetPassword(LoginId, Pwd).ToString());
}
catch
{
return("");
}
}
public string CheckUserId(string EmailId)
{
try
{
U_USR_LgnDAL odal = new U_USR_LgnDAL();
return(odal.CheckEmail_Exist(EmailId));
}
catch
{
return("");
}
}
public string ChangePassword(ProfileSecurity obj)
{
try
{
U_USR_LgnDAL odal = new U_USR_LgnDAL();
return(Convert.ToString(odal.ChangePassword(obj.Usr_Id, obj.New_Password, obj.Old_Password)));
}
catch
{
return("");
}
}
public string ActivateMember(string member_id)
{
try
{
U_USR_LgnDAL olgnDAL = new U_USR_LgnDAL();
olgnDAL.ActivateMember(member_id);
return("1");
}
catch
{
return("0");
}
}
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 U_ADMIN_Login_Ref getLoginValidate(U_USR_Lgn Newlogin)
{
U_USR_LgnDAL obj = new U_USR_LgnDAL();
return(obj.GetLoginDetails(Newlogin.Email_ID, Newlogin.Pwd));
}
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 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
}
}
public Login GetMemberDetails(string EmailId, string password)
{
U_USR_LgnDAL olgnDAL = new U_USR_LgnDAL();
return(olgnDAL.GetLoginDetails(EmailId, password));
}
