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