private SqlParameter[] GetParameters(U_USR_MASTER tobjU_USR_MASTER)
{
SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_USR_MASTER);
if (objParamArray == null)
{
//Represents a parameter to a System.Data.SqlClient.SqlCommand,
//and optionally, its mapping to System.Data.DataSet columns.
objParamArray = new SqlParameter[]
{
new SqlParameter(PARAM_Usr_Id, tobjU_USR_MASTER.Usr_Id),
new SqlParameter(PARAM_First_Name, tobjU_USR_MASTER.First_Name),
new SqlParameter(PARAM_Last_Name, tobjU_USR_MASTER.Last_Name),
new SqlParameter(PARAM_Alt_Email_Id, tobjU_USR_MASTER.Alt_Email_Id),
new SqlParameter(PARAM_Gender, tobjU_USR_MASTER.Gender),
new SqlParameter(PARAM_Date_Of_Birth, tobjU_USR_MASTER.Date_Of_Birth),
new SqlParameter(PARAM_About_member, tobjU_USR_MASTER.About_member),
new SqlParameter(PARAM_Is_married, tobjU_USR_MASTER.Is_married),
new SqlParameter(PARAM_Wed_anniversary, tobjU_USR_MASTER.Wed_anniversary),
new SqlParameter(PARAM_Rating, tobjU_USR_MASTER.Rating),
new SqlParameter(PARAM_Address_Id, tobjU_USR_MASTER.Address_Id),
new SqlParameter(PARAM_Usr_Profile_Id, tobjU_USR_MASTER.Usr_role_Id),
new SqlParameter(PARAM_Media_Id_Img, tobjU_USR_MASTER.Media_Id_Img),
new SqlParameter(PARAM_Created_Date, tobjU_USR_MASTER.Created_Date),
new SqlParameter(PARAM_Updated_Date, tobjU_USR_MASTER.Updated_Date),
new SqlParameter(PARAM_Created_by, tobjU_USR_MASTER.Created_by),
new SqlParameter(PARAM_Updated_by, tobjU_USR_MASTER.Updated_by),
};
SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_USR_MASTER, objParamArray);
}
return(objParamArray);
}
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 Update_SubAdminProfileDb(U_USR_MASTER subadmin)
{
SqlParameter[] aParms = GetParameters(subadmin);
SetParameters(aParms, subadmin);
using (SqlConnection conn = General.GetConnection())
{
bool status = false;
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_UPDATE_SubAdminProfile, aParms);
trans.Commit();
status = true;
}
catch (System.Exception e)
{
Console.Write(e);
trans.Rollback();
//log.Error(lobjError, e);
throw;
}
}
return(status);
}
}
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
}
}
private void SetParameters(SqlParameter[] U_USR_MASTERParms, U_USR_MASTER tobjU_USR_MASTER)
{
U_USR_MASTERParms[0].Value = tobjU_USR_MASTER.Usr_Id;
U_USR_MASTERParms[1].Value = tobjU_USR_MASTER.First_Name;
U_USR_MASTERParms[2].Value = tobjU_USR_MASTER.Last_Name;
U_USR_MASTERParms[3].Value = tobjU_USR_MASTER.Alt_Email_Id;
U_USR_MASTERParms[4].Value = tobjU_USR_MASTER.Gender;
U_USR_MASTERParms[5].Value = tobjU_USR_MASTER.Date_Of_Birth;
U_USR_MASTERParms[6].Value = tobjU_USR_MASTER.About_member;
U_USR_MASTERParms[7].Value = tobjU_USR_MASTER.Is_married;
U_USR_MASTERParms[8].Value = tobjU_USR_MASTER.Wed_anniversary;
U_USR_MASTERParms[9].Value = tobjU_USR_MASTER.Rating;
U_USR_MASTERParms[10].Value = tobjU_USR_MASTER.Address_Id;
U_USR_MASTERParms[11].Value = tobjU_USR_MASTER.Usr_role_Id;
U_USR_MASTERParms[12].Value = tobjU_USR_MASTER.Media_Id_Img;
U_USR_MASTERParms[13].Value = tobjU_USR_MASTER.Created_Date;
U_USR_MASTERParms[14].Value = tobjU_USR_MASTER.Updated_Date;
U_USR_MASTERParms[15].Value = tobjU_USR_MASTER.Created_by;
U_USR_MASTERParms[16].Value = tobjU_USR_MASTER.Updated_by;
}
public bool InsertU_USR_MASTER(U_USR_MASTER tobjU_USR_MASTER)
{
if (tobjU_USR_MASTER != null)
{
//Get the parameter list needed by the given object
SqlParameter[] lParamArray = GetParameters(tobjU_USR_MASTER);
SetParameters(lParamArray, tobjU_USR_MASTER);
//Get the connection
SqlConnection con = General.GetConnection();
if (con == null)
{
//Connection is not created
return(false);
}
//Execute the insertion
int i = SqlHelper.ExecuteNonQuery(
con,
CommandType.Text,
SQL_INSERT_U_USR_MASTER,
lParamArray);
//Dispose the Sql connection
con.Dispose();
if (i == 1)
{
//Done and insert the object to the table
return(true);
}
else
{
//Fail to execute the insertion
return(false);
}
}
else
{
//No object found to insert
return(false);
}
}
public void Update_UserProfile(U_USR_MASTER odetails)
{
SqlParameter[] aParms = GetParameters(odetails);
SetParameters(aParms, odetails);
using (SqlConnection conn = General.GetConnection())
{
// conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_Update_U_USR_MASTER, aParms);
trans.Commit();
}
catch (System.Exception e)
{
Console.Write(e);
trans.Rollback();
//log.Error(lobjError, e);
throw;
}
}
}
}
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 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
}
}
