public string sendmailforinvitefriend([FromBody] JObject parameter) { //JavaScriptSerializer js = new JavaScriptSerializer(); //string[] persons = js.Deserialize<string[]>(parameter["dataemail"]["email_list_send"].ToString()); emailSendFrined objsendmail = new emailSendFrined(); string result = ""; bool resultSendEmail = false; bool security_flag = false; try { if ((parameter["tokendata"]["member_id"].ToString() != null || parameter["tokendata"]["member_id"].ToString() != "") && (parameter["tokendata"]["Token"].ToString() != null || parameter["tokendata"]["Token"].ToString() != "")) { security_flag = objmasters.securityCheck(parameter["tokendata"]["member_id"].ToString(), parameter["tokendata"]["Token"].ToString()); } if (parameter["dataemail"]["email_list_send"].ToString() != "") { objsendmail = parameter["dataemail"].ToObject <emailSendFrined>(); } if (security_flag == true) { if (objsendmail.email_list_send != null && objsendmail.email_list_send.Length > 0) { for (int i = 0; i < objsendmail.email_list_send.Length; i++) { resultSendEmail = sendinvitemail(objsendmail.email_list_send[i]); } } } else { return("securityIssue"); } if (resultSendEmail == true) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass"); return("pass"); } else { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail"); return("fail"); } } catch (Exception ex) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace); return("fail"); } //return result; }
public HttpResponseMessage UploadFile() { HttpResponseMessage result = null; try { string path = ""; var filePath = ""; int upldcount = 0; string filenm = ""; var httpRequest = HttpContext.Current.Request; if (httpRequest["requesttype"] == "profile") { path = ConfigurationManager.AppSettings["ProfilePic"].ToString(); } Dictionary <string, string> array1 = new Dictionary <string, string>(); if (httpRequest.Files.Count > 0) { var docfiles = new List <string>(); foreach (string file in httpRequest.Files) { var postedFile = httpRequest.Files[file]; if (postedFile.FileName.Trim() != "") { //var filePath = HttpContext.Current.Server.MapPath("~/imageFolder/DrvPhoto/" + postedFile.FileName); filenm = postedFile.FileName; filenm = filenm.ToString().Substring(0, filenm.IndexOf(".")) + System.DateTime.UtcNow.ToString("yyyyMMddHHmmss") + filenm.ToString().Substring(filenm.IndexOf("."), (filenm.ToString().Length - filenm.IndexOf("."))); filePath = HttpContext.Current.Server.MapPath(path + filenm); postedFile.SaveAs(filePath); docfiles.Add(filePath); array1[file] = path + filenm; upldcount++; } } result = Request.CreateResponse(HttpStatusCode.Created, filenm); } else { result = Request.CreateResponse(HttpStatusCode.BadRequest); } } catch (Exception ex) { ServerLog.Log(ex.Message.ToString() + Environment.NewLine + ex.StackTrace); //ServerLog.Log(ex.InnerException.ToString()); result = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); return(result); } return(result); }
private void OnGetUserInfo(object data) { ProtocolData pdata = data as ProtocolData; CTS_GetUserInfo uinfo = pdata.MData as CTS_GetUserInfo; int uid = uinfo.MUserId; try { DBUserInfo info = UserMgr.MInstance.GetUserInfoById(uid); STC_UserInfo stc_userinfo = new STC_UserInfo(); stc_userinfo.MUserName = info.MUserName; ServerNet.MInstance.SendMsg(pdata.MIpEndPoint, STC_UserInfo.MProtoId, stc_userinfo); } catch (Exception exp) { ServerLog.Log(string.Format("{0}", exp.Message)); } }
public string update_password([FromBody] JObject parameter) { BLReturnObject objBLReturnObject = new BLReturnObject(); try { string pwd = parameter["password"].ToString(); pwd = pwd.Trim(); EncryptPassword encrpt = new EncryptPassword(); string encrpt_password = encrpt.Encrypt(pwd.ToString().Trim()); string member_code = parameter["member_code"].ToString(); DataTable dt = new DataTable(); dt = objmasters.getuserinfo(member_code); DataRow dr = dt.Rows[0]; dr["password"] = encrpt_password; objDS_MemberTables.member_master.ImportRow(dr); objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, true); if (objBLReturnObject.ExecutionStatus == 1) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass"); return("pass"); } else { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail"); return("fail"); } } catch (Exception ex) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace); return("fail"); } }
private void UpdateReceiveData() { while (true) { if (ReceiveTickCount < SiArray.Count) { warningTimes += 1; } else { warningTimes = 0; } if (warningTimes > 30 && StartWarn) { EmailParameterSet model = new EmailParameterSet(); model.SendEmail = "*****@*****.**"; model.SendPwd = "libisrsmpjhqbhgh"; //密码 model.SendSetSmtp = "smtp.qq.com"; //发送的SMTP服务地址 ,每个邮箱的是不一样的。。根据发件人的邮箱来定 model.ConsigneeAddress = "*****@*****.**"; model.ConsigneeTheme = "!!数字平台行情接收器报警!!"; model.ConsigneeHand = "数据行情接收异常"; model.ConsigneeName = "dongnan_chen"; model.SendContent = "数据行情接受器接受数据少于订阅数据数量长达30秒"; string errinfo; if (model.MailSend(model, out errinfo) == true) { Console.WriteLine("邮件发送成功!"); } else { Console.WriteLine(errinfo); } } ServerLog.Log(string.Format("√{0},", ReceiveTickCount), false); ReceiveTickCount = 0; Thread.Sleep(1000); } }
public string sendmailforfotgotpassword([FromBody] JObject parameter) { DataTable dtuniversityDetails = new DataTable(); string result = ""; bool resultSendEmail = false; dtuniversityDetails = objmasters.forgotpwd(parameter["email_id"].ToString(), parameter["birthdate"].ToString(), parameter["security_question"].ToString(), parameter["question_ans"].ToString()); if (dtuniversityDetails != null) { string member_code = dtuniversityDetails.Rows[0]["member_code"].ToString(); resultSendEmail = sendEmailfogot(parameter["email_id"].ToString(), member_code, dtuniversityDetails.Rows[0]["university"].ToString()); } if (resultSendEmail == true) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass"); return("pass "); } else { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail"); return("fail"); } //return result; }
public override void OnActionExecuting(System.Web.Http.Controllers.HttpActionContext actionContext) { ServerLog.Log("新的请求"); ResultMsg resultMsg = null; var request = actionContext.Request; string method = request.Method.Method; string staffid = string.Empty, timestamp = string.Empty, nonce = string.Empty, signature = string.Empty; if (request.Headers.Contains("staffid")) { staffid = HttpUtility.UrlDecode(request.Headers.GetValues("staffid").FirstOrDefault()); } if (request.Headers.Contains("timestamp")) { timestamp = HttpUtility.UrlDecode(request.Headers.GetValues("timestamp").FirstOrDefault()); } if (request.Headers.Contains("nonce")) { nonce = HttpUtility.UrlDecode(request.Headers.GetValues("nonce").FirstOrDefault()); } if (request.Headers.Contains("signature")) { signature = HttpUtility.UrlDecode(request.Headers.GetValues("signature").FirstOrDefault()); } ServerLog.Log("StaffId:" + staffid); ServerLog.Log("TimeStamp:" + timestamp); ServerLog.Log("nonce:" + nonce); if (string.IsNullOrWhiteSpace(staffid) || string.IsNullOrWhiteSpace(timestamp) || string.IsNullOrWhiteSpace(nonce)) { resultMsg = new ResultMsg() { StatusCode = (int)StatusCodeEnum.ParameterError, Info = StatusCodeEnum.ParameterError.GetEnumText(), Data = "" }; actionContext.Response = HttpResponseExtension.toJson(resultMsg); base.OnActionExecuting(actionContext); return; } if (actionContext.ActionDescriptor.ActionName.Equals("GetToken")) { base.OnActionExecuting(actionContext); return; } //double ts1 = 0; //double ts2 = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalMilliseconds; //bool timespanvalidate = double.TryParse(timestamp, out ts1); //double ts = ts2 - ts1; //bool falg = ts > int.Parse(WebSettingsConfig.UrlExpireTime) * 1000; //if (falg || (!timespanvalidate)) //{ // resultMsg = new ResultMsg() { // StatusCode = (int)StatusCodeEnum.URLExpireError, // Info = StatusCodeEnum.URLExpireError.GetEnumText(), // Data="" // }; // actionContext.Response = HttpResponseExtension.toJson(resultMsg); // base.OnActionExecuting(actionContext); // return; //} Token token = (Token)HttpRuntime.Cache.Get(staffid); string signtoken = string.Empty; if (null == HttpRuntime.Cache.Get(staffid)) { resultMsg = new ResultMsg() { StatusCode = (int)StatusCodeEnum.TokenInvalid, Info = StatusCodeEnum.TokenInvalid.GetEnumText(), Data = "" }; actionContext.Response = HttpResponseExtension.toJson(resultMsg); base.OnActionExecuting(actionContext); return; } signtoken = token.SignToken.ToString(); NameValueCollection form = HttpContext.Current.Request.QueryString; string data = string.Empty; switch (method) { case "POST": Stream stream = HttpContext.Current.Request.InputStream; string responseJson = string.Empty; StreamReader streamReader = new StreamReader(stream); data = streamReader.ReadToEnd(); break; case "GET": IDictionary <string, string> parameters = new Dictionary <string, string>(); for (int f = 0; f < form.Count; f++) { string key = form.Keys[f]; parameters.Add(key, form[key]); } IDictionary <string, string> sortedParams = new SortedDictionary <string, string>(parameters); IEnumerator <KeyValuePair <string, string> > dem = sortedParams.GetEnumerator(); StringBuilder query = new StringBuilder(); while (dem.MoveNext()) { string key = dem.Current.Key; string value = dem.Current.Value; if (!string.IsNullOrWhiteSpace(value)) { query.Append(key).Append(value); } } data = query.ToString(); break; default: resultMsg = new ResultMsg() { StatusCode = (int)StatusCodeEnum.HttpMethodError, Info = StatusCodeEnum.HttpMethodError.GetEnumText(), Data = "" }; actionContext.Response = HttpResponseExtension.toJson(resultMsg); base.OnActionExecuting(actionContext); return; } bool result = SignExtension.Validate(timestamp, nonce, staffid, signtoken, data, signature); if (!result) { resultMsg = new ResultMsg() { StatusCode = (int)StatusCodeEnum.HttpRequestError, Info = StatusCodeEnum.HttpRequestError.GetEnumText(), Data = "" }; actionContext.Response = HttpResponseExtension.toJson(resultMsg); base.OnActionExecuting(actionContext); return; } base.OnActionExecuting(actionContext); }
public string SaveRelation([FromBody] JObject Parameter) { var tempkey = Parameter.Properties().Select(p => p.Name).ToList(); BLReturnObject objBLReturnObject = new BLReturnObject(); Master SvRelation = new Master(); owner_truck_details truck_Owner_data = new owner_truck_details(); driver_truck_detail drivertruck = new driver_truck_detail(); owner_driver_detail ownerDriverData = new owner_driver_detail(); LoginCheck login_data = new LoginCheck(); owner_truck_details ownerTruckDetailData = new owner_truck_details(); if (tempkey.Contains("login_data")) { login_data = Parameter["login_data"].ToObject <LoginCheck>(); } if (tempkey.Contains("truck_owner")) { truck_Owner_data = Parameter["truck_owner"].ToObject <owner_truck_details>(); } if (tempkey.Contains("truck_driver")) { drivertruck = Parameter["truck_driver"].ToObject <driver_truck_detail>(); } if (tempkey.Contains("owner_driver")) { ownerDriverData = Parameter["owner_driver"].ToObject <owner_driver_detail>(); } #region Truck Owner Data if (truck_Owner_data != null) { if (truck_Owner_data.owner_id != null && truck_Owner_data.truck_id != null) { try { //owid = truck_Owner_data.owner_id; DS_Truck_Mst.owner_truck_detailsRow owrow = objtruck.owner_truck_details.Newowner_truck_detailsRow(); owrow.owner_id = truck_Owner_data.owner_id; owrow.truck_id = truck_Owner_data.truck_id; owrow.active_flag = "Y"; owrow.created_by = login_data.user_id; owrow.created_date = System.DateTime.UtcNow; owrow.created_host = "1111"; owrow.device_id = login_data.device_id; owrow.device_type = login_data.device_type; objtruck.owner_truck_details.Addowner_truck_detailsRow(owrow); } catch (Exception ex) { ServerLog.Log("Truck Owner Relation: " + ex.Message.ToString() + ex.StackTrace.ToString()); return(ex.Message.ToString()); } } } #endregion #region Truck Driver Details if (drivertruck != null) { if (drivertruck.driver_id != null && drivertruck.truck_id != null) { try { DS_Truck_Mst.driver_truck_detailsRow trkdrvrow = objtruck.driver_truck_details.Newdriver_truck_detailsRow(); trkdrvrow.driver_id = drivertruck.driver_id; trkdrvrow.truck_id = drivertruck.truck_id; trkdrvrow.active_flag = "Y"; trkdrvrow.created_by = login_data.user_id; trkdrvrow.created_date = System.DateTime.UtcNow; trkdrvrow.created_host = "1111"; trkdrvrow.device_id = login_data.device_id; trkdrvrow.device_type = login_data.device_type; objtruck.driver_truck_details.Adddriver_truck_detailsRow(trkdrvrow); } catch (Exception ex) { ServerLog.Log("Truck Driver Relation : " + ex.Message.ToString()); return(ex.Message.ToString()); } } } #endregion #region Owner Driver Details try { if (tempkey.Contains("owner_driver")) { ownerDriverData = Parameter["owner_driver"].ToObject <owner_driver_detail>(); if (ownerDriverData != null) { if (ownerDriverData.owner_id != null && ownerDriverData.driver_id != null) { try { DS_Owner_Mst.owner_driver_detailsRow owndrvrow = objowner.owner_driver_details.Newowner_driver_detailsRow(); owndrvrow.owner_id = ownerDriverData.owner_id; owndrvrow.driver_id = ownerDriverData.driver_id; owndrvrow.active_flag = "Y"; owndrvrow.created_by = login_data.user_id; owndrvrow.created_date = System.DateTime.UtcNow; owndrvrow.created_host = "1111"; owndrvrow.device_id = login_data.device_id; owndrvrow.device_type = login_data.device_type; objowner.owner_driver_details.Addowner_driver_detailsRow(owndrvrow); } catch (Exception ex) { ServerLog.Log("Owner Driver Relation: " + ex.Message.ToString()); responsecls.status = "0"; responsecls.Message = ex.Message; return(jser.Serialize(responsecls)); } } } } } catch (Exception ex) { ServerLog.Log(ex.Message); responsecls.status = "0"; responsecls.Message = ex.Message; return(jser.Serialize(responsecls)); } #endregion DataSet[] dsall = new DataSet[2]; dsall[0] = objtruck; dsall[1] = objowner; // objBLReturnObject = ownermst.Save_Owner_Mst(objowner, objOwnerDriver); objBLReturnObject = SvRelation.SaveOwnerTruckDriverRelation(dsall); if (objBLReturnObject.ExecutionStatus == 1) { return(objBLReturnObject.ServerMessage); } else { ServerLog.Log(objBLReturnObject.ServerMessage.ToString()); return(objBLReturnObject.ServerMessage); } }
public String RegisterDeviceAndroid([FromBody] JObject parameter) { //ResponseObjectInfo objResponseObjectInfo = new ResponseObjectInfo(); BLReturnObject objBLReturnObject = new BLReturnObject(); String AppName = parameter["AppName"].ToString(); String RepId = parameter["RepId"].ToString(); String DeviceId = parameter["DeviceId"].ToString(); String TokenId = parameter["TokenId"].ToString(); String DeviceInfo = parameter["DeviceInfo"].ToString(); String OS = parameter["OS"].ToString(); String IMEINo = parameter["IMEINo"].ToString(); try { ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ", " + Convert.ToString(IMEINo) + ")"); // ServerLog.ExceptionLog("RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ", " + Convert.ToString(IMEINo) + ")"); if (AppName == null || AppName.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied AppName."; objBLReturnObject.dt_ReturnedTables = null; } else if (RepId == null || RepId.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied RepId."; objBLReturnObject.dt_ReturnedTables = null; } else if (DeviceId == null || DeviceId.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied DeviceId."; objBLReturnObject.dt_ReturnedTables = null; } else if (TokenId == null || TokenId.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied TokenId."; objBLReturnObject.dt_ReturnedTables = null; } else if (OS == null || OS.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied OS."; objBLReturnObject.dt_ReturnedTables = null; } else if (IMEINo == null || IMEINo.Trim() == String.Empty) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = "Please supplied IMEINo."; objBLReturnObject.dt_ReturnedTables = null; } else { String Message = String.Empty; Masters objmasters = new Masters(); Byte result = objmasters.AddDeviceInfo(AppName, RepId, DeviceId, TokenId, DeviceInfo, OS, IMEINo, ref Message); objBLReturnObject.ExecutionStatus = result; objBLReturnObject.ServerMessage = Message; objBLReturnObject.dt_ReturnedTables = null; } } catch (Exception ex) { objBLReturnObject.ExecutionStatus = 2; objBLReturnObject.ServerMessage = ex.Message; objBLReturnObject.dt_ReturnedTables = null; // ServerLog.ExceptionLog("RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ")"); ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace); } return(JsonConvert.SerializeObject(objBLReturnObject)); }
public string SaveAppLog([FromBody] JObject jobj) { AppLog jobjdata = new AppLog(); Document doc = new Document(); BLReturnObject objBLReturnObject = new BLReturnObject(); Master master = new Master(); string message = ""; DS_AppLog ds_app = new DS_AppLog(); List <AppLog> tload = new List <AppLog>(); tload = jobj["log"].ToObject <List <AppLog> >(); DataTable dt_log = new DataTable(); string LogDocID = ""; dt_log = BLGeneralUtil.ToDataTable(tload); try { if (jobj != null) { if (dt_log != null && dt_log.Rows.Count > 0) { DBConnection.Open(); DBCommand.Transaction = DBConnection.BeginTransaction(); ds_app.EnforceConstraints = false; if (!doc.W_GetNextDocumentNo(ref DBCommand, "APL", "", "", ref LogDocID, ref message)) // New Driver Notification ID { return(BLGeneralUtil.return_ajax_string("0", message)); } ds_app.AppLog.ImportRow(dt_log.Rows[0]); ds_app.AppLog[0].log_id = LogDocID; ds_app.AppLog[0].log_date = System.DateTime.UtcNow; ds_app.AppLog[0].created_date = System.DateTime.UtcNow; ds_app.AppLog[0].AcceptChanges(); ds_app.AppLog[0].SetAdded(); ds_app.EnforceConstraints = true; objBLReturnObject = master.UpdateTables(ds_app.AppLog, ref DBCommand); if (objBLReturnObject.ExecutionStatus != 1) { ServerLog.Log(objBLReturnObject.ServerMessage.ToString()); DBCommand.Transaction.Rollback(); if (DBConnection.State == ConnectionState.Open) { DBConnection.Close(); } return(BLGeneralUtil.return_ajax_string("0", objBLReturnObject.ServerMessage)); } DBCommand.Transaction.Commit(); if (DBConnection.State == ConnectionState.Open) { DBConnection.Close(); } objBLReturnObject.ExecutionStatus = 1; ServerLog.SuccessLog("App Log Entry Saved : " + LogDocID); } } } catch (Exception ex) { ServerLog.Log(ex.Message + ex.StackTrace); DBCommand.Transaction.Rollback(); if (DBConnection.State == ConnectionState.Open) { DBConnection.Close(); } return(BLGeneralUtil.return_ajax_string("0", ex.Message)); } return(BLGeneralUtil.return_ajax_string("1", "App Log Entry Saved : " + LogDocID)); }
public bool SetAndModifyStatusinAnyTableNew(string tablename, string status, string shipperid, string inquiryno, string ownerid, string truckid, string driverid, ref IDbCommand DBCommand) { DBCommand.Parameters.Clear(); string where = ""; string query = " UPDATE " + tablename + " SET status = '" + status + "' " + " WHERE "; if (shipperid != string.Empty && shipperid != "" && shipperid.TrimEnd() != "") { DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@shipperid", DbType.String, shipperid)); where = " shipper_id= @shipperid "; } if (inquiryno != string.Empty && inquiryno != "" && inquiryno.TrimEnd() != "") { DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@inquiryno", DbType.String, inquiryno)); if (where != string.Empty) { where = where + "AND load_inquiry_no= @inquiryno "; } else { where = " load_inquiry_no = @inquiryno "; } } if (ownerid != string.Empty && ownerid != "" && ownerid.TrimEnd() != "") { DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@ownerid", DbType.String, ownerid)); if (where != string.Empty) { where = where + "AND owner_id= @ownerid "; } else { where = " owner_id = @ownerid "; } } if (truckid != string.Empty && truckid != "" && truckid.TrimEnd() != "") { DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@truckid", DbType.String, truckid)); if (where != string.Empty) { where = where + "AND truck_id= @truckid "; } else { where = " truck_id = @truckid "; } } if (driverid != string.Empty && driverid != "" && driverid.TrimEnd() != "") { DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@driverid", DbType.String, driverid)); if (where != string.Empty) { where = where + "AND driver_id= @driverid "; } else { where = " driver_id = @driverid "; } } query = query + where; DBCommand.CommandText = query; int row_count = 0; if (DBConnection.State == ConnectionState.Closed) { DBConnection.Open(); } try { row_count = DBCommand.ExecuteNonQuery(); } catch (Exception ex) { ServerLog.Log(ex.Message + Environment.NewLine + ex.StackTrace); return(false); } if (row_count <= 0) { ServerLog.Log("Status not Updated " + tablename + Environment.NewLine + query); return(false); } else { return(true); } }
public string LoginCheck([FromBody] LoginData loginData) { int flg = 0; BLReturnObject objBLReturnObject = new BLReturnObject(); DataTable dtMemberDetails = new DataTable(); string result = ""; string encrpt_password = ""; dtMemberDetails = objmasters.LoginCheck(loginData.userName); try { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.dives + " " + loginData.password + " " + loginData.userName + "status" + "pass"); if (dtMemberDetails == null || dtMemberDetails.Rows.Count == 0) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "NotExists"); return("NotExists"); } if (dtMemberDetails.Rows[0]["university"].ToString() != loginData.university_id) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Wronguniversity"); return("Wronguniversity"); } else { if (loginData.pass_encrpted_flag != "true") { loginData.password = loginData.password.Trim(); EncryptPassword encrpt = new EncryptPassword(); encrpt_password = encrpt.Encrypt(loginData.password.ToString().Trim()); } else { encrpt_password = loginData.password; } if (dtMemberDetails.Rows[0]["password"].ToString() != encrpt_password) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "WrongPass"); return("WrongPass"); } if (dtMemberDetails.Rows[0]["default_role"].ToString() == "TT") { DataTable dtrole = objmasters.checkmemberrole(loginData.userName); for (int i = 0; i < dtrole.Rows.Count; i++) { if (dtrole.Rows[i]["role_id"].ToString() == "ST") { break; } else if (dtrole.Rows[i]["role_id"].ToString() == "TT") { if (dtrole.Rows[i]["is_approved"].ToString() == "Y" && dtrole.Rows[i]["approved_by_whome"].ToString() != "" && dtrole.Rows[i]["approved_by_whome"].ToString() != null) { break; } else { flg++; } } } if (dtrole.Rows.Count == flg) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "notApproved"); return("notApproved"); } } //Random rand = new Random(); //int tokenId = rand.Next(1, 100000); Guid tokenId = Guid.NewGuid(); DataRow dr = dtMemberDetails.Rows[0]; //dr["token_id"] = tokenId.ToString(); objDS_MemberTables.member_master.ImportRow(dr); DS_MemberTables.login_tokenRow rowtoken = objDS_MemberTables.login_token.Newlogin_tokenRow(); rowtoken.member_id = loginData.userName; rowtoken.device_id = loginData.dives; rowtoken.token_id = tokenId.ToString(); if (rowtoken.device_id.Trim().Length == 0) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Device not null"); return("Device not null"); } else { objDS_MemberTables.login_token.Addlogin_tokenRow(rowtoken); objBLReturnObject = objmasters.saveLinkData_login(objDS_MemberTables, true); if (objBLReturnObject.ExecutionStatus == 1) { dtMemberDetails.Columns.Add("token_id"); dtMemberDetails.Rows[0]["token_id"] = tokenId.ToString();; result = GetJson1(dtMemberDetails); } else { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "TokenIssue"); return("TokenIssue"); } } } } catch (Exception e) { ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + e.StackTrace); return(result); } return(result); }