public ENT.UserDeviceToken GetUserDeviceTokenFromwalletRequest(Guid wr_id) { ENT.UserDeviceToken Entity = new ENT.UserDeviceToken(); try { parFields.Clear(); //Add Query in to string builder object QueryDisctionery.SelectPart = "select * "; QueryDisctionery.TablePart = @"from UserDeviceToken inner join WalletRequest on WalletRequest.wr_userid = UserDeviceToken.udt_userid"; QueryDisctionery.ParameterPart = "Where WalletRequest.wr_id ='" + wr_id + "'"; //Execute Query and get SQLDataReader using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { Entity = COM.DBHelper.CopyDataReaderToSingleEntity <ENT.UserDeviceToken>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(Entity); }
public HttpResponseMessage RegisterToken(ENT.UserDeviceToken modal) { GlobalVarible.Clear(); try { using (BAL.UserDeviceToken objBal = new BAL.UserDeviceToken()) { modal.udt_userid = _LOGINUSERID; modal.CreatedBy = _LOGINUSERID; modal.CreatedDateTime = DateTime.Now; if (objBal.Insert(modal)) { GlobalVarible.AddMessage("Token Registered Successfully."); return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); } else { GlobalVarible.AddError("Unable to Add Token.Please Try Again"); ERRORREPORTING.Report(new Exception("Unable to Add Token.Please Try Again"), _REQUESTURL, _LOGINUSERID, _ERRORKEY, new JavaScriptSerializer().Serialize(modal)); return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); } } } catch (Exception ex) { GlobalVarible.AddError(ex.Message); ERRORREPORTING.Report(ex, _REQUESTURL, _LOGINUSERID, _ERRORKEY, new JavaScriptSerializer().Serialize(modal)); return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); } }
public ENT.UserDeviceToken GetUserDeviceToken(Guid userid) { ENT.UserDeviceToken Entity = new ENT.UserDeviceToken(); try { parFields.Clear(); //Add Query in to string builder object QueryDisctionery.SelectPart = "select top 1 * "; QueryDisctionery.TablePart = @"from UserDeviceToken "; QueryDisctionery.ParameterPart = "Where udt_userid='" + userid + "'"; QueryDisctionery.OrderPart = "Order by CreatedDateTime desc"; //Execute Query and get SQLDataReader using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { Entity = COM.DBHelper.CopyDataReaderToSingleEntity <ENT.UserDeviceToken>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(Entity); }
// this function for just referance for partial update field user have to create seperate function learn from this function. public bool UpdatePartial(ENT.UserDeviceToken objEntity) { bool blnResult = false; try { //Create Fields List in dictionary Dictionary <string, bool> dctFields = new Dictionary <string, bool>(); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.udt_id), true); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.udt_userid), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.udt_imei), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.udt_devicetoken), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.SystemDateTime), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.CreatedBy), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.CreatedDateTime), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.UpdatedBy), false); dctFields.Add(COM.HelperMethod.PropertyName <ENT.UserDeviceToken>(x => x.UpdatedDateTime), false); objEntity.FieldCollection = dctFields; if (objDAL.SaveChanges(objEntity.FieldCollection, objEntity)) { blnResult = true; } } catch (Exception) { throw; } return(blnResult); }
public object GetByPrimaryKey(ENT.UserDeviceToken Entity) { object objResult = null; try { DAL.CRUDOperation tt = new DAL.CRUDOperation(); objResult = tt.GetEntityByPrimartKey(Entity); } catch (Exception) { throw; } return(objResult); }
public HttpResponseMessage SendNotification() { GlobalVarible.Clear(); using (BAL.UserDeviceToken objUDT = new BAL.UserDeviceToken()) { ENT.UserDeviceToken usertoken = objUDT.GetUserDeviceToken(Guid.Parse("5a5537fc-0411-45c1-8960-b24bbf1ea375")); if (usertoken != null) { string message = "Your account is credited with with 100. : " + DateTime.Now.Ticks.ToString(); FCMNOTIFICATION.SendPushNotification(usertoken.udt_devicetoken, message, Guid.Parse("5a5537fc-0411-45c1-8960-b24bbf1ea375"), 1); } } return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); }
public HttpResponseMessage doTransfer(doFundTransferModel data) { COM.DBHelper sqlhelper = new COM.DBHelper(); GlobalVarible.Clear(); List <string> strvalidationResult = new List <string>(); try { string token = _LOGINUSERID.ToString(); string reqdata = ENCDESC.Decrypt(data.data, token, data.userid); MDL.FundTransfer model = new FundTransfer(); model = new JavaScriptSerializer().Deserialize <MDL.FundTransfer>(reqdata); strvalidationResult = ValidateFundTransfer(model); if (strvalidationResult.Count() == 0) { if (checkpassword(model.up_password)) { model.up_upperid = Guid.Parse(User.Identity.GetUserId()); string[,] param = { { "PARENTID", model.up_upperid.ToString() }, { "USERID", model.up_userid.ToString() }, { "BALTOADD", model.up_fundbalance }, { "TRANSMODE", model.up_mode }, { "REMARKS", model.up_remakrs }, }; COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("ADD_FUND_TO_ACCOUNT", param, true); if (M.ValueFromSQL == 1) { // get detail user device token using (BAL.UserDeviceToken objUDT = new BAL.UserDeviceToken()) { ENT.UserDeviceToken usertoken = objUDT.GetUserDeviceToken(model.up_userid); if (usertoken != null) { string message = "Your account is credited with with " + model.up_fundbalance.ToString(); FCMNOTIFICATION.SendPushNotification(usertoken.udt_devicetoken, message, model.up_userid, 1); } } GlobalVarible.AddMessage(M.MessageFromSQL); } else { throw new Exception(string.Join("<br />", M.MessageFromSQL)); } } else { throw new Exception(string.Join("<br />", "Invalid Password !")); } } else { throw new Exception(string.Join("<br />", strvalidationResult)); } return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); } catch (Exception ex) { GlobalVarible.AddError(ex.Message); ERRORREPORTING.Report(ex, _REQUESTURL, _LOGINUSERID, _ERRORKEY, string.Empty); return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult })); } }
public ENT.UserDeviceToken GetUserDeviceTokenFromwalletRequest(Guid wr_id) { ENT.UserDeviceToken Entity = new ENT.UserDeviceToken(); Entity = clsDAL.GetUserDeviceTokenFromwalletRequest(wr_id); return(Entity); }
public ENT.UserDeviceToken GetUserDeviceToken(Guid userid) { ENT.UserDeviceToken Entity = new ENT.UserDeviceToken(); Entity = clsDAL.GetUserDeviceToken(userid); return(Entity); }