public object AddRewardMoney(JsonMember.TranscationManagement obj) { TranscationReturn obj1 = new TranscationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(2); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@RewardId", obj.RewardId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_AddRewardMoney"); obj1 = new TranscationReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), AvailableBalance = Convert.ToDecimal(DS.Tables[0].Rows[0]["AvailableBalance"].ToString()) }; } catch (Exception Ex) { DS = LogError("Add Reward Money", Ex.Message.ToString(), "SP Name: USP_AddRewardMoney"); obj1 = new TranscationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), TranscationId = "" }; } finally { Sqldbmanager.Close(); } return(obj1); }
public object GetTranscationDetails(JsonMember.TranscationManagement obj) { List <JsonMember.TranscationDetails> lstTranscationDetails = new List <JsonMember.TranscationDetails>(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(2); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@for", obj.TranscationSource); idr = Sqldbmanager.ExecuteReader(CommandType.StoredProcedure, "USP_GetTranscationDetails"); while (idr.Read()) { lstTranscationDetails.Add(new JsonMember.TranscationDetails() { flag = "true", Message = "success", UserId = Convert.ToInt64(idr["UserId"]), TranscationSourceId = Convert.ToInt64(idr["TranscationSourceId"]), PartnerUserId = Convert.ToInt64(idr["PartnerUserId"]), TranscationStatus = Convert.ToString(idr["TranscationStatus"]), UserLoginId = Convert.ToString(idr["UserLoginId"]), EmailId = Convert.ToString(idr["EmailId"]), MobileNo = Convert.ToString(idr["MobileNo"]), TranscationId = Convert.ToString(idr["TranscationId"]), Amount = Convert.ToDecimal(idr["Amount"]), AvailableBalance = Convert.ToDecimal(idr["AvailableBalance"]), TranscationSource = Convert.ToString(idr["TranscationSource"]), TranscationDetail = Convert.ToString(idr["TranscationDetails"]), PartnerLoginId = Convert.ToString(idr["PartnerLoginId"]), PartnerEmailId = Convert.ToString(idr["PartnerEmailId"]), PartnerMobileNo = Convert.ToString(idr["PartnerMobileNo"]), Ldate = Convert.ToString(idr["Ldate"]), LTime = Convert.ToString(idr["LTime"]), }); } } catch (Exception Ex) { DS = LogError("Get Available Balance", Ex.Message.ToString(), "SP Name: USP_GetTranscationDetails"); lstTranscationDetails.Add(new JsonMember.TranscationDetails() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString() }); } finally { idr.Close(); Sqldbmanager.Close(); } return(lstTranscationDetails); }
public object GetAvailableBalance(JsonMember.TranscationManagement obj) { TranscationReturn obj1 = new TranscationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_GetAvailableBalance"); obj1 = new TranscationReturn() { flag = "true", Message = "success", TranscationId = "", AvailableBalance = Convert.ToDecimal(DS.Tables[0].Rows[0]["AvailableBalance"].ToString()), RewardBalance = Convert.ToDecimal(DS.Tables[0].Rows[0]["RewardBalance"].ToString()), transferMoney = Convert.ToDecimal(DS.Tables[0].Rows[0]["transferMoney"].ToString()), reciverMoney = Convert.ToDecimal(DS.Tables[0].Rows[0]["reciverMoney"].ToString()), lastmonth = Convert.ToDecimal(DS.Tables[0].Rows[0]["lastmonth"].ToString()), lastmonthCredit = Convert.ToDecimal(DS.Tables[0].Rows[0]["lastmonthCredit"].ToString()), lastmonthDebit = Convert.ToDecimal(DS.Tables[0].Rows[0]["lastmonthCredit"].ToString()), }; } catch (Exception Ex) { DS = LogError("Get Available Balance", Ex.Message.ToString(), "SP Name: USP_GetAvailableBalance"); obj1 = new TranscationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), TranscationId = "", AvailableBalance = 0, transferMoney = 0, reciverMoney = 0, lastmonth = 0, lastmonthCredit = 0, lastmonthDebit = 0 }; } finally { Sqldbmanager.Close(); } return(obj1); }
public object TranscationManagement(JsonMember.TranscationManagement obj) { TranscationReturn obj1 = new TranscationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(7); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@TranscationSourceId", obj.TranscationSourceId); Sqldbmanager.AddParameters(2, "@Amount", obj.Amount); Sqldbmanager.AddParameters(3, "@PartnerUserId", obj.PatnerUserId); Sqldbmanager.AddParameters(4, "@MsgDescription", obj.MsgDescription); Sqldbmanager.AddParameters(5, "@RequestId", obj.RequestId); Sqldbmanager.AddParameters(6, "@RewardId", obj.RewardId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_TranscationManagement"); obj1 = new TranscationReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), TranscationId = DS.Tables[0].Rows[0]["TranscationId"].ToString(), AvailableBalance = Convert.ToDecimal(DS.Tables[0].Rows[0]["AvailableBalance"].ToString()) }; } catch (Exception Ex) { DS = LogError("Transcation Management", Ex.Message.ToString(), "SP Name: USP_TranscationManagement"); obj1 = new TranscationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), TranscationId = "" }; } finally { Sqldbmanager.Close(); } return(obj1); }
public object GetTranscationManagement(JsonMember.TranscationManagement obj) { TranscationDetails obj1 = new TranscationDetails(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@TranscationId", obj.TranscationId); idr = Sqldbmanager.ExecuteReader(CommandType.StoredProcedure, "USP_GetTranscationDetailbyId"); if (idr.Read()) { obj1 = new TranscationDetails() { flag = "true", TranscationId = Convert.ToString(idr["TranscationId"]), Amount = Convert.ToDecimal(idr["Amount"].ToString()), UserId = Convert.ToInt64(idr["UserId"].ToString()), RewardId = Convert.ToInt64(idr["RequestId"].ToString()), }; } } catch (Exception Ex) { DS = LogError("Get Transcation Management", Ex.Message.ToString(), "SP Name: USP_GetTranscationDetailbyId"); obj1 = new TranscationDetails() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), TranscationId = "" }; } finally { idr.Close(); Sqldbmanager.Close(); } return(obj1); }
public object GetNotification(JsonMember.TranscationManagement obj) { NotificationManagement obj1 = new NotificationManagement(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); idr = Sqldbmanager.ExecuteReader(CommandType.StoredProcedure, "USP_GetNotification"); List <JsonMember.NotificationManagementDetails> lstDetails = new List <JsonMember.NotificationManagementDetails>(); List <JsonMember.MoneyRequestNotificationDetails> lstMoneyDetails = new List <JsonMember.MoneyRequestNotificationDetails>(); while (idr.Read()) { lstDetails.Add(new JsonMember.NotificationManagementDetails() { TranscationId = Convert.ToString(idr["TranscationId"]), ShortMsg = Convert.ToString(idr["ShortMsg"]), MsgDescription = Convert.ToString(idr["MsgDescription"]), LdateTime = Convert.ToString(idr["LdateTime"]), }); } if (idr.NextResult()) { while (idr.Read()) { lstMoneyDetails.Add(new JsonMember.MoneyRequestNotificationDetails() { RequestId = Convert.ToInt64(idr["RequestId"]), Amount = Convert.ToDecimal(idr["Amount"]), Ldate = Convert.ToString(idr["Ldate"]), LTime = Convert.ToString(idr["LTime"]), UserName = Convert.ToString(idr["UserName"]), MobileNo = Convert.ToString(idr["MobileNo"]), PartnerId = Convert.ToInt64(idr["RequesterId"]) }); } } if (idr.NextResult()) { while (idr.Read()) { obj1 = new NotificationManagement() { flag = "true", Message = "success", AvailableBalance = Convert.ToDecimal(idr["AvailableBalance"].ToString()), NotificationCount = Convert.ToInt64(idr["NotificationCount"].ToString()), RequestMoneyNotificationCount = Convert.ToInt64(idr["RequestMoneyNotificationCount"].ToString()), lstNotificationManagementDetails = lstDetails, lstMoneyRequestNotificationDetails = lstMoneyDetails }; } } } catch (Exception Ex) { DS = LogError("Get Notification", Ex.Message.ToString(), "SP Name: USP_GetNotification"); obj1 = new NotificationManagement() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), AvailableBalance = 0, NotificationCount = 0, RequestMoneyNotificationCount = 0 }; } finally { idr.Close(); Sqldbmanager.Close(); } return(obj1); }