protected void Page_Load(object sender, EventArgs e)
{
string RequestUrl = Request.ServerVariables["SERVER_NAME"].ToLower();
//根据域名读取商户ID,如果没有绑定域名直接跳转后台
comid = GeneralFunc.GetComid(RequestUrl);
}
bool isGoUP = false; // 上方向に移動中かどうか
// Use this for initialization
void Start()
{
generalFunc = new GeneralFunc();
// 上下どちらに移動するか決定
isGoUP = generalFunc.RandomBool();
}
// Use this for initialization
void Start()
{
generalFunc = new GeneralFunc();
// スプライトレンダラ取得
// 画像の左右反転に使用する
spRender = GetComponent <SpriteRenderer>();
// ボートの向きをランダムに決める
isLeft = generalFunc.RandomBool();
spRender.flipX = isLeft;
}
public void SpawnPlayer(ActorPeer peer)
{
IActor player = new IActor()
{
actorType = (byte)ActorType.Player,
peerID = peer.playerID,
actorID = AllocateActorId(),
posX = 10,
posY = 10
};
ListPlayer.Add(player);
//#region Test Code
////List<MPlayer> listTest = new List<MPlayer>()
////{
//// new MPlayer() { id = 1,name = "duc anh"},
//// new MPlayer() {id = 2, name = "hoang anh"}
////};
//EventData evtData = new EventData()
//{
// Code = (byte)AckEventType.CreateActor,
// Parameters = new Dictionary<byte, object>()
// {
// {(byte)ActorType.Creep, GeneralFunc.Serialize(listCreep)}
// }
//};
//peer.SendEvent(evtData, new SendParameters());
//#endregion
Region startRegion = Region.GetRegionFromPosition(player);
Console.WriteLine("aaaaaaaaaaaaaaaaaaaaaaa");
startRegion.ActorEnter(player);
EventData evtPlayer = new EventData()
{
Code = (byte)AckEventType.AssignPlayerID,
Parameters = new Dictionary <byte, object>()
{
{ 0, GeneralFunc.Serialize(player) }
}
};
peer.SendEvent(evtPlayer, new SendParameters());
}
public static void SaveOfferPageVisit()
{
String strHostName = HttpContext.Current.Request.UserHostAddress.ToString();
String ReturningURL = string.Empty;
if (HttpContext.Current.Request.UrlReferrer != null)
{
ReturningURL = HttpContext.Current.Request.UrlReferrer.OriginalString.ToString();
}
string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
string CurrentPage = HttpContext.Current.Request.Url.AbsoluteUri;
GeneralFunc.SaveOfferPageVisits(strIp, ReturningURL, CurrentPage);
}
private void DeletePeerToOther(IActor player, List <IActor> listPlayerInRegion)
{
foreach (var playerInRegion in listPlayerInRegion)
{
ActorPeer actorPeer = ServerArena.Instance.ListPeer.Where(a => a.playerID == playerInRegion.actorID).FirstOrDefault();
if (actorPeer != null)
{
EventData evtOtherPlayer = new EventData()
{
Code = (byte)AckEventType.DestroyActor,
Parameters = new Dictionary <byte, object>()
{
{ (byte)Parameter.Data, GeneralFunc.Serialize(player) }
}
};
actorPeer.SendEvent(evtOtherPlayer, new SendParameters());
}
}
}
private void DisplayData()
{
var fileList = GeneralFunc.GetAllFile();
//checkBoxes = new CheckBox[0];
for (int i = 0; i < fileList.Count(); i++)
{
var checkBox = new CheckBox(this);
checkBox.Text = fileList[i].ST_filename;
checkBox.Id = i;
checkBox.LayoutParameters = new ViewGroup.LayoutParams(LinearLayout.LayoutParams.WrapContent, LinearLayout.LayoutParams.WrapContent);
checkBox.CheckedChange += CheckBox_CheckedChange;
//Array.Resize(ref checkBoxes, i + 1);
//checkBoxes[i] = checkBox;
linearLayoutClear.AddView(checkBox);
}
}
private void SendNewPeerToTheOthers(IActor player, List <IActor> listPlayerInRegion)
{
List <IActor> listOnePlayer = new List <IActor>();
listOnePlayer.Add(player);
foreach (var playerInRegion in listPlayerInRegion)
{
ActorPeer actorPeer = ServerArena.Instance.ListPeer.Where(a => a.playerID == playerInRegion.actorID).FirstOrDefault();
if (actorPeer != null)
{
EventData evtOtherPlayer = new EventData()
{
Code = (byte)AckEventType.CreateActor,
Parameters = new Dictionary <byte, object>()
{
{ (byte)ActorType.Player, GeneralFunc.Serialize(listOnePlayer) }
}
};
actorPeer.SendEvent(evtOtherPlayer, new SendParameters());
}
}
}
public static string DateFormat(string strFormat)
{
DateTime Date;
if (strFormat != "")
{
if (GeneralFunc.ValidateDate(strFormat.ToString()))
{
Date = Convert.ToDateTime(strFormat.ToString());
strFormat = String.Format("{0:MMM dd, yyyy}", Date);
//strFormat = Date.GetDateTimeFormats().GetValue(8).ToString() ;
return(strFormat.ToString());
}
else
{
return(strFormat);
}
}
else
{
return(strFormat);
}
}
public void ProcessRequest(ActorPeer sender, OperationRequest operationRequest, SendParameters sendParameters)
{
if (operationRequest.OperationCode == (byte)AckRequestType.MoveCommand)
{
Movement movement = GeneralFunc.Deserialize <Movement>(operationRequest.Parameters[(byte)Parameter.Data] as byte[]);
// find actor
IActor player = (ListPlayer.Find(pl => pl.actorID == movement.actorID));
Region oldRegion = Region.GetRegionFromPosition(player);
player.posX = movement.posX;
player.posY = movement.posY;
Region newRegion = Region.GetRegionFromPosition(player);
if (oldRegion != newRegion)
{
oldRegion.ActorExit(player);
newRegion.ActorEnter(player);
}
}
}
private void SendNewInfoToPeer(ActorPeer peer, IActor player)
{
List <IActor> listPlayerInRegion = new List <IActor>();
List <IActor> listCreepInRegion = new List <IActor>();
List <Region> listInterestRegion = GetInterestRegion();
foreach (var region in listInterestRegion)
{
listPlayerInRegion.AddRange(region.listPlayer);
listCreepInRegion.AddRange(region.listCreep);
}
listPlayerInRegion.Remove(player);
InterestRegions dataInterest = GetDataInterestRegion(listInterestRegion);
dataInterest.playerPosition = new MPosition()
{
x = player.posX,
y = player.posY
};
EventData evtDataCrrepAndOtherPlayers = new EventData()
{
Code = (byte)AckEventType.CreateActor,
Parameters = new Dictionary <byte, object>()
{
{ (byte)Parameter.Player, GeneralFunc.Serialize(listPlayerInRegion) },
{ (byte)Parameter.Creep, GeneralFunc.Serialize(listCreepInRegion) },
{ (byte)Parameter.Regions, GeneralFunc.Serialize(dataInterest) }
}
};
peer.SendEvent(evtDataCrrepAndOtherPlayers, new SendParameters());
}
private Vector3 scanAround(Vector3 center)
{
Vector3 ans = Vector3.zero, tmp = center;
RaycastHit hit;
Collider[] scanOverlap = new Collider[3];
Vector3[] scanPosDelta = new Vector3[8];
scanPosDelta[0].Set(0, 0, scanScale);
scanPosDelta[1].Set(0, 0, -scanScale);
scanPosDelta[2].Set(scanScale, 0, 0);
scanPosDelta[3].Set(-scanScale, 0, 0);
scanPosDelta[4].Set(scanScale, 0, scanScale);
scanPosDelta[5].Set(scanScale, 0, -scanScale);
scanPosDelta[6].Set(-scanScale, 0, scanScale);
scanPosDelta[7].Set(-scanScale, 0, -scanScale);
Vector3 scanCenterDelta = new Vector3(0, enemyBounds.size.y / 2, 0); //掃描下方有無地板的碰撞體中心
//---------------------------
//scanText.text = "collide " + FirstPersonCamera.transform.position + "\n";
//---------------------------
for (int i = 0; i < scanPosDelta.Length; i++)
{
GeneralFunc.Swap <Vector3>(ref scanPosDelta[i], ref scanPosDelta[UnityEngine.Random.Range(0, scanPosDelta.Length)]);
}
foreach (Vector3 delta in scanPosDelta)
{
tmp = center + delta;
//scanText.text += tmp + " : ";
if (Physics.Raycast(tmp, FirstPersonCamera.transform.position - tmp, out hit, 100))
{
//scanText.text += hit.transform.tag + "\n"; //test
if (hit.transform.tag == Constants.tagPlayer)
{
//scanText.text += Physics.OverlapSphereNonAlloc(tmp, 0.3f, scanOverlap) + "\n"; //test
//檢測座標周圍是否直接卡到碰撞體內，提高掃描中心至敵人模型高度的25%位置，掃描半身範圍的圓球內有無碰撞
if (Physics.OverlapSphereNonAlloc(tmp + (scanCenterDelta / 2), (enemyBounds.size.y / 4), scanOverlap) == 0)
{
//檢測座標正下方有無地板，有地板才生成
if (Physics.Raycast(tmp, Vector3.down, out hit, enemyBounds.extents.y))
{
RaycastHit[] hits = new RaycastHit[4];
Physics.Raycast(tmp + new Vector3(enemyBounds.extents.x / 2f, 0, enemyBounds.extents.z / 2f), Vector3.down, out hits[0], enemyBounds.extents.y);
Physics.Raycast(tmp + new Vector3(-enemyBounds.extents.x / 2f, 0, enemyBounds.extents.z / 2f), Vector3.down, out hits[1], enemyBounds.extents.y);
Physics.Raycast(tmp + new Vector3(enemyBounds.extents.x / 2f, 0, -enemyBounds.extents.z / 2f), Vector3.down, out hits[2], enemyBounds.extents.y);
Physics.Raycast(tmp + new Vector3(-enemyBounds.extents.x / 2f, 0, -enemyBounds.extents.z / 2f), Vector3.down, out hits[3], enemyBounds.extents.y);
int sucessPoint = 0;
float avgDistance = 0, minDistance = 0;
for (int scanCnt = 0; scanCnt < hits.Length; scanCnt++)
{
if (hits[scanCnt].transform?.tag == Constants.tagARCollider)
{
sucessPoint++;
float distance = Mathf.Abs(tmp.y - hits[scanCnt].point.y); //只算垂直距離
//Debug.Log(distance);
avgDistance += distance;
if (distance < minDistance)
{
minDistance = distance;
}
}
}
avgDistance /= sucessPoint; //計算平均距離
if (sucessPoint >= hits.Length - 1 && (avgDistance - minDistance) <= 0.4f) //必須通過3個點，且平均值-最小值誤差<0.4才可生成(無大的高低落差)
{
ans = tmp;
return(ans); //直接中斷送出目標位置點
}
}
}
}
}
}
return(ans);
}
protected void Page_Load(object sender, EventArgs e)
{
Email = Request["Email"].ConvertTo <string>("");
//获得comid：为0则进入登录页面；非0则进入下面流程
string RequestUrl = Request.ServerVariables["SERVER_NAME"].ToLower();
comid = GeneralFunc.GetComid(RequestUrl);
if (comid == 0)
{
return;
}
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "RequestUrl:" + RequestUrl);
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "comid:" + comid);
//以下3个参数用于获取微信号，并且通过判断实现手机分销系统免登陆
string code = Request["code"].ConvertTo <string>("");
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "code:" + code);
string openid = Request["openid"].ConvertTo <string>("");
string weixinpass = Request["weixinpass"].ConvertTo <string>("");
//如果3个参数都为空，则进入登录页面
if (code == "" && openid == "" && weixinpass == "")
{
return;
}
//如果以上3个参数中有参数传递过来，则进入手机分销系统免登陆判断
if (code != "")//根据微信端code获取微信号
{
openid = GetOpenId(code, comid);
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "openid:" + openid);
}
else//根据微信一次性密码获取微信号
{
if (openid != "" && weixinpass != "")//微信端发送来的请求
{
bool isavailable = VerifyOneOffPass(openid, weixinpass);
if (isavailable == false)
{
//微信一次性密码失效，判断传递过来的openid 和 客户端cookie中openid 是否相同（防止转发）:相同直接免登陆进入手机分销后台；否则进入登录手机分销页面
HttpCookie cookie = Request.Cookies["openid"];
if (cookie != null)
{
string cookieValue = cookie.Value;
if (cookieValue != openid)
{
openid = "";
}
}
//else { openid = openid; } //微信一次性密,可以不操作
}
//else { openid = openid; } //传递过来的openid 和 客户端cookie中openid相符,可以不操作
}
else//非微信端发送来的请求，需要进入登录页面
{
openid = "";
}
}
if (openid != "")//如果微信号 获取成功，则获取当前微信号 微信免登陆 对应的分销商:有则免登陆；没有则需要登录
{
Agent_company freelandingagentuser = new AgentCompanyData().GetFreeLandingAgentUserByOpenId(openid);
if (freelandingagentuser != null)
{
Session["Agentid"] = freelandingagentuser.Id;//分销公司id，并不是分销员工id
Session["Account"] = freelandingagentuser.Account;
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "agentid:" + freelandingagentuser.Id + ",account:" + freelandingagentuser.Account);
HttpCookie cookie = new HttpCookie("Agentid"); //实例化HttpCookie类并添加值
cookie.Value = freelandingagentuser.Id.ToString(); //分销公司id，并不是分销员工id
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
var returnmd5 = EncryptionHelper.ToMD5(freelandingagentuser.Account + "lixh1210" + freelandingagentuser.Id.ToString(), "UTF-8");
cookie = new HttpCookie("AgentKey"); //实例化HttpCookie类并添加值
cookie.Value = returnmd5;
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
cookie = new HttpCookie("Account"); //分销账户
cookie.Value = freelandingagentuser.Account;
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
Response.Redirect("default.aspx");
}
}
}
public List <UserRegistrationInfo> UpdateUserRegistration(string name, string address, string city, string stateID, string zip, string phone, string UID,
string businessName, string altEmail, string altPhone, string AuthenticationID, string CustomerID, string SessionID)
{
MobileBL objUserRegBL = new MobileBL();
var obj = new List <UserRegistrationInfo>();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("UpdateUserRegistration", CustomerID, AuthenticationID, UID);
}
bool bnew = objMobileBL.CheckMobileAuthorizeUSer(SessionID, Convert.ToInt32(UID));
if (bnew)
{
try
{
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
UserRegistrationInfo objUserInfo = new UserRegistrationInfo();
objUserInfo.Name = GeneralFunc.ToProper(name).Trim();
objUserInfo.Address = GeneralFunc.ToProper(address).Trim();
objUserInfo.City = GeneralFunc.ToProper(city).Trim();
objUserInfo.StateID = Convert.ToInt32(stateID);
if (zip.Length == 4)
{
objUserInfo.Zip = "0" + zip;
}
else
{
objUserInfo.Zip = zip;
}
objUserInfo.PhoneNumber = phone;
objUserInfo.UId = Convert.ToInt32(UID);
objUserInfo.BusinessName = businessName;
objUserInfo.AltEmail = altEmail;
objUserInfo.AltPhone = altPhone;
DataSet dsCarDetailsInfo = new DataSet();
dsCarDetailsInfo = objUserRegBL.USP_UpdateRegUserDetails(objUserInfo);
if (dsCarDetailsInfo.Tables.Count > 0)
{
if (dsCarDetailsInfo.Tables[0].Rows.Count > 0)
{
UserRegistrationInfo objInfo = new UserRegistrationInfo();
objInfo.AASuccess = "Success";
objInfo.Address = dsCarDetailsInfo.Tables[0].Rows[0]["Address"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Address"].ToString();
objInfo.AltEmail = dsCarDetailsInfo.Tables[0].Rows[0]["AltEmail"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["AltEmail"].ToString();
objInfo.AltPhone = dsCarDetailsInfo.Tables[0].Rows[0]["AltPhone"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["AltPhone"].ToString();
objInfo.BusinessName = dsCarDetailsInfo.Tables[0].Rows[0]["BusinessName"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["BusinessName"].ToString();
objInfo.City = dsCarDetailsInfo.Tables[0].Rows[0]["City"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["City"].ToString();
objInfo.CouponCode = dsCarDetailsInfo.Tables[0].Rows[0]["CouponCode"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["CouponCode"].ToString();
objInfo.CreatedDate = dsCarDetailsInfo.Tables[0].Rows[0]["CreatedDate"].ToString() == "" ? Convert.ToDateTime("1/1/1990") : Convert.ToDateTime(dsCarDetailsInfo.Tables[0].Rows[0]["CreatedDate"].ToString());
objInfo.Name = dsCarDetailsInfo.Tables[0].Rows[0]["Name"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Name"].ToString();
objInfo.PhoneNumber = dsCarDetailsInfo.Tables[0].Rows[0]["PhoneNumber"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["PhoneNumber"].ToString();
objInfo.SellerID = dsCarDetailsInfo.Tables[0].Rows[0]["sellerID"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["sellerID"].ToString());
objInfo.StateID = dsCarDetailsInfo.Tables[0].Rows[0]["StateID"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["StateID"].ToString());
objInfo.StateName = dsCarDetailsInfo.Tables[0].Rows[0]["State_Code"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["State_Code"].ToString();
objInfo.UId = dsCarDetailsInfo.Tables[0].Rows[0]["UId"].ToString() == "" ? 0 : Convert.ToInt32(dsCarDetailsInfo.Tables[0].Rows[0]["UId"].ToString());
objInfo.UserName = dsCarDetailsInfo.Tables[0].Rows[0]["UserName"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["UserName"].ToString();
objInfo.Zip = dsCarDetailsInfo.Tables[0].Rows[0]["Zip"].ToString() == "" ? "Emp" : dsCarDetailsInfo.Tables[0].Rows[0]["Zip"].ToString();
obj.Add(objInfo);
}
}
}
}
catch (Exception ex)
{
}
}
else
{
UserRegistrationInfo objUserInfo = new UserRegistrationInfo();
objUserInfo.AASuccess = "Session timed out";
obj.Add(objUserInfo);
}
return(obj);
}
private void ReadExcelData(string sFileName)
{
ArrayList RowNo = new ArrayList();
ArrayList ColNo = new ArrayList();
ArrayList SArray = new ArrayList();
LeadsBL objLeadsBL = new LeadsBL();
ExcelReading objExcelData = new ExcelReading();
DataSet ds = new DataSet();
DataSet dsStatus = new DataSet();
DataSet dsSales = new DataSet();
bool bnew = false;
try
{
lblErrorMsg.Text = "";
ds = objExcelData.GetLeadsExcelToDataset(sFileName);
DataSet dsError = new DataSet();
dsError.Tables.Add();
dsError.Tables["Table1"].Columns.Add("PhoneNo");
dsError.Tables["Table1"].Columns.Add("RowNo");
dsError.Tables["Table1"].Columns.Add("Error");
if (ds.Tables[0].Columns.Contains("PhoneNo") && ds.Tables[0].Columns.Contains("Price") &&
ds.Tables[0].Columns.Contains("Header") &&
ds.Tables[0].Columns.Contains("Description") && (ds.Tables[0].Columns.Contains("URL") || ds.Tables[0].Columns.Contains("City")) &&
ds.Tables[0].Columns.Contains("State") && ds.Tables[0].Columns.Contains("Lead_Date") &&
ds.Tables[0].Columns.Contains("Make") &&
ds.Tables[0].Columns.Contains("Model") &&
ds.Tables[0].Columns.Contains("Email") &&
ds.Tables[0].Columns.Contains("Year") &&
ds.Tables[0].Columns.Contains("VehicleType"))
{
int count = objExcelData.GetExcelDistictBTNCOunt_Sales(sFileName);
ViewState["Count"] = count.ToString();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 8000)
{
lblErrorMsg.Text = "Upload Only 8000 rows Only!";
return;
}
else if (Convert.ToInt32(txtNoofRecords.Text) != Convert.ToInt32(ds.Tables[0].Rows.Count))
{
lblErrorMsg.Text = "Records Count Does Not Match!";
return;
}
if (ds.Tables[0].Rows.Count == count)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//return;
//RowNo.Add(i);
if (ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim() == "" ||
ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim().Length != 10 ||
!GeneralFunc.IsNumeric(ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid phone number in the excel sheet";
}
//else if (ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim().Length != 10)
//{
// dsError.Tables["Table1"].Rows.Add();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid phone number in the excel sheet";
//}
//else if (!GeneralFunc.IsNumeric(ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim()))
//{
// dsError.Tables["Table1"].Rows.Add();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid phone number in the excel sheet";
//}
else if (CheckBTN(ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Phone number already exists in database.";
}
else
{
if (ds.Tables[0].Rows[i]["STATE"].ToString().Trim() == "" ||
ds.Tables[0].Rows[i]["STATE"].ToString().Trim().Length != 2 ||
ds.Tables[0].Rows[i]["STATE"].ToString().Trim() == null)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter the state code in the excel sheet";
}
//else if (ds.Tables[0].Rows[i]["STATE"].ToString().Trim().Length != 2)
//{
// dsError.Tables["Table1"].Rows.Add();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Phoneno"] = ds.Tables[0].Rows[i]["Phoneno"].ToString().Trim();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter the proper state code in the excel Sheet";
//}
//if (ds.Tables[0].Rows[i]["STATE"].ToString().Trim() == null)
//{
// dsError.Tables["Table1"].Rows.Add();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Error in record state code is not valid..";
//}
else if (ds.Tables[0].Rows[i]["STATE"].ToString().Trim().Length == 2)
{
string Stateid = GetStateId(ds.Tables[0].Rows[i]["STATE"].ToString().Trim().ToUpper());
if (Stateid == "0")
{
btnUpload.Text = "Upload";
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please check the record in the sheet, state is invalid.";
ColNo.Add(12);
}
}
//if (ds.Tables[0].Rows[i]["Price"].ToString().Trim().Length < 0)
//{
// dsError.Tables["Table1"].Rows.Add();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
// dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter price in the excel sheet";
//}
if (ds.Tables[0].Rows[i]["Price"].ToString().Trim() != "")
{
if (!GeneralFunc.IsNumeric(ds.Tables[0].Rows[i]["Price"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter numeric price in the excel sheet";
}
}
if (ds.Tables[0].Rows[i]["Lead_Date"].ToString().Trim() == "")
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter lead date in the excel sheet";
}
else if (!GeneralFunc.ValidateDate(ds.Tables[0].Rows[i]["Lead_Date"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid lead date in the excel sheet";
}
else
{
DataSet dsDatetime = objHotLeadBL.GetDatetime();
DateTime dtNow = Convert.ToDateTime(dsDatetime.Tables[0].Rows[0]["Datetime"].ToString());
if (Convert.ToDateTime(ds.Tables[0].Rows[i]["Lead_Date"].ToString().Trim()) > dtNow)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Lead date cannot be greater than today date";
}
}
if (ds.Tables[0].Rows[i]["Email"].ToString().Trim() != "")
{
if (!GeneralFunc.isEmail(ds.Tables[0].Rows[i]["Email"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid email in the excel sheet";
}
}
if (ds.Tables[0].Rows[i]["Year"].ToString().Trim() != "")
{
if (!GeneralFunc.IsNumeric(ds.Tables[0].Rows[i]["Year"].ToString().Trim()))
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid year in the excel sheet";
}
else if (ds.Tables[0].Rows[i]["Year"].ToString().Trim().Length != 4)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid year in the excel sheet";
}
else
{
DataSet dsDatetime = objHotLeadBL.GetDatetime();
DateTime dtNow = Convert.ToDateTime(dsDatetime.Tables[0].Rows[0]["Datetime"].ToString());
DateTime EnterDate = Convert.ToDateTime("1/1/" + ds.Tables[0].Rows[i]["Year"].ToString().Trim());
if (EnterDate > dtNow)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please enter valid year in the excel sheet";
}
}
}
}
VehicleTypeBL objVehicleTypeBL = new VehicleTypeBL();
DataSet dsVehicleTypes = new DataSet();
if (Cache["VehicleType"] == null)
{
dsVehicleTypes = objVehicleTypeBL.GetVehicleType();
Cache["VehicleType"] = dsVehicleTypes;
}
else
{
dsVehicleTypes = (DataSet)Cache["VehicleType"];
}
int cint = 0;
foreach (DataRow row in dsVehicleTypes.Tables[0].Rows) // Loop over the rows.
{
if (row.ItemArray[0].ToString().ToLower() == ds.Tables[0].Rows[i]["VehicleType"].ToString().Trim().ToLower())
{
cint = cint + 1;
break;
}
}
if (cint == 0)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please Enter Proper Vehicle Type";
}
cint = 0;
LeadSourceBL objLeadSourceBL = new LeadSourceBL();
DataSet dsLeadSource = new DataSet();
if (Cache["LeadSource"] == null)
{
dsLeadSource = objLeadSourceBL.GetLeadSources();
Cache["LeadSource"] = dsVehicleTypes;
}
else
{
dsLeadSource = (DataSet)Cache["LeadSource"];
}
foreach (DataRow row in dsLeadSource.Tables[0].Rows) // Loop over the rows.
{
if (row.ItemArray[0].ToString().ToLower() == ds.Tables[0].Rows[i]["LeadSourceID"].ToString().Trim().ToLower())
{
cint = cint + 1;
break;
}
}
if (cint == 0)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (i + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Please Enter Proper Lead Source ID";
}
}
if (dsError.Tables["Table1"].Rows.Count > 0)
{
grdIntroInfo.DataSource = null;
grdIntroInfo.DataBind();
grdErrors.DataSource = dsError.Tables["Table1"].DefaultView;
grdErrors.DataBind();
Header.Visible = false;
}
else
{
grdErrors.DataSource = null;
grdErrors.DataBind();
Header.Visible = true;
grdIntroInfo.DataSource = ds.Tables["XLData"].DefaultView;
grdIntroInfo.DataBind();
btnSubmit.Enabled = false;;
btnUpload.Enabled = true;
}
}
else
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
int phoneCount = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[j]["PhoneNo"].ToString() == ds.Tables[0].Rows[i]["PhoneNo"].ToString())
{
phoneCount = phoneCount + 1;
if (phoneCount > 1)
{
dsError.Tables["Table1"].Rows.Add();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["PhoneNo"] = ds.Tables[0].Rows[i]["PhoneNo"].ToString().Trim();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["RowNo"] = (j + 1).ToString();
dsError.Tables["Table1"].Rows[dsError.Tables["Table1"].Rows.Count - 1]["Error"] = "Exist Duplicates PhoneNo In Excel Sheet Plz Check Excel Sheet";
}
ColNo.Add(8);
}
}
}
if (dsError.Tables["Table1"].Rows.Count > 0)
{
grdIntroInfo.DataSource = null;
grdIntroInfo.DataBind();
grdErrors.DataSource = dsError.Tables["Table1"].DefaultView;
grdErrors.DataBind();
Header.Visible = false;
}
}
}
}
else
{
btnUpload.Text = "Upload";
lblErrorMsg.Text = "Enter Valid Sales Excel Sheet Proper Columns.";
btnSubmit.Enabled = true;
}
}
catch (Exception ex)
{
if (ex.Message.ToString() == "Not a legal OleAut date.")
{
Header.Visible = false;
lblErrorMsg.Text = "Enter valid date format in excel sheet";
}
else
{
throw ex;
}
}
}
public void OnEvent(EventData eventData)
{
Debug.Log((AckEventType)eventData.Code);
//server raised an event
switch ((AckEventType)eventData.Code)
{
// store player ID
case AckEventType.AssignPlayerID:
IActor player = GeneralFunc.Deserialize <IActor>(eventData.Parameters[0] as byte[]);
GameActor playerCreated = Instantiate
(
playerPref,
new Vector3(player.posX, 0.5f, player.posY),
playerPref.transform.rotation
) as GameActor;
playerCreated.SetActor(player);
playerCreated.GetComponent <OwnerInfo>().SetOwnerID(player.peerID);
StarCollectorClient.playerID = player.peerID;
playerCreated.GetComponent <CheckRegion>().Load();
break;
// create actor
case AckEventType.CreateActor:
if (eventData.Parameters.ContainsKey((byte)Parameter.Creep))
{
List <IActor> listAllCreep = GeneralFunc.Deserialize <List <IActor> >(eventData.Parameters[(byte)Parameter.Creep] as byte[]);
Debug.Log("count all creep :" + listAllCreep.Count);
List <IActor> listSameCreep = GetListSameActor(listAllCreep, GameActor.listCreep);
List <IActor> listNewCreep = listAllCreep.Except(listSameCreep).ToList();
List <GameActor> listDeleteCreep = GameActor.listCreep.Where(a => !listAllCreep.Any(b => b.actorID == a.actor.actorID)).ToList();
foreach (var creepDelete in listDeleteCreep)
{
creepDelete.Destruct();
}
foreach (var creep in listNewCreep)
{
GameActor creepCreated = Instantiate(creepPref, new Vector3(creep.posX, 0.5f, creep.posY), playerPref.transform.rotation) as GameActor;
creepCreated.SetActor(creep);
creepCreated.GetComponent <CheckRegion>().Load();
}
}
if (eventData.Parameters.ContainsKey((byte)Parameter.Regions))
{
InterestRegions dataInterestRegion = GeneralFunc.Deserialize <InterestRegions>(eventData.Parameters[(byte)Parameter.Regions] as byte[]);
if (dataInterestRegion.playerPosition != null)
{
Debug.Log(string.Format("player position -------------- x: {0} - y: {1}", dataInterestRegion.playerPosition.x, dataInterestRegion.playerPosition.y));
}
//foreach (var data in dataInterestRegion.listRegion)
//{
// Debug.Log(string.Format("x: {0} - y: {1}",data.x,data.y));
//}
AreaController.Instance.ShowInterestRegion(dataInterestRegion.listRegion);
}
break;
case AckEventType.DestroyActor:
if (eventData.Parameters.ContainsKey((byte)Parameter.Data))
{
IActor playerDestroy = GeneralFunc.Deserialize <IActor>(eventData.Parameters[(byte)Parameter.Data] as byte[]);
GameActor gameActorDestroy = GameActor.listPlayer.Where(a => a.actor.actorID == playerDestroy.actorID).FirstOrDefault();
if (gameActorDestroy != null)
{
gameActorDestroy.Destruct();
}
}
break;
// log chat messages
case AckEventType.ChatMessage:
break;
}
}
protected void btnSubscribe_Click(object sender, EventArgs e)
{
mpesubscribe.Hide();
PreferencesBL objPreferencesBL = new PreferencesBL();
DataSet dssub = new DataSet();
PreferenceInfo ObjPreferncesInfo = new PreferenceInfo();
PreferncesItemsInfo ObjPreferncesItemsInfo = new PreferncesItemsInfo();
ObjPreferncesInfo.PreferenceID = "0";
ObjPreferncesInfo.Zip = txtZip.Text;
ObjPreferncesInfo.Name = txtName.Text;
if (txtEmailAlert.Text != "Your Email")
{
ObjPreferncesInfo.Email = txtEmailAlert.Text;
}
if (txtPhoneNo.Text != "Your Phone")
{
ObjPreferncesInfo.Phone = txtPhoneNo.Text;
}
String strHostName = HttpContext.Current.Request.UserHostAddress.ToString();
ObjPreferncesInfo.IPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
if (Request.Cookies["UserSettings"] == null)
{
HttpCookie myCookie = new HttpCookie("UserSettings");
myCookie.Expires = DateTime.Now.AddDays(500);
myCookie.Values.Add("Email", ObjPreferncesInfo.Email);
myCookie.Values.Add("Name", ObjPreferncesInfo.Name);
myCookie.Values.Add("Phone", ObjPreferncesInfo.Phone);
Response.Cookies.Add(myCookie);
}
ObjPreferncesItemsInfo.Makeid = ddlMake1.SelectedValue;
ObjPreferncesItemsInfo.ModelID = ddlModel1.SelectedValue;
ObjPreferncesItemsInfo.PriceRange = ddlRange1.SelectedValue;
DataSet dsEmailExist = new DataSet();
DataSet dsPreferences = new DataSet();
dsEmailExist = objPreferencesBL.GetEmailPreferencesbyEmail(txtEmailAlert.Text);
if (dsEmailExist.Tables[0].Rows.Count == 0)
{
dsPreferences = objPreferencesBL.SaveSubscribe(ObjPreferncesInfo, 1);
for (int i = 1; i < 6; i++)
{
string SelectedMake = string.Empty;
string SelectedModel = string.Empty;
string SelectedRange = string.Empty;
if (i == 1)
{
SelectedMake = ddlMake1.SelectedValue;
SelectedModel = ddlModel1.SelectedValue;
SelectedRange = ddlRange1.SelectedValue;
}
else if (i == 2)
{
SelectedMake = ddlMake2.SelectedValue;
SelectedModel = ddlModel2.SelectedValue;
SelectedRange = ddlRange2.SelectedValue;
}
else if (i == 3)
{
SelectedMake = ddlMake3.SelectedValue;
SelectedModel = ddlModel3.SelectedValue;
SelectedRange = ddlRange3.SelectedValue;
}
else if (i == 4)
{
SelectedMake = ddlMake4.SelectedValue;
SelectedModel = ddlModel4.SelectedValue;
SelectedRange = ddlRange4.SelectedValue;
}
else if (i == 5)
{
SelectedMake = ddlMake5.SelectedValue;
SelectedModel = ddlModel5.SelectedValue;
SelectedRange = ddlRange5.SelectedValue;
}
if (SelectedMake != "0" && SelectedModel != "0")
{
ObjPreferncesItemsInfo.Makeid = SelectedMake;
ObjPreferncesItemsInfo.ModelID = SelectedModel;
ObjPreferncesItemsInfo.PreferenceID = "0";
ObjPreferncesItemsInfo.PriceRange = SelectedRange;
ObjPreferncesItemsInfo.UserPreferID = dsPreferences.Tables[0].Rows[0]["UserPreferID"].ToString();
dssub = objPreferencesBL.SaveSubScribeItems(ObjPreferncesItemsInfo, true);
}
}
clsMailFormats format = new clsMailFormats();
MailMessage msg = new MailMessage();
msg.From = new MailAddress(txtEmailAlert.Text);
msg.To.Add("*****@*****.**");
//msg.Bcc.Add();
msg.Subject = "Welcome to your personalized weekly email alerts preferences.";
msg.IsBodyHtml = true;
string text = string.Empty;
string VerifyPreferences = string.Empty;
string ModifyPreferences = string.Empty;
string PreferencesID = string.Empty;
//VerifyPreferences = "www.unitedcarexchange.com/VerifyPreferences.aspx?Preferce=" + dssub.Tables[0].Rows[0]["ID"].ToString();
//ModifyPreferences = "www.unitedcarexchange.com/EmailPreferences.aspx?Preferce=" + dssub.Tables[0].Rows[0]["ID"].ToString();
PreferencesID = dsPreferences.Tables[0].Rows[0]["UserPreferID"].ToString();
GeneralFunc obj = new GeneralFunc();
text = format.SendEMailPreferences(GeneralFunc.ToProper(dsPreferences.Tables[0].Rows[0]["Name"].ToString()), dsPreferences.Tables[0].Rows[0]["UserPreferID"].ToString(), ref text);
msg.Body = text.ToString();
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "hugomirad");
smtp.EnableSsl = true;
smtp.Send(msg);
//smtp.Host = "127.0.0.1";
//smtp.Port = 25;
//smtp.Send(msg);
// Progress111.Visible = false;
Type cstype = GetType();
ClientScriptManager cs = Page.ClientScript;
cs.RegisterStartupScript(cstype, "KyRST", "<script type='text/javascript' language='javascript'>pageLoad();</script>");
lblAlertMsg.Text = "Thank you for signing up for automatic email alerts..";
//mpealert.Show();
}
else
{
Type cstype = GetType();
ClientScriptManager cs = Page.ClientScript;
cs.RegisterStartupScript(cstype, "KyRST", "<script type='text/javascript' language='javascript'>pageLoad();</script>");
lblAlertMsg.Text = "Email ID Already Subscribed..";
//mpealert.Show();
}
}
// Use this for initialization
void Start()
{
generalFunc = new GeneralFunc();
}
