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