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