public void insertrecord()
{
usrBLL.usrMobileNo = txtmobileno.Text;
string sqlfetch = "select usrUserid from usermaster where usrMobileNo='" + usrBLL.usrMobileNo + "'";
string userid = cc.ExecuteScalar(sqlfetch);
status = usrBLL.BLLIsExistUserRegistrationInitial(usrBLL);
if (status == 0)
{
string sqlcheck = "select id from SMSstatus where Userid='" + userid + "' ";
string id = cc.ExecuteScalar(sqlcheck);
if (id == null || id == "")
{
DateTime datetime = DateTime.Now;
string smsstatus = "Deactive";
string sql = "insert into SMSstatus(Userid,SMS_status,sms_date)values('" + userid + "','" + smsstatus + "','" + datetime + "')";
string insertvalue = cc.ExecuteScalar(sql);
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('SMS menu is deactivated successfully')", true);
}
//else
//{
// ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('SMS menu is already deactivated to your account ')", true);
//}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('This number is not registered to www.myct.in')", true);
}
gridshow();
}
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;
}
}
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);
}
public string GetRegisterRecord(string MobileNo, string Fname, string Lname, string address, string pincode, string status)
{
int i, 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;
i = balobj.BLLIsExistUserRegistrationInitial(balobj);
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 + ", to www.exam.myct.in,for ur First Login Username="******" & Password is " + myPassword + " " + cc.AddSMS(myMobileNo);
smslength = passwordMessage.Length;
cc.TransactionalSMSCountry("OnlineExam", myMobileNo, passwordMessage, smslength, 22);
}
}
else
{
if (status == "1")
{
DataSet ds = new DataSet();
ds = balobj.BLLGetUserIdPassword(balobj);
if (ds.Tables[0].Rows.Count > 0)
{
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.exam.myct.in,Password for ur First Login is " + password + " " + cc.AddSMS(MobileNo);
smslength = passwordMessage.Length;
cc.TransactionalSMSCountry("OnlineExam", MobileNo, passwordMessage, smslength, 22);
}
}
}
return(id);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string mobileNo = txtMobileNo.Text;
urUserRegBLLObj.usrMobileNo = mobileNo;
string sql = "select usrUserId from usermaster where usrMobileNo='" + mobileNo + "'";
userid = cc.ExecuteScalar(sql);
Session["userid"] = userid;
//string usrUserid = Session["userid"].ToString();
status = urUserRegBLLObj.BLLIsExistUserRegistrationInitial(urUserRegBLLObj);
if (status == 0)
{
UserInfo.Visible = true;
// state();
UserProfileHeaderInfo();
ShowContact();
ShowProfessionalInfo();
}
else
{
Response.Write("<script>(alert)('This number is not registered to www.myct.in')</script>");
}
}
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;
}
}
//------------------------------------------------------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);
}
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 void geturlrecords()
{
try
{
//p1 = Convert.ToString(Request.QueryString["p1"]);// SimSerialNo
//p1 = Get(p1);
//p2 = Convert.ToString(Request.QueryString["p2"]); //IMEI No
//p2 = Get(p2);
//p3 = Convert.ToString(Request.QueryString["p3"]);// Key_Word(Head,Member)
//p3 = Get(p3);
//p4 = Convert.ToString(Request.QueryString["p4"]);//mobileNo
//p4 = Get(p4);
//p5 = Convert.ToString(Request.QueryString["p5"]);//Firstname
//p5 = Get(p5);
//p6 = Convert.ToString(Request.QueryString["p6"]);//middlename
//p6 = Get(p6);
//p7 = Convert.ToString(Request.QueryString["p7"]); //last Name
//p7 = Get(p7);
//p8 = Convert.ToString(Request.QueryString["p8"]); // Address
//p8 = Get(p8);
//p9 = Convert.ToString(Request.QueryString["p9"]); // Word No
//p9 = Get(p9);
//p10 = Convert.ToString(Request.QueryString["p10"]); // Pin Code
//p10 = Get(p10);
//p11 = Convert.ToString(Request.QueryString["p11"]); // DOB
//p11 = Get(p11);
//p12 = Convert.ToString(Request.QueryString["p12"]);// Age
//p12 = Get(p12);
//p13 = Convert.ToString(Request.QueryString["p13"]); // Job
//p13 = Get(p13);
//p14 = Convert.ToString(Request.QueryString["p14"]); //Education
//p14 = Get(p14);
//p15 = Convert.ToString(Request.QueryString["p15"]); // Aadhar No.
//p15 = Get(p15);
//p16 = Convert.ToString(Request.QueryString["p16"]); // Votter ID
//p16 = Get(p16);
//p17 = Convert.ToString(Request.QueryString["p17"]); // Social ID
//p17 = Get(p17);
//p18 = Convert.ToString(Request.QueryString["p18"]);// Religion
//p18 = Get(p18);
//p19 = Convert.ToString(Request.QueryString["p19"]); // category
//p19 = Get(p19);
//string date = Convert.ToString(Request.QueryString["receivedDateTime"]); // date
//p20 = Convert.ToString(Request.QueryString["p20"]); // caste
//p20 = Get(p20);
//p21 = Convert.ToString(Request.QueryString["p21"]); // Attached to (Belong to party/Community)
//p21 = Get(p21);
//p22 = Convert.ToString(Request.QueryString["p22"]); // Marriage Date
//p22 = Get(p22);
//p23 = Convert.ToString(Request.QueryString["p23"]); // JobPalce
//p23 = Get(p23);
//p24 = Convert.ToString(Request.QueryString["p24"]); // Votter List No
//p24 = Get(p24);
//p25 = Convert.ToString(Request.QueryString["p25"]);// Emain ID
//p25 = Get(p25);
//p26 = Convert.ToString(Request.QueryString["p26"]);// Name in Voter List
//p26 = Get(p26);
//p27 = Convert.ToString(Request.QueryString["p27"]); // name in ration Card
//p27 = Get(p27);
//p28 = Convert.ToString(Request.QueryString["p28"]); // Own House
//p28 = Get(p28);
//p29 = Convert.ToString(Request.QueryString["p29"]); //Pan card
//p29 = Get(p29);
//p30 = Convert.ToString(Request.QueryString["p30"]); // Senior Citizen
//p30 = Get(p30);
//p31 = Convert.ToString(Request.QueryString["p31"]); // railway Pass
//p31 = Get(p31);
//p32 = Convert.ToString(Request.QueryString["p32"]); //Handicap
//p32 = Get(p32);
//p33 = Convert.ToString(Request.QueryString["p33"]); //Aadhar nidhi
//p33 = Get(p33);
//p34 = Convert.ToString(Request.QueryString["p34"]); // s.Gandhi Yojana
//p34 = Get(p34);
//p35 = Convert.ToString(Request.QueryString["p35"]); // Scholarship
//p35 = Get(p35);
//p36 = Convert.ToString(Request.QueryString["p36"]); // photo
//p36 = Get(p36);
p1 = Convert.ToString(Request.QueryString["p1"]);
p1 = Get(p1);
p2 = Convert.ToString(Request.QueryString["p2"]);
p2 = Get(p2);
p3 = Convert.ToString(Request.QueryString["p3"]);
p3 = Get(p3);
p4 = Convert.ToString(Request.QueryString["p4"]);
p4 = Get(p4);
p5 = Convert.ToString(Request.QueryString["p5"]);
p5 = Get(p5);
p6 = Convert.ToString(Request.QueryString["p6"]);
p6 = Get(p6);
p7 = Convert.ToString(Request.QueryString["p7"]);
p7 = Get(p7);
p8 = Convert.ToString(Request.QueryString["p8"]);
p8 = Get(p8);
p9 = Convert.ToString(Request.QueryString["p9"]);
p9 = Get(p9);
p10 = Convert.ToString(Request.QueryString["p10"]);
p10 = Get(p10);
p11 = Convert.ToString(Request.QueryString["p11"]);
p11 = Get(p11);
p12 = Convert.ToString(Request.QueryString["p12"]);
p12 = Get(p12);
p13 = Convert.ToString(Request.QueryString["p13"]);
p13 = Get(p13);
p14 = Convert.ToString(Request.QueryString["p14"]);
p14 = Get(p14);
p15 = Convert.ToString(Request.QueryString["p15"]);
p15 = Get(p15);
p16 = Convert.ToString(Request.QueryString["p16"]);
p16 = Get(p16);
p17 = Convert.ToString(Request.QueryString["p17"]);
p17 = Get(p17);
p18 = Convert.ToString(Request.QueryString["p18"]);
p18 = Get(p18);
p19 = Convert.ToString(Request.QueryString["p19"]);
p19 = Get(p19);
string date = Convert.ToString(Request.QueryString["receivedDateTime"]);
p20 = Convert.ToString(Request.QueryString["p20"]);
p20 = Get(p20);
p21 = Convert.ToString(Request.QueryString["p21"]);
p21 = Get(p21);
p22 = Convert.ToString(Request.QueryString["p22"]);
p22 = Get(p22);
p23 = Convert.ToString(Request.QueryString["p23"]);
p23 = Get(p23);
p24 = Convert.ToString(Request.QueryString["p24"]);
p24 = Get(p24);
p25 = Convert.ToString(Request.QueryString["p25"]);
p25 = Get(p25);
p26 = Convert.ToString(Request.QueryString["p26"]);
p26 = Get(p26);
p27 = Convert.ToString(Request.QueryString["p27"]);
p27 = Get(p27);
p28 = Convert.ToString(Request.QueryString["p28"]);
p28 = Get(p28);
p29 = Convert.ToString(Request.QueryString["p29"]);
p29 = Get(p29);
p30 = Convert.ToString(Request.QueryString["p30"]);
p30 = Get(p30);
p31 = Convert.ToString(Request.QueryString["p31"]);
p31 = Get(p31);
p32 = Convert.ToString(Request.QueryString["p32"]);
p32 = Get(p32);
p33 = Convert.ToString(Request.QueryString["p33"]);
p33 = Get(p33);
p34 = Convert.ToString(Request.QueryString["p34"]);
p34 = Get(p34);
p35 = Convert.ToString(Request.QueryString["p35"]);
p35 = Get(p35);
p36 = Convert.ToString(Request.QueryString["p36"]);
p36 = Get(p36);
androidobj.P1 = p1;
androidobj.P2 = p2;
androidobj.P3 = p3;
androidobj.P4 = p4;
androidobj.P5 = p5;
androidobj.P6 = p6;
androidobj.P7 = p7;
androidobj.P8 = p8;
androidobj.P9 = p9;
androidobj.P10 = p10;
androidobj.P11 = p11;
androidobj.P12 = p12;
androidobj.P13 = p13;
androidobj.P14 = p14;
androidobj.P15 = p15;
androidobj.P16 = p16;
androidobj.P17 = p17;
androidobj.P18 = p18;
androidobj.P19 = p19;
androidobj.P20 = p20;
androidobj.P21 = p21;
androidobj.P22 = p22;
androidobj.P23 = p23;
androidobj.P24 = p24;
androidobj.P25 = p25;
androidobj.P26 = p26;
androidobj.P27 = p27;
androidobj.P28 = p28;
androidobj.P29 = p29;
androidobj.P30 = p30;
androidobj.P31 = p31;
androidobj.P32 = p32;
androidobj.P33 = p33;
androidobj.P34 = p34;
androidobj.P35 = p35;
androidobj.P36 = p36;
androidobj.Date = date;
p3 = p3.ToUpper();
if (p3 == "HEAD" || p3 == "MAIN")
{
string SQl = "select id from androidlongcode where ='" + p4 + "'";
Already = cc.ExecuteScalar(SQl);
}
else if (p3 == "MEMBER" || p3 == "FAMILY")
{
string SQl = "select id from androidlongcode where p4='" + p4 + "' and p6='" + p6 + "'";
Already = cc.ExecuteScalar(SQl);
}
else if (p3 == "RELATIVE")
{
string SQl = "select id from androidlongcode where p4='" + p4 + "' and p5='" + p5 + "'";
Already = cc.ExecuteScalar(SQl);
}
if (Already == "")
{
status = androidobj.BLLInsertAndroidData(androidobj);
if (status > 0)
{
if (p3 == "HEAD" || p3 == "MAIN")
{
androidobj.Simno = p1;
androidobj.Imeino = p2;
frmMobileNo = androidobj.BLLGetUseridAndroid(androidobj);
if (frmMobileNo == "" || frmMobileNo == null)
{
}
else
{
usrbalobj.usrMobileNo = p4;
usrbalobj.usrFirstName = p5;
usrbalobj.usrMiddleName = p6;
usrbalobj.usrLastName = p7;
usrbalobj.usrAddress = p8;
usrbalobj.Wardno = p9;
//p9=wardno
usrbalobj.usrPIN = p10;
usrbalobj.usrDOB = p11;
usrbalobj.UsrAge = Convert.ToInt32(p12);
usrbalobj.usrCarrerInterest = p13; //Job
//p14=Education
// usrbalobj.usrHighestQualification = Convert.ToInt32(p14); //Temp comment
usrbalobj.usrBestFeature = p15; //UID
usrbalobj.usrBuild = p16; //VID
usrbalobj.UsrSocialDesignation = p17; //Social Designation
//usrbalobj.Usrreligion = Convert.ToInt32(p18); //Religion //Temp comment
usrbalobj.usrCategory = p19; //Category
usrbalobj.Caste = p20;
usrbalobj.Joingroup = p21;
usrbalobj.Marriagedt = p22;
usrbalobj.Jobplace = p23;
usrbalobj.Votterlist = p24;
usrbalobj.usrEmailId = p25;
usrbalobj.Namevosotorlist = p26;
usrbalobj.RationCard = p27;
usrbalobj.OwnHouse = p28;
usrbalobj.Pancard = p29;
usrbalobj.SeniorCitizen = p30;
usrbalobj.RailwayPass = p31;
usrbalobj.Handicap = p32;
usrbalobj.AdharNidhi = p33;
usrbalobj.SAnjayGandhiYojana = p34;
usrbalobj.Anyscholorship = p35;
status = usrbalobj.BLLIsExistUserRegistrationInitial(usrbalobj);
if (status > 0)
{
usrbalobj.usrUserId = System.Guid.NewGuid().ToString();
Random rnd = new Random();
usrbalobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999)));
status = usrbalobj.BLLInsertSpecificUserRegistrationAndroid(usrbalobj);
if (status > 0)
{
string myPassword = cc.DESDecrypt(usrbalobj.usrPassword);
string message = "Welcome " + p5 + ", Your Password is " + myPassword + " www.myct.in";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("AndroidLongCode", p4, message, smslength);
}
}
else
{
}
andrdtoteli.GetMessageAndroidHead(frmMobileNo, p4);
//androidlocal.GetMessageAndroid(frmMobileNo,nullvalue,p4, p3);
}
}
else if (p3 == "MEMBER" || p3 == "FAMILY")
{
androidobj.Simno = p1;
androidobj.Imeino = p2;
frmMobileNo = androidobj.BLLGetUseridAndroid(androidobj);
if (frmMobileNo == "" || frmMobileNo == null)
{
}
else
{
string headmobile = p4;
usrbalobj.usrMobileNo = headmobile;
status = usrbalobj.BLLIsExistUserRegistrationInitial(usrbalobj);
if (status > 0)
{
string message = "Sorry,This MobileNo " + headmobile + " is not member of www.myct.in, So plz register first..!! ";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("AndroidLongCode", headmobile, message, smslength);
}
else
{
string relation = p5;
usrbalobj.usrMobileNo = p6;
usrbalobj.usrFirstName = p7;
usrbalobj.usrMiddleName = p8;
usrbalobj.usrLastName = p9;
usrbalobj.usrAddress = p10;
usrbalobj.Wardno = p11;
usrbalobj.usrPIN = p12;
usrbalobj.usrDOB = p13;
usrbalobj.UsrAge = Convert.ToInt32(p14);
usrbalobj.usrCarrerInterest = p15;
usrbalobj.usrBestFeature = p17;
usrbalobj.usrBuild = p18;
usrbalobj.UsrSocialDesignation = p19;
usrbalobj.Jobplace = p20;
usrbalobj.usrEmailId = p21;
usrbalobj.Namevosotorlist = p22;
usrbalobj.RationCard = p23;
usrbalobj.OwnHouse = p24;
usrbalobj.Pancard = p25;
usrbalobj.SeniorCitizen = p26;
usrbalobj.RailwayPass = p27;
usrbalobj.Handicap = p28;
usrbalobj.AdharNidhi = p29;
usrbalobj.SAnjayGandhiYojana = p30;
usrbalobj.Anyscholorship = p31;
status = usrbalobj.BLLIsExistUserRegistrationInitial(usrbalobj);
if (status > 0)
{
usrbalobj.usrUserId = System.Guid.NewGuid().ToString();
Random rnd = new Random();
usrbalobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999)));
status = usrbalobj.BLLInsertSpecificUserRegistrationAndroid(usrbalobj);
if (status > 0)
{
string myPassword = cc.DESDecrypt(usrbalobj.usrPassword);
string message = "Welcome " + p7 + ", Your Password is " + myPassword + ",";
message = message + "Now Your " + p5 + " of " + headmobile + " in www.myct.in";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("AndroidLongCode", p6, message, smslength);
}
}
else
{
string message = "Now Your " + p5 + " of " + headmobile + " in www.myct.in";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("LongCode", p6, message, smslength);
}
}
andrdtoteli.GetMessageAndroid(frmMobileNo, headmobile, p6, p5, p3);
//androidlocal.GetMessageAndroid(frmMobileNo,headmobile, p6, p5);
}
}
else if (p3 == "RELATIVE")
{
androidobj.Simno = p1;
androidobj.Imeino = p2;
frmMobileNo = androidobj.BLLGetUseridAndroid(androidobj);
if (frmMobileNo == "" || frmMobileNo == null)
{
}
else
{
string headmobile = p4;
usrbalobj.usrMobileNo = headmobile;
status = usrbalobj.BLLIsExistUserRegistrationInitial(usrbalobj);
if (status > 0)
{
string message = "Sorry,This MobileNo " + headmobile + " is not member of www.myct.in, So plz register first..!! ";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("LongCode", headmobile, message, smslength);
}
else
{
usrbalobj.usrMobileNo = p5;
usrbalobj.usrFirstName = p6;
usrbalobj.usrLastName = p7;
string relation = p8;
usrbalobj.usrAddress = p9;
status = usrbalobj.BLLIsExistUserRegistrationInitial(usrbalobj);
if (status == 0)
{
usrbalobj.usrUserId = System.Guid.NewGuid().ToString();
Random rnd = new Random();
usrbalobj.usrPassword = cc.DESEncrypt(Convert.ToString(rnd.Next(10001, 99999)));
status = usrbalobj.BLLInsertSpecificUserRegistrationAndroid(usrbalobj);
if (status > 0)
{
string myPassword = cc.DESDecrypt(usrbalobj.usrPassword);
string message = "Welcome " + p6 + ", Your Password is " + myPassword + ",";
message = message + "Now Your " + p8 + "of " + headmobile + " in www.myct.in";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("LongCode", p5, message, smslength);
}
}
else
{
string message = "Now Your " + p8 + " of " + headmobile + " in www.myct.in";
int smslength = message.Length;
//cc.SendMessageLongCodeSMS("LongCode", p5, message, smslength);
}
}
andrdtoteli.GetMessageAndroid(frmMobileNo, headmobile, p5, p8, p3);
//androidlocal.GetMessageAndroid(frmMobileNo,headmobile, p6, p5);
}
}
}
}
}
catch (Exception ex)
{
}
}
protected void btnFileRead_Click(object sender, EventArgs e)
{
try
{
string thisDir = Server.MapPath("~");
string epath = thisDir + "\\MarketingExcel\\" + Convert.ToString(Session["MarketingUser"]) + "\\";
string Name = epath + Convert.ToString(Session["MarketingUser"]);
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
Microsoft.Office.Interop.Excel.Range range;
DataTable dt = new DataTable();
dt.Columns.Add("fName");
dt.Columns.Add("lName");
dt.Columns.Add("mobileNo");
dt.Columns.Add("pinNo");
DataTable dt1 = new DataTable();
dt1.Columns.Add("fName");
dt1.Columns.Add("lName");
dt1.Columns.Add("mobileNo");
dt1.Columns.Add("pinNo");
xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Open(Name, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
int index = 0;
object rowIndex = 2;
while (((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 1]).Value2 != null)
{
urUserRegBLLObj.usrFirstName = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 2]).Value2);
urUserRegBLLObj.usrLastName = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 3]).Value2);
urUserRegBLLObj.usrMobileNo = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 4]).Value2);
urUserRegBLLObj.usrPIN = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 5]).Value2);
urUserRegBLLObj.usrAddress = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[rowIndex, 6]).Value2);
urUserRegBLLObj.usrCityId = Convert.ToInt32(Session["CityIdN"]);
urUserRegBLLObj.frnrelGroup = "1";
string mobNo = urUserRegBLLObj.usrMobileNo;
int count = Convert.ToInt32(mobNo.Length);
if (urUserRegBLLObj.usrFirstName != "")
{
if (urUserRegBLLObj.usrLastName != "")
{
if (count == 10)
{
status = urUserRegBLLObj.BLLIsExistUserRegistrationInitial(urUserRegBLLObj);
if (status > 0)
{
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)
{
DataRow drN;
drN = dt.NewRow();
string fName = Convert.ToString(urUserRegBLLObj.usrFirstName);
string lName = Convert.ToString(urUserRegBLLObj.usrLastName);
string mobileNo = Convert.ToString(urUserRegBLLObj.usrMobileNo);
string pinNo = Convert.ToString(urUserRegBLLObj.usrPIN);
drN[0] = fName;
drN[1] = lName;
drN[2] = mobileNo;
drN[3] = pinNo;
dt.Rows.Add(drN);
gvUserRegistered.DataSource = dt;
gvUserRegistered.DataBind();
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
urUserRegBLLObj.frnrelFriendId = urUserRegBLLObj.usrUserId;
urUserRegBLLObj.frnrelFrnRelName = Convert.ToString(urUserRegBLLObj.usrFirstName + " " + urUserRegBLLObj.usrLastName);
int frcount = urUserRegBLLObj.BLLInsertUserFriendRelative(urUserRegBLLObj);
if (frcount > 0)
{
usrFrndRelSms(urUserRegBLLObj.usrMobileNo);
}
}
}
else
{
DataRow drN;
drN = dt1.NewRow();
string fName = Convert.ToString(urUserRegBLLObj.usrFirstName);
string lName = Convert.ToString(urUserRegBLLObj.usrLastName);
string mobileNo = Convert.ToString(urUserRegBLLObj.usrMobileNo);
string pinNo = Convert.ToString(urUserRegBLLObj.usrPIN);
drN[0] = fName;
drN[1] = lName;
drN[2] = mobileNo;
drN[3] = pinNo;
dt1.Rows.Add(drN);
gvUserAlreadyRegistered.DataSource = dt1;
gvUserAlreadyRegistered.DataBind();
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Mobile No should Be 10 Digits for Mob NO.:" + mobNo + "')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Eneter the Last Name of Mobile No :" + mobNo + "')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Eneter the First Name of Mobile No :" + mobNo + "')", true);
}
index++;
rowIndex = 2 + index;
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
}
catch (Exception ex)
{
throw ex;
//string msg = ex.Message;
//Response.Write(ex.Message);
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Eneter the First Name of Mobile No ')", true);
}
}
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;
}
}