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