public void UserRegistrationIntial() { try { if (txtFirstName.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter the Frist Name..!')", true); } else if (txtLastName.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter the Last Name..!')", true); } else if (txtMobileNumber.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter the Mobile No..!')", true); } else { urUserRegBLLObj.usrUserId = System.Guid.NewGuid().ToString(); urUserRegBLLObj.usrMobileNo = Convert.ToString(txtMobileNumber.Text); urUserRegBLLObj.usrAddress = Convert.ToString(txtAddress.Text); urUserRegBLLObj.usrFirstName = Convert.ToString(txtFirstName.Text); urUserRegBLLObj.usrLastName = Convert.ToString(txtLastName.Text); urUserRegBLLObj.usrStateId = Convert.ToInt32(Session["State"]); urUserRegBLLObj.usrDistrictId = Convert.ToInt32(Session["District"]); urUserRegBLLObj.usrCityId = Convert.ToInt32(Session["City"]); urUserRegBLLObj.usrGender = Convert.ToString(rdoGender.SelectedValue); urUserRegBLLObj.frnrelGroup = "1"; cityBLLObj.cityId = Convert.ToInt32(Session["City"]); //For Createing Password & Encrypting it Random rnd = new Random(); urUserRegBLLObj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); status = urUserRegBLLObj.BLLIsExistUserRegistrationInitial(urUserRegBLLObj); if (status == 0) { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User already Exists')", true); } else { status = urUserRegBLLObj.BLLInsertUserRegistrationInitial(urUserRegBLLObj); if (status > 0) { string myMobileNo = urUserRegBLLObj.usrMobileNo; string myPassword = cc.DESDecrypt(urUserRegBLLObj.usrPassword); string myName = urUserRegBLLObj.usrFirstName; string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); int smslength = passwordMessage.Length; cc.TransactionalSMSCountry("Website", myMobileNo, passwordMessage, smslength, 7); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Registration is Successful.Your Password will be delivered shortly on your mobile. Use it to Sign In your account.')", true); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Registration UnSuccessful')", true); } } ClearAll(); } } catch (Exception ex) { throw ex; } }
public void ChangeRegisteredMobileNo() { try { urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]); urUserRegBLLObj.usrMobileNo = txtNewMobileNo.Text; Random rnd = new Random(); urUserRegBLLObj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); string MobileNo = Convert.ToString(txtNewMobileNo.Text); if (MobileNo.Length == 10) { status = urUserRegBLLObj.BLLIsExistUserRegistrationInitial(urUserRegBLLObj); if (status == 0) { txtNewMobileNo.Text = ""; txtNewMobileNo.Focus(); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Given New Mobile Number already registered in come2mycity.com')", true); // System.Windows.Forms.MessageBox.Show("Given New Mobile Number already registered in come2mycity.com", "Come2MyCity"); } else { status = urUserRegBLLObj.BLLUserRegisteredMobileNoUpdate(urUserRegBLLObj); Response.Write("<script>alert('Mobile number Changed.Login Again')</script>"); if (status > 0) { string senderId = "COM2MYCT"; //string myMobileNo = "91" + urUserRegBLLObj.usrMobileNo; string myMobileNo = urUserRegBLLObj.usrMobileNo; string myPassword = cc.DESDecrypt(urUserRegBLLObj.usrPassword); string myName = Convert.ToString(Session["userName"]); string passwordMessage = "Dear " + myName + ",Password for ur Login with your New Registered Mobile No is:" + myPassword + " " + cc.AddSMS(myMobileNo); cc.SendMessage1(senderId, myMobileNo, passwordMessage); cc.SendMessageImp1(senderId, myMobileNo, passwordMessage); // ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Mobile number Changed.Login Again')", true); Response.Write("<script>alert('Mobile number Changed.Login Again')</script>"); // System.Windows.Forms.MessageBox.Show("Mobile number Changed Successfully.Login Again", "Come2MyCity"); Response.Redirect("Logout.aspx"); } else { // ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Mobile number Not changed.')", true); Response.Write("<script>alert('Mobile number Not changed.')</script>"); // System.Windows.Forms.MessageBox.Show("Mobile number Not changed.Please try again", "Come2MyCity"); txtNewMobileNo.Text = ""; } } } else { Response.Write("<script>alert('please Enter the 10 Disit mobile No..!')</script>"); } } catch (Exception ex) { // throw ex; } }
//---------------------------------------------------User Registration--------------------------------------------------------------------------- #region UserRegistration public string UserRegistration(string Username, string MobileNo, string usrEmailId, string usrGender, string Age) { string userid = ""; try { //string[] FullName = Username.Split(' '); //string fname = Convert.ToString(FullName[0].Trim()); //string lname = Convert.ToString(FullName[1].Trim()); userid = System.Guid.NewGuid().ToString(); Random rnd = new Random(); string pwd = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); string Sql = "insert into usermaster(usrUserId,usrFirstName,usrMobileNo,usrPassword,usrEmailId,usrGender,Age)" + " values('" + userid + "','" + Username + "','" + MobileNo + "','" + pwd + "','" + usrEmailId + "','" + usrGender + "','" + Age + "')"; int ID = cc.ExecuteNonQuery(Sql); if (ID == 1) { string myPassword = cc.DESDecrypt(pwd); string passwordMessage = "Dear " + Username + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(MobileNo); int smslength = passwordMessage.Length; cc.TransactionalSMSCountry("Website", MobileNo, passwordMessage, smslength, 7); } } catch (Exception ex) { throw ex; } return(userid); }
//------------------------------------------------------User Registration To MYCT------------------------------------------------------------------ #region GetRegistration public string GetRegisterRecord(string MobileNo, string Fname, string Lname, string address, string pincode, string strDevId) { int i, smslength; string id = ""; DataSet ds = new DataSet(); try { UserRegistrationBLL balobj = new UserRegistrationBLL(); CommonCode cc = new CommonCode(); balobj.usrFirstName = Fname; balobj.usrLastName = Lname; balobj.usrMobileNo = MobileNo; balobj.usrAddress = address; balobj.usrPIN = pincode; balobj.StrDevId = strDevId; i = balobj.BLLIsExistUserRegistrationInitial(balobj);//check user is exist or not if i = 0 then already exist if (i > 0) { balobj.usrUserId = System.Guid.NewGuid().ToString(); Random rnd = new Random(); balobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); i = balobj.BLLInsertUserRegistrationInitial(balobj); if (i > 0) { id = balobj.usrUserId; string myMobileNo = balobj.usrMobileNo; string myPassword = cc.DESDecrypt(balobj.usrPassword); string myName = balobj.usrFirstName; string passwordMessage = "Welcome " + myName + ",for ur First Login Username="******" & Password is " + myPassword + " " + cc.AddSMS(myMobileNo); smslength = passwordMessage.Length; cc.TransactionalSMSCountry("OnlineExam", myMobileNo, passwordMessage, smslength, 22); //------------------------------ For Dublicate IMEI number.................... string sql3 = "select [usrMobileNo] from usermaster where strDevId = '" + strDevId + "'";//takes all mobile number who have same IMEI number ds = cc.ExecuteDataset(sql3); foreach (DataRow row in ds.Tables[0].Rows) { if (row[0].Equals(MobileNo)) { } else { string sql = "update usermaster set StrDevId = '0' where [usrMobileNo] ='" + row[0] + "' "; int j = cc.ExecuteNonQuery(sql); } } } } else { string sqlget = "select usrUserid from usermaster where usrMobileNo='" + MobileNo + "'";//geting userid of user id = cc.ExecuteScalar(sqlget); string sql2 = "select strDevId from usermaster where usrUserid='" + id + "' "; string str = cc.ExecuteScalar(sql2); if (str == "" || str == null || str == "0") // If IMEI no is null { string sql = "Update usermaster set StrDevId = '" + strDevId + "' where usrUserid ='" + id + "' "; //to add/update IMEI no's for old entries int j = cc.ExecuteNonQuery(sql); } string sql3 = "select [usrMobileNo] from usermaster where strDevId = '" + str + "'";//takes all mobile number who have same IMEI number ds = cc.ExecuteDataset(sql3); foreach (DataRow row in ds.Tables[0].Rows) { if (row[0].Equals(MobileNo)) { } else { string sql = "update usermaster set StrDevId = '0' where [usrMobileNo] ='" + row[0] + "' "; int j = cc.ExecuteNonQuery(sql); } } } } catch (Exception ex) { } return(id); }
//------------------------------------------------------User Registration To MYCT------------------------------------------------------------------ #region RegToUserMaster public string RegToUserMaster(string MobileNo, string Fname, string Lname, string address, string pincode, string strDevId) { string uid = String.Empty; string str = "select usrUserId from [Come2myCityDB].[dbo].[UserMaster] where usrMobileNo='" + MobileNo + "' "; uid = cc.ExecuteScalar(str); if (uid == "" || uid == null) { string newUid = System.Guid.NewGuid().ToString(); Random rnd = new Random(); string Password = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); cmd.Parameters.AddWithValue("@usrMobileNo", MobileNo); cmd.Parameters.AddWithValue("@usrFirstName", Fname); cmd.Parameters.AddWithValue("@usrLastName", Lname); cmd.Parameters.AddWithValue("@usrPassword", Password); cmd.Parameters.AddWithValue("@usrAddress", address); cmd.Parameters.AddWithValue("@usrPIN", pincode); cmd.Parameters.AddWithValue("@strDevId", strDevId); cmd.Parameters.AddWithValue("@usrUserId", newUid); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "uspUserMasterInsert"; cmd.Connection = con; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } int i = cmd.ExecuteNonQuery(); //----------Send SMS--------------------- if (i > 0) { string myMobileNo = MobileNo; string myPassword = cc.DESDecrypt(Password); string myName = Fname; string passwordMessage = "Welcome " + myName + ",for ur First Login for MyCt Password Username="******" & Password is " + myPassword + " " + cc.AddSMS(myMobileNo); int smslength = passwordMessage.Length; cc.TransactionalSMSCountry("OnlineExam", myMobileNo, passwordMessage, smslength, 22); } uid = newUid; } return(uid); }
//Change the Password for particular user public void ChangePassword() { bool flag = false; try { urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]); urUserRegBLLObj.usrPassword = cc.DESEncrypt(txtOldPasswod.Text); urUserRegBLLObj.usrChangePassword = cc.DESEncrypt(txtConfirmNewPassword.Text); status = urUserRegBLLObj.BLLUserRegistrationChangePassword(urUserRegBLLObj); if (status > 0) { List <UserRegistrationBLL> usrInfoList = new List <UserRegistrationBLL>(); DataTable dtUserInfoList = urUserRegBLLObj.BLLGetUserDetails(urUserRegBLLObj); DataRow dRowUserInfoList = dtUserInfoList.Rows[0]; //string myMobileNo = "91" + Convert.ToString(dRowUserInfoList["usrMobileNo"]); string myMobileNo = Convert.ToString(dRowUserInfoList["usrMobileNo"]); string myPassword = cc.DESDecrypt(Convert.ToString(dRowUserInfoList["usrPassword"])); string myName = Convert.ToString(dRowUserInfoList["usrFirstName"]); // string mPassword = cc.DESDecrypt(urUserRegBLLObj.usrChangePassword); int result = onlineexam.UpdatePwd(myMobileNo, Convert.ToString(dRowUserInfoList["usrPassword"])); string sendFrom = "COM2MYCT"; string passwordMessage = "Dear " + myName + ",Your a/c password changed for come2mycity.com.New Password is: " + myPassword + " " + cc.AddSMS(myMobileNo); // ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password changed')", true); //string msg = "Your New Password is: " + cc.DESDecrypt(urUserRegBLLObj.usrChangePassword); flag = cc.SendMessageImp1(sendFrom, myMobileNo, passwordMessage); flag = cc.SendMessage1(sendFrom, myMobileNo, passwordMessage); if (flag == true) { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Changed Successfully...Password will be devlivered shortly on your registered Mobile No.')", true); // System.Windows.Forms.MessageBox.Show("Password Changed Successfully...Password will be devlivered shortly on your registered Mobile No.", "Come2MyCity"); // Response.Redirect("MyProfile.aspx"); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Changed Successfully...Password will be devlivered shortly on your registered Mobile No.')", true); //ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Changed Successfully But Message is not sent')", true); // System.Windows.Forms.MessageBox.Show("Password Changed Successfully But Message is not sent", "Come2MyCity"); } } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Not changed')", true); // System.Windows.Forms.MessageBox.Show("Password Not changed", "Come2MyCity"); } } catch (Exception ex) { //throw ex; } ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Not changed')", true); }
public string GetRegisterRecordUva(string MobileNo, string Fname, string Lname, string address, string pincode) { int status, smslength; string id = ""; UserRegistrationBLL balobj = new UserRegistrationBLL(); CommonCode cc = new CommonCode(); balobj.usrFirstName = Fname; balobj.usrLastName = Lname; balobj.usrMobileNo = MobileNo; balobj.usrAddress = address; balobj.usrPIN = pincode; status = balobj.BLLIsExistUserRegistrationInitial(balobj); if (status > 0) { balobj.usrUserId = System.Guid.NewGuid().ToString(); Random rnd = new Random(); balobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); status = balobj.BLLInsertUserRegistrationInitial(balobj); if (status > 0) { id = balobj.usrUserId; string myMobileNo = balobj.usrMobileNo; string myPassword = cc.DESDecrypt(balobj.usrPassword); string myName = balobj.usrFirstName; string passwordMessage = "Welcome " + myName + ", to www.uva.myct.in,Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); smslength = passwordMessage.Length; // cc.SendMessageUvaSMS("Uva Jagar", myMobileNo, passwordMessage, smslength); cc.TransactionalSMSCountry("Uva Jagar", myMobileNo, passwordMessage, smslength, 20); } } else { DataSet ds = new DataSet(); ds = balobj.BLLGetUserIdPassword(balobj); string name = Convert.ToString(ds.Tables[0].Rows[0]["FullName"]); string password = Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"]); password = cc.DESDecrypt(password); id = Convert.ToString(ds.Tables[0].Rows[0]["usrUserid"]); string passwordMessage = "Welcome " + name + ", to www.uva.myct.in,Password is " + password + " " + cc.AddSMS(MobileNo); smslength = passwordMessage.Length; //cc.SendMessageUvaSMS("Uva Jagar", MobileNo, passwordMessage, smslength); cc.TransactionalSMSCountry("Uva Jagar", MobileNo, passwordMessage, smslength, 20); } return(id); }
public string SendOTP(string CategoryId, string MobileNo, string IEMINo) { int result = 0; string imei = string.Empty; string mobieno = string.Empty; string cid = string.Empty; string otpstr = string.Empty; string OTPstr = string.Empty; string str0 = string.Empty; string str1 = string.Empty; string catName = string.Empty; string st = "select categoryId,MobileNo,IEMINo from [Come2myCityDB].[dbo].[Item] where categoryId='" + CategoryId + "' and MobileNo='" + MobileNo + "'"; DataSet ds = cc.ExecuteDataset(st); string count = ds.Tables[0].Rows.Count.ToString(); if (ds.Tables[0].Rows.Count > 0) { imei = ds.Tables[0].Rows[0]["IEMINo"].ToString(); mobieno = ds.Tables[0].Rows[0]["IEMINo"].ToString(); cid = ds.Tables[0].Rows[0]["IEMINo"].ToString(); } if (count == "" || count == null || count == "0") { string st1 = "select categoryName from [Come2myCityDB].[dbo].[Category] where categoryId='" + CategoryId + "'"; ds = cc.ExecuteDataset(st1); catName = ds.Tables[0].Rows[0][0].ToString(); string o = "select [IEMINo],[MobileNo],[CategoryId],[OTP] FROM [Come2myCityDB].[dbo].[MyCtAppROTP] where IEMINo='" + IEMINo + "' and MobileNo='" + MobileNo + "' and CategoryId='" + CategoryId + "' "; ds = cc.ExecuteDataset(o); if (ds.Tables[0].Rows.Count > 0) { otpstr = Convert.ToString(ds.Tables[0].Rows[0]["OTP"]); } else { Random rand = new Random(); otpstr = rand.Next(1001, 9999).ToString(); str0 = "Insert into [Come2myCityDB].[dbo].[MyCtAppROTP]([IEMINo],[MobileNo],[CategoryId],[OTP]) values('" + IEMINo + "','" + MobileNo + "','" + CategoryId + "','" + otpstr + "')"; result = cc.ExecuteNonQuery(str0); } //----------Send SMS--------------------- if (result > 0) { string myMobileNo = MobileNo; OTPstr = otpstr; //string myName = firstname; string passwordMessage = "Dear Sir, Your Username is " + myMobileNo + " & OTP is " + OTPstr + " for " + catName + " registration " + cc.AddSMS(myMobileNo); int smslength = passwordMessage.Length; cc.TransactionalSMSCountry("OnlineExam", myMobileNo, passwordMessage, smslength, 22); } return("SUCCESS"); } else if (imei.ToString() == IEMINo.ToString() && mobieno.ToString() == MobileNo.ToString() && cid.ToString() == CategoryId.ToString()) { return("UPDATE"); } else { string o1 = "select [IEMINo],[MobileNo],[CategoryId],[OTP] FROM [Come2myCityDB].[dbo].[MyCtAppROTP] where IEMINo='" + IEMINo + "' and MobileNo='" + MobileNo + "' and CategoryId='" + CategoryId + "' "; ds = cc.ExecuteDataset(o1); if (ds.Tables[0].Rows.Count > 0) { otpstr = Convert.ToString(ds.Tables[0].Rows[0]["OTP"]); } else { Random rand = new Random(); otpstr = rand.Next(1001, 9999).ToString(); str1 = "Insert into [Come2myCityDB].[dbo].[MyCtAppROTP]([IEMINo],[MobileNo],[CategoryId],[OTP]) values('" + IEMINo + "','" + MobileNo + "','" + CategoryId + "','" + otpstr + "')"; result = cc.ExecuteNonQuery(str1); } //----------Send SMS--------------------- if (result > 0) { string myMobileNo = MobileNo; OTPstr = otpstr; //string myName = firstname; string passwordMessage = "Welcome , Your OTP Verification for Myct ur Username="******" & OTP is " + OTPstr + " " + cc.AddSMS(myMobileNo); int smslength = passwordMessage.Length; cc.TransactionalSMSCountry("OnlineExam", myMobileNo, passwordMessage, smslength, 22); } return("IEMEI"); } }
public void AddFriendByLongCodeF(UserRegistrationBLL ur, string userMobileWhoSendFriendReq, int grid) {//Mahesh: Use second parameter mobile for only send sms only, because at run time mobile number of sender change. try { string sender = ""; string joiner = ""; bool JoinAll = false; string flagMob = ur.usrAltMobileNo; status = urRegistBll.BLLIsExistUserRegistrationInitial(ur); if (status == 0) { status = urRegistBll.BLLIsExistUserRegistrationInitialByLc(ur); if (status == 0) { string sqlFlagStr = "select JoinFlag from userMaster where usrMobileNo='" + flagMob.ToString() + "'"; int jof = Convert.ToInt32(cc.ExecuteScalar(sqlFlagStr)); if (jof > 1) { JoinAll = true; ur.JoinFlagProp = Convert.ToString(jof); } //DataTable dt1 = new DataTable(); string sql = "select usrUserId, usrFirstName,usrCityId from UserMaster where usrMobileNo='" + ur.usrMobileNo + "'"; DataSet ds = new DataSet(); ds = cc.ExecuteDataset(sql); //dt1 = ds.Tables[0]; string userId; string usrName = ""; int cityId; foreach (DataRow dr1 in ds.Tables[0].Rows) { userId = Convert.ToString(dr1["usrUserId"]); usrName = Convert.ToString(dr1["usrFirstName"]); cityId = Convert.ToInt32(dr1["usrCityId"]); ur.frnrelFriendId = userId; ur.usrCityId = cityId; joiner = Convert.ToString(usrName); //ur.frnrelFrnRelName = usrName; //ur.frnrelRelation = "friend"; //ur.frnrelGroup = "1"; } string sql1 = "select usrUserId, usrFirstName from UserMaster where usrMobileNo='" + ur.usrAltMobileNo + "'"; DataSet ds1 = new DataSet(); ds1 = cc.ExecuteDataset(sql1); //dt1 = ds.Tables[0]; string FriId; string FriName; foreach (DataRow dr2 in ds1.Tables[0].Rows) { FriId = Convert.ToString(dr2["usrUserId"]); FriName = Convert.ToString(dr2["usrFirstName"]); ur.frnrelUserId = FriId; ur.frnrelFrnRelName = FriName; ur.frnrelRelation = "friend"; sender = Convert.ToString(FriName); //ur.frnrelGroup = "1"; //status = ur.BLLInsertUserFriendRelative(ur); ur.frnrelGroup = Convert.ToString(grid); } status = ur.BLLInsertUserFriendRelative(ur); if (status > 0) { string SendTo = ur.usrAltMobileNo; string sendFrom = ur.usrMobileNo; string message = "I " + usrName + "(" + sendFrom.ToString() + ") added u in www.myct.in to send SMS." + cc.AddSMS(SendTo); cc.SendMessage1(sendFrom, SendTo, message); if (JoinAll == true) { string resJoinAll = "Thanks " + joiner.ToString() + ", I " + sender.ToString() + "( " + SendTo.ToString() + " ) also added u on www.myct.in " + cc.AddSMS(sendFrom); cc.SendMessage1(SendTo, sendFrom, resJoinAll); } string changeFlagSql = "update come2mycity.test set FlagStatus = 0 where PK=" + Convert.ToInt32(ur.usrPKval); int pkchange = 0; pkchange = cc.ExecuteNonQuery(changeFlagSql); if (pkchange == 0) { pkchange = cc.ExecuteNonQuery(changeFlagSql); } } else { string SendTo = ur.usrAltMobileNo; string sendFrom = ur.usrMobileNo; string message = "Dear " + joiner.ToString() + " u already added " + sender.ToString() + " in www.myct.in to send SMS." + cc.AddSMS(sendFrom); cc.SendMessage1(SendTo, sendFrom, message); string changeFlagSql = "update come2mycity.test set FlagStatus = 0 where PK=" + Convert.ToInt32(ur.usrPKval); int pkchange = 0; pkchange = cc.ExecuteNonQuery(changeFlagSql); if (pkchange == 0) { pkchange = cc.ExecuteNonQuery(changeFlagSql); } } } else { string sql3 = "select usrUserId, usrFirstName,usrCityId from UserMaster where usrMobileNo='" + ur.usrMobileNo + "'"; DataSet ds = new DataSet(); ds = cc.ExecuteDataset(sql3); //dt1 = ds.Tables[0]; string userId; flagMob = ur.usrAltMobileNo; string usrName = ""; int cityId = 0; string cityName = ""; foreach (DataRow dr1 in ds.Tables[0].Rows) { userId = Convert.ToString(dr1["usrUserId"]); usrName = Convert.ToString(dr1["usrFirstName"]); cityId = Convert.ToInt32(dr1["usrCityId"]); ur.frnrelUserId = userId; ur.usrCityId = cityId; joiner = Convert.ToString(usrName); //ur.frnrelFrnRelName = usrName; //ur.frnrelRelation = "friend"; //ur.frnrelGroup = "1"; } string sqlFlagStr = "select JoinFlag from userMaster where usrMobileNo='" + flagMob.ToString() + "'"; int jof = Convert.ToInt32(cc.ExecuteScalar(sqlFlagStr)); if (jof >= 1) { JoinAll = true; ur.JoinFlagProp = Convert.ToString(jof); } string sqlquery = "select cityName from CityMaster where cityId='" + Convert.ToString(cityId) + "'"; cityName = cc.ExecuteScalar(sqlquery); urRegistBll.usrUserId = System.Guid.NewGuid().ToString(); ur.usrMobileNo = ur.usrAltMobileNo; ur.usrFirstName = ur.frnrelFrnRelName; Random rnd = new Random(); urRegistBll.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); status = urRegistBll.BLLInsertUserRegistrationInitial(urRegistBll); if (status > 0) { string sql1 = "select usrUserId, usrFirstName from UserMaster where usrMobileNo='" + ur.usrAltMobileNo + "'"; DataSet ds1 = new DataSet(); ds1 = cc.ExecuteDataset(sql1); //dt1 = ds.Tables[0]; string FriId; string FriName; foreach (DataRow dr2 in ds1.Tables[0].Rows) { FriId = Convert.ToString(dr2["usrUserId"]); FriName = Convert.ToString(dr2["usrFirstName"]); ur.frnrelFriendId = FriId; ur.frnrelFrnRelName = FriName; ur.frnrelRelation = "friend"; ur.frnrelGroup = Convert.ToString(grid); sender = Convert.ToString(FriName); } status = ur.BLLInsertUserFriendRelative(ur); if (status > 0) { } string senderId = userMobileWhoSendFriendReq.ToString(); string myMobileNo = urRegistBll.usrMobileNo; string myPassword = cc.DESDecrypt(urRegistBll.usrPassword); string myName = ur.frnrelFrnRelName; string thisDir = Server.MapPath("~"); if (!System.IO.Directory.Exists(thisDir + "\\User_Resource\\" + ur.usrUserId + "\\Profile_Photo\\")) { System.IO.Directory.CreateDirectory(thisDir + "\\User_Resource\\" + ur.usrUserId + "\\Profile_Photo\\"); File.Copy(thisDir + "\\User_Resource\\Profile_Photo\\default_user.jpg", thisDir + "\\User_Resource\\" + ur.usrUserId + "\\Profile_Photo\\default_user.jpg"); } //string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AdvMessage(); string passwordMessage = "I " + usrName + "(" + senderId.ToString() + ") added u in come2mycity.com. U use it to send SMS.Dear " + myName + ",Password for ur First Login is " + myPassword + " for come2myCity.com"; cc.SendMessage1(senderId, myMobileNo, passwordMessage); cc.SendMessageImp1(senderId, myMobileNo, passwordMessage); if (JoinAll == true) { string resJoinAll = "Thanks " + joiner.ToString() + ", I " + sender.ToString() + "( " + myMobileNo.ToString() + " ) also added u on www.myct.in " + cc.AddSMS(senderId); cc.SendMessage1(myMobileNo, senderId, resJoinAll); } string changeFlagSql = "update come2mycity.test set FlagStatus = 0 where PK=" + Convert.ToInt32(ur.usrPKval); int pkchange = 0; pkchange = cc.ExecuteNonQuery(changeFlagSql); if (pkchange == 0) { pkchange = cc.ExecuteNonQuery(changeFlagSql); } } } } else { //NotRegisterMessageForLongCode(urRegistBll); } } catch (Exception ex) { throw ex; } }
public string GetRegisterToMahatet(string MobileNo, string Fname, string Lname, string address, string pincode, string EmailId) { int status, smslength; string id = ""; try { UserRegistrationBLL balobj = new UserRegistrationBLL(); CommonCode cc = new CommonCode(); balobj.usrFirstName = Fname; balobj.usrLastName = Lname; balobj.usrMobileNo = MobileNo; balobj.usrAddress = address; balobj.usrPIN = pincode; balobj.usrEmailId = EmailId; status = balobj.BLLIsExistUserRegistrationInitial(balobj); if (status > 0) { balobj.usrUserId = System.Guid.NewGuid().ToString(); Random rnd = new Random(); balobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); status = balobj.BLLInsertUserRegistrationInitial(balobj); if (status > 0) { id = balobj.usrUserId; string myMobileNo = balobj.usrMobileNo; string myPassword = cc.DESDecrypt(balobj.usrPassword); string myName = balobj.usrFirstName; string passwordMessage = "Welcome " + myName + ", to www.mahatet.co.in,Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); smslength = passwordMessage.Length; //cc.SendMessageMahatetSMS("Mahatet", myMobileNo, passwordMessage, smslength); cc.TransactionalSMSCountry("Mahatet", myMobileNo, passwordMessage, smslength, 20); } } else { DataSet ds = new DataSet(); ds = balobj.BLLGetUserIdPassword(balobj); string name = Convert.ToString(ds.Tables[0].Rows[0]["FullName"]); string password = Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"]); password = cc.DESDecrypt(password); id = Convert.ToString(ds.Tables[0].Rows[0]["usrUserid"]); string passwordMessage = "Welcome " + name + ", to www.mahatet.co.in,Password is " + password + " " + cc.AddSMS(MobileNo); smslength = passwordMessage.Length; //cc.SendMessageMahatetSMS("Mahatet", MobileNo, passwordMessage, smslength); cc.TransactionalSMSCountry("Mahatet", MobileNo, passwordMessage, smslength, 20); } } catch (Exception ex) { } // Insert into [Come2MyCityDB].[dbo].[sendercode](ProjectName,Code)values('Mahatet',20) return(id); }
protected void btnUpload_Click(object sender, EventArgs e) { DateTime date = System.DateTime.Now; if (myFile.HasFile) { try { string path = ""; filename = myFile.FileName; // Session["filename"]=filename ; string mobileno = Convert.ToString(Session["MobileNumber"]); string sql = "select usrAutoId, usruserid,JoinGroup from usermaster where usrMobileNo='" + mobileno + "'"; DataSet ds = cc.ExecuteDataset(sql); userid = Convert.ToString(ds.Tables[0].Rows[0]["usruserid"]); usrAutoId = Convert.ToString(ds.Tables[0].Rows[0]["usrAutoId"]); string JoinGroup = Convert.ToString(ds.Tables[0].Rows[0]["JoinGroup"]); string checkq = "select actual_filename from uploaddetails where actual_filename='" + filename + "' and folderuserid='" + userid + "'"; string checkfilename = cc.ExecuteScalar(Convert.ToString(checkq)); if (checkfilename == filename) { Response.Write("<script>alert('File is already exist')</script>"); } else { if (userid != "") { string thisDir = Server.MapPath("~/User_Resource/"); System.IO.Directory.CreateDirectory(thisDir + userid + ""); string newpa = "" + thisDir + userid + ""; string newpath = Server.MapPath("~/User_Resource/" + userid + ""); path = newpath + "\\" + myFile.FileName; if (System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".wav" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".mp4" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".txt" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".doc" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".xlsx" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".mp3" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".flv" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".avi" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".xls" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".pdf" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpg" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".png" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".gif" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpeg" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".csv") { lblError.Text = "The file must have an extension of .MP3,.FLV,.AVI,.XLS,.xlsx.PDF,.JPG,.JPEG,.png,.gif,.csv,.doc,.txt,.mp4,.wav"; return; } else { string ePath = newpa; string[] filename1 = Directory.GetFiles(ePath, "*"); myFile.SaveAs(path); string type = System.IO.Path.GetExtension(myFile.FileName); fakefileName = Guid.NewGuid().ToString(); string fname = filename.Replace(filename, fakefileName); string newfname = fakefileName.Remove(5); Response.Write("<script>alert('File Uploaded Successfully')</script>"); //string ur = "User_Resource/"; string aa = "http://www.myct.in/NCP/down.aspx?"; newstring = aa.Replace("NCP", JoinGroup); url = "" + newstring + usrAutoId + newfname + ""; if (userid != "") { string sql11 = "update usermaster set FilePath= '" + url + "' where usrUserid='" + userid + "'"; int a = cc.ExecuteNonQuery(sql11); } string senderid = "myctin"; string Message = "Dear user Download Url " + url + "" + cc.AddSMS(mobileno); cc.SendMessageTra(senderid, mobileno, Message); string sqlinsert = "insert into uploaddetails(autouserid,url,upload_filename,upload_filetype,upload_date,folderuserid,actual_filename,url_link)" + "values('" + usrAutoId + "','" + url + "','" + newfname + "','" + type + "','" + date + "','" + userid + "','" + filename + "','" + url + "')"; int ss = cc.ExecuteNonQuery(sqlinsert); } } } } catch (Exception ex) { } } GridUploadshow(); }
protected void btnUpload_Click(object sender, EventArgs e) { string filename = ""; //if (FileUpload1.HasFile) //{ // string a= FileUpload1.FileName.ToString(); // string uploadFolder = Request.PhysicalApplicationPath + "UploadHere\\"; // FileUpload1.SaveAs(uploadFolder + FileUpload1.FileName); //} if (myFile.HasFile) { try { string path = ""; filename = myFile.FileName; //} string mobileno = Convert.ToString(Session["MobileNo"]); string sql = "select usruserid from usermaster where usrMobileNo='" + mobileno + "'"; DataSet ds = cc.ExecuteDataset(sql); string userid = Convert.ToString(ds.Tables[0].Rows[0]["usruserid"]); if (userid != "") { string thisDir = Server.MapPath("~/User_Resource/"); System.IO.Directory.CreateDirectory(thisDir + userid + ""); string newpa = "" + thisDir + userid + ""; string newpath = Server.MapPath("~/User_Resource/" + userid + ""); path = newpath + "\\" + myFile.FileName; if (System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".wav" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".mp4" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".txt" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".doc" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".xlsx" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".mp3" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".flv" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".avi" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".xls" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".pdf" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpg" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".png" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".gif" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpeg" && System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".csv") { lblError.Text = "The file must have an extension of .MP3,.FLV,.AVI,.XLS,.xlsx.PDF,.JPG,.JPEG,.png,.gif,.csv,.doc,.txt,.mp4,.wav"; return; } else { string ePath = newpa; string[] filename1 = Directory.GetFiles(ePath, "*"); foreach (string str in filename1) { File.Delete(str); } myFile.SaveAs(path); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('File Uploaded Successfully')", true); string aa = "http://www.myct.in/NCP/down.aspx?User_Resource/"; string url = "" + aa + userid + ""; if (userid != "") { string sql11 = "update usermaster set FilePath= '" + url + "' where usrUserid='" + userid + "'"; int a = cc.ExecuteNonQuery(sql11); } string senderid = "myctin"; string Message = "Dear user Downloading Url is " + url + "" + cc.AddSMS(mobileno); cc.SendMessageTra(senderid, mobileno, Message); } } } catch (Exception ex) { } } }
public bool RegisterNewExcel1(string mno, string fnm, string lnm, string pin, string gr, string ct, string prefix, string defltgrp) { bool a = true; try { string usrmoNo = Convert.ToString(Session["MobileNumber"]); cqc.usrMobileNo = usrmoNo.ToString(); status = BLLIsExistUserRegistrationInitial(usrmoNo); if (status == 0) { status = BLLIsExistUserRegistrationInitial(mno); if (status == 0) { string sql = "select * from usermaster where usrMobileNo='" + mno + "'"; DataSet ds1 = cc.ExecuteDataset(sql); objMiscalreg.Userid = Session["MarketingUser"].ToString(); string friendid = Convert.ToString(ds1.Tables[0].Rows[0]["usrUserid"]); objMiscalreg.Friendid = friendid; string fname = Convert.ToString(ds1.Tables[0].Rows[0]["usrFirstName"]); string lname = Convert.ToString(ds1.Tables[0].Rows[0]["usrLastName"]); status = objMiscalreg.BALFriendIsExist(objMiscalreg); if (status == 1) { objMiscalreg.Friendid = friendid; objMiscalreg.FriendName = fname + "" + lname; objMiscalreg.Groupno = gr; objMiscalreg.Userid = Session["MarketingUser"].ToString(); objMiscalreg.BALInsertMiscalRegistration(objMiscalreg); } else { objMiscalreg.Friendid = friendid; objMiscalreg.FriendName = fname + "" + lname; objMiscalreg.Groupno = gr; objMiscalreg.Userid = Session["MarketingUser"].ToString(); objMiscalreg.BALUpdateMiscalRegistration(objMiscalreg); } } else { urUserRegBLLObj.usrFirstName = fnm; urUserRegBLLObj.usrLastName = lnm; urUserRegBLLObj.usrPIN = pin; urUserRegBLLObj.usrCityName = ct; urUserRegBLLObj.usrMobileNo = mno; urUserRegBLLObj.usrUserId = System.Guid.NewGuid().ToString(); Random rnd = new Random(); urUserRegBLLObj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); status = urUserRegBLLObj.BLLInsertUserRegistrationInitial(urUserRegBLLObj); if (status > 0) { string senderId = "COM2MYCT"; string myMobileNo = urUserRegBLLObj.usrMobileNo; string myPassword = cc.DESDecrypt(urUserRegBLLObj.usrPassword); string myName = urUserRegBLLObj.usrFirstName; string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); int length = passwordMessage.Length; //cc.SendMessageTra(senderId, myMobileNo, passwordMessage); cc.SendMessageRegistrationSMS("Website", myMobileNo, passwordMessage, length); } string sql1 = "select * from usermaster where usrMobileNo='" + mno + "'"; DataSet ds = cc.ExecuteDataset(sql1); string friendid = Convert.ToString(ds.Tables[0].Rows[0]["usrUserid"]); string fname = Convert.ToString(ds.Tables[0].Rows[0]["usrFirstName"]); string lname = Convert.ToString(ds.Tables[0].Rows[0]["usrLastName"]); cqc.frnrelFriendId = friendid; cqc.frnrelUserId = Session["MarketingUser"].ToString(); //cqc.FR1 = "1"; //Not to add in personal group //cqc.BLLInsertUserFriendRelative(cqc); objMiscalreg.Friendid = friendid; objMiscalreg.FriendName = fname + "" + lname; objMiscalreg.Groupno = gr; objMiscalreg.Userid = Session["MarketingUser"].ToString(); objMiscalreg.BALInsertMiscalRegistration(objMiscalreg); } } } catch (Exception ex) { } return(a); }
public void AddSubUser(string mobile, string fname, string lname, string schoolcode, string usrclass, string section, string Hm_usrID) { try { DateTime dt = DateTime.Now; // get current date double d = 5; //add hours in time double m = 48; //add min in time DateTime SystemDate = Convert.ToDateTime(dt).AddHours(d); SystemDate = SystemDate.AddMinutes(m); CurrenctDate = SystemDate.ToString("yyyy'-'MM'-'dd HH':'mm':'ss tt''"); urUserRegBLLObj.Customermobileno = mobile; Leader_UserID = Hm_usrID; SchoolCode = schoolcode; Fname = fname; Lname = lname; status = urUserRegBLLObj.BLLSearchUserExist(urUserRegBLLObj); if (status > 0) { if (mobile != "" && mobile.Length == 10) { sql = "select usrUserid from usermaster where usrMobileNo='" + Convert.ToString(mobile) + "'"; Jr_ID = cc.ExecuteScalar(sql); sql = "select id from AdminSubMarketingSubUser where friendid='" + Convert.ToString(Jr_ID) + "' and roleid=76 and userid= '" + Convert.ToString(Hm_usrID) + "'"; string Check_HMavailable = cc.ExecuteScalar(sql); // check hm assign or not. if (Check_HMavailable != "" || Check_HMavailable != null) { sql = "select SchoolCode from UDISE_TeacherMaster where junior_id='" + Jr_ID + "' and Active=1"; string checkschoolCode = cc.ExecuteScalar(sql); // check hm assign or not. if (checkschoolCode != schoolcode && checkschoolCode != "") { sql = "select id from UDISE_TeacherMaster where junior_id='" + Jr_ID + "' and Class='' and Section='' and Active=1 and SchoolCode= '" + checkschoolCode + "'"; string HM = cc.ExecuteScalar(sql); // Get Hm if (HM != "" || HM != null) { } else { sql = "Update UDISE_TeacherMaster set Active=0 ,EntryDate='" + CurrenctDate + "' where SchoolCode= '" + checkschoolCode + "' and junior_id='" + Jr_ID + "'"; int Teach = cc.ExecuteNonQuery(sql);// update tecaher status if (Teach == 1) { } } } else { sql = "select id from UDISE_TeacherMaster where junior_id='" + Jr_ID + "' and SchoolCode= '" + schoolcode + "' and Active=1"; string Check_TecaherAlredyAssign = cc.ExecuteScalar(sql);// check current teacher or HM assign or not perticular school code if (Check_TecaherAlredyAssign != "" || Check_TecaherAlredyAssign != null) { sql = "select id from UDISE_TeacherMaster where SchoolCode= '" + schoolcode + "' and Class='" + usrclass + "' and Section='" + section + "' and Active=1 "; string checl_ClassAssign = cc.ExecuteScalar(sql);// check this school code ,class & section already assign or not if (checl_ClassAssign == "" || checl_ClassAssign == null) { sql = "insert into UDISE_TeacherMaster(leader_id,junior_id,SchoolCode,Class,Section,EntryDate,Active)" + "values('" + Leader_UserID + "','" + Jr_ID + "','" + schoolcode + "','" + usrclass + "','" + section + "','" + CurrenctDate + "',1)"; int a = cc.ExecuteNonQuery(sql); // add tecaher or Hm in Tecaher Master if (a == 1) { string SQL = "select * from usermaster where usrUserid='" + Jr_ID + "'"; SQL = SQL + "select usrMobileNo from usermaster where usrUserid='" + Leader_UserID + "'"; DataSet ds = cc.ExecuteDataset(SQL); if (ds.Tables[0].Rows.Count > 0) { // string sqll = "select usrMobileNo from usermaster where usrUserid='" + Leader_UserID + "'"; // string leaderMobileNo = cc.ExecuteScalar(sqll); string myMobileNo = Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNo"]); string myPassword = cc.DESDecrypt(Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"])); string passwordMessage; Leader_MobileNo = Convert.ToString(ds.Tables[1].Rows[0]["usrMobileNo"]); // string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); if (section == "" && usrclass == "") { passwordMessage = "U R Registered as HM for school " + schoolcode + " by " + Leader_MobileNo + " ur login pwd for www.myct.in & www.udisecce.myct.in is " + myPassword + " " + cc.AddSMS(myMobileNo); } else { passwordMessage = "U R Registered as Teacher for class " + usrclass + "(" + section + ")of school " + schoolcode + " by " + Leader_MobileNo + " send every day DAR sms on 8378977897. Ur password is " + myPassword + " for " + cc.AddSMS(myMobileNo); } int smslength = passwordMessage.Length; cc.SendMessageLongCodeSMS("UDISE", myMobileNo, passwordMessage, smslength); } } else { } // AddNewUser(Hm_usrID, Jr_ID); AddSubUser_EO1(mobile, Fname, Lname, Leader_MobileNo); } else { string chkUserId = "select junior_id from UDISE_TeacherMaster where SchoolCode= '" + schoolcode + "' and Class='" + usrclass + "' and Section='" + section + "'"; string TRUserId = cc.ExecuteScalar(chkUserId); // check this school code ,class & section already assign or not if (TRUserId == "" || TRUserId == null) { } else { sql = "Update UDISE_TeacherMaster set junior_id='" + Jr_ID + "' , EntryDate='" + CurrenctDate + "', Active=1 where SchoolCode= '" + schoolcode + "' and Class='" + usrclass + "' and Section='" + section + "' "; string UpTeach = Convert.ToString(cc.ExecuteNonQuery(sql)); // update class ,section & school code if (UpTeach == "" || UpTeach == null) { string SQL = "select * from usermaster where usrUserid='" + Jr_ID + "'"; SQL = SQL + "select usrMobileNo from usermaster where usrUserid='" + Leader_UserID + "'"; DataSet ds = cc.ExecuteDataset(SQL); if (ds.Tables[0].Rows.Count > 0) { // string sqll = "select usrMobileNo from usermaster where usrUserid='" + Leader_UserID + "'"; // string leaderMobileNo = cc.ExecuteScalar(sqll); string myMobileNo = Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNo"]); string myPassword = cc.DESDecrypt(Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"])); string passwordMessage; Leader_MobileNo = Convert.ToString(ds.Tables[1].Rows[0]["usrMobileNo"]); // string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); if (section == "" && usrclass == "") { passwordMessage = "U R Registered as HM for school " + schoolcode + " by " + Leader_MobileNo + " ur login pwd for www.myct.in & www.udisecce.myct.in is " + myPassword + " " + cc.AddSMS(myMobileNo); } else { passwordMessage = "U R Registered as Teacher for class " + usrclass + "(" + section + ")of school " + schoolcode + " by " + Leader_MobileNo + " send every day DAR sms on 8378977897. Ur password is " + myPassword + " for " + cc.AddSMS(myMobileNo); } int smslength = passwordMessage.Length; cc.SendMessageLongCodeSMS("UDISE", myMobileNo, passwordMessage, smslength); } } else { //string UDAdmin = "update AdminSubMarketingSubUser set friendid='" + Jr_ID + "' where roleid=41 and friendid='" + TRUserId + "' and reference_id10='"+Leader_UserID+"'"; //int a = cc.ExecuteNonQuery(UDAdmin); } } } } else { } } } //else //{ // //string Checkschoolcode = "select SchoolCode from UDISE_TeacherMaster where junior_id='" + frndid + "' and SchoolCode= '" + schoolcode + "'"; // //string Scode = cc.ExecuteScalar(Checkschoolcode); // //if (Scode == "" || Scode == null) // //{ // //} // //else // //{ // sql = "select SchoolCode from UDISE_TeacherMaster where junior_id='" + Jr_ID + "'"; // string schoolcode1 = cc.ExecuteScalar(sql); // if (schoolcode1 == "" || schoolcode1 == null) // { // sql = "select id from UDISE_TeacherMaster where junior_id='" + Jr_ID + "' and SchoolCode= '" + schoolcode + "'"; // string id = cc.ExecuteScalar(sql); // if (id == "" || id == null) // { // sql = "insert into UDISE_TeacherMaster(leader_id,junior_id,SchoolCode,Class,Section)" + // "values('" + Leader_UserID + "','" + Jr_ID + "','" + schoolcode + "','" + usrclass + "','" + section + "')"; // int a = cc.ExecuteNonQuery(sql); // } // else // { // } // } // else // { // string chkUserId = "select junior_id from UDISE_TeacherMaster where SchoolCode= '" + schoolcode + "' and Class='" + usrclass + "' and Section='" + section + "'"; // string TRUserId = cc.ExecuteScalar(chkUserId); // if (TRUserId == "" || TRUserId == null) // { // } // else // { // sql = "Update UDISE_TeacherMaster set junior_id='" + Jr_ID + "' where SchoolCode= '" + schoolcode + "' and Class='" + usrclass + "' and Section='" + section + "'"; // string UpTeach = Convert.ToString(cc.ExecuteNonQuery(sql)); // if (UpTeach == "" || UpTeach == null) // { // } // else // { // string UDAdmin = "update AdminSubMarketingSubUser set friendid='" + Jr_ID + "' where roleid=77 and friendid='" + TRUserId + "'"; // int a = cc.ExecuteNonQuery(UDAdmin); // } // } // } //} // } } else { //int Status = Addnew(fname, lname, mobile); //if (Status == 1) //{ // AddSubUser(mobile, fname, lname, schoolcode, usrclass, section, Hm_usrID); //} } } else { int Status = Addnew(fname, lname, mobile); if (Status == 1) { AddSubUser(mobile, fname, lname, schoolcode, usrclass, section, Hm_usrID); } } } catch (Exception ez) { } }
private void FriendRelativeAdd() { try { string senderId = "myctin"; urUserRegBLLObj.usrUserId = System.Guid.NewGuid().ToString(); string friendid = urUserRegBLLObj.usrUserId; urUserRegBLLObj.usrMobileNo = Convert.ToString(txtMobileNumber.Text); string mymobile = urUserRegBLLObj.usrMobileNo; urUserRegBLLObj.usrAddress = Convert.ToString(txtAddress.Text); urUserRegBLLObj.usrFirstName = Convert.ToString(txtFirstName.Text); urUserRegBLLObj.usrLastName = Convert.ToString(txtLastName.Text); if (rdoCityLocation.SelectedItem.Value == "SC") { urUserRegBLLObj.usrCityId = Convert.ToInt32(Session["City"]); } else if (rdoCityLocation.SelectedItem.Value == "DC") { pnlSelectLocation.Visible = true; if (cmbCity.SelectedValue != null) { urUserRegBLLObj.usrCityId = Convert.ToInt32(Convert.ToString(cmbCity.SelectedValue)); } else { urUserRegBLLObj.usrCityId = Convert.ToInt32(Session["City"]); } } string gr = cmbFriendGroup.SelectedItem.Text; Random rnd = new Random(); urUserRegBLLObj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999))); string pass = cc.DESDecrypt(urUserRegBLLObj.usrPassword); status = urUserRegBLLObj.BLLIsExistUserRegistrationInitial(urUserRegBLLObj); if (status == 0) { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User already Exists...')", true); } else { status = urUserRegBLLObj.BLLInsertUserRegistrationInitial(urUserRegBLLObj); if (status > 0) { string passwordMessage = "Dear " + txtFirstName.Text + ", Password for ur First Login is " + pass + " " + cc.AddSMS(txtMobileNumber.Text); cc.SendMessageTra(senderId, mymobile, passwordMessage); cqc.frnrelFriendId = friendid; cqc.frnrelUserId = Session["MarketingUser"].ToString(); //cqc.FR1 = "1"; //Not to add in personal group //cqc.BLLInsertUserFriendRelative(cqc); objMiscalreg.Friendid = friendid; objMiscalreg.FriendName = txtFirstName.Text + "" + txtLastName.Text; objMiscalreg.Groupno = gr; objMiscalreg.Userid = Session["MarketingUser"].ToString(); objMiscalreg.BALInsertMiscalRegistration(objMiscalreg); Response.Redirect("../MarketingAdmin/ReportMiscal.aspx"); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Not added')", true); } } clearAddFriend(); } catch (Exception ex) { //throw ex; } }
public void sendmessage(string leader_userId, string JuniourMno, string RegBoys, string PresentBoys, string RegGirls, string presentGirls, string checkschoolCode) { try { string SQL = "select usrLastName,usrMobileNo,usrPassword from usermaster where usrMobileNo='" + JuniourMno + "'"; SQL = SQL + "select usrMobileNo from usermaster where usrUserid='" + leader_userId + "'"; DataSet ds = cc.ExecuteDataset(SQL); if (ds.Tables[0].Rows.Count > 0) { // string sqll = "select usrMobileNo from usermaster where usrUserid='" + Leader_UserID + "'"; // string leaderMobileNo = cc.ExecuteScalar(sqll); string usrLastName = Convert.ToString(ds.Tables[0].Rows[0]["usrLastName"]); string myMobileNo = Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNo"]); // string myPassword = cc.DESDecrypt(Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"])); string passwordMessage; string leader_Mobileno = Convert.ToString(ds.Tables[1].Rows[0]["usrMobileNo"]); // string passwordMessage = "Dear " + myName + ", Password for ur First Login is " + myPassword + " " + cc.AddSMS(myMobileNo); passwordMessage = "Dear " + usrLastName + " in ur school '" + checkschoolCode + "' total RB*" + RegBoys + "*RG*" + RegGirls + "* PB*" + PresentBoys + "* PG*" + presentGirls + " Stds r Recorded pl update changes up 7PM." + cc.AddSMS(myMobileNo); int smslength = passwordMessage.Length; cc.SendMessageLongCodeSMS("UDISE", myMobileNo, passwordMessage, smslength); string SQl = "select usrMobileNo ,usrLastName from UserMaster where usrUserId in (select friendid from UserMaster inner join AdminSubMarketingSubOrdinate on AdminSubMarketingSubOrdinate.userid=UserMaster.usruserid where usrmobileno='" + JuniourMno + "')"; DataSet ds1 = cc.ExecuteDataset(SQl); for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { usrLastName = Convert.ToString(ds1.Tables[0].Rows[i]["usrLastName"]); myMobileNo = Convert.ToString(ds1.Tables[0].Rows[i]["usrMobileNo"]); passwordMessage = "Dear " + usrLastName + " in ur school '" + checkschoolCode + "' total RB*" + RegBoys + "*RG*" + RegGirls + "* PB*" + PresentBoys + "* PG*" + presentGirls + " Stds r Recorded pl update changes up 7PM." + cc.AddSMS(myMobileNo); smslength = passwordMessage.Length; cc.SendMessageLongCodeSMS("UDISE", myMobileNo, passwordMessage, smslength); } } } catch (Exception ex) { } }