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