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