public AgentTourCommission Get(int userId, int tourCodeId)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
_connection.Close();
}
var commission = new AgentTourCommission {
TourCodeID = tourCodeId, UserID = userId
};
_connection.Open();
_cmd = _connection.CreateCommand();
_cmd.CommandText = "Select Commission from agenttourcommission where userid='" + userId + "' and tourcodeid='" + tourCodeId + "' and active_f=1;";
_dr = _cmd.ExecuteReader();
while (_dr.Read())
{
commission.Commission = _dr.GetFloat(0);
}
_dr.Close();
if (_connection.State == System.Data.ConnectionState.Open)
{
_connection.Close();
}
return(commission);
}
public void Delete(AgentTourCommission obj)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
_connection.Close();
}
_connection.Open();
_cmd = _connection.CreateCommand();
_cmd.CommandText = " UPDATE agenttourcommission SET active_f=0 where userid=@userId and tourcodeid=@tourCodeId; ";
_cmd.ExecuteNonQuery();
_dr.Close();
}
public JsonResult getAgentTourCommission(AgentTourCommission obj)
{
var repository = new AgentTourCommissionRepository();
var result = repository.Get(obj.UserID, obj.TourCodeID);
if (result.Commission != null && result.Commission != 0)
{
return(Json(result.Commission));
}
else
{
var rep = new BookingRepository();
return(Json(rep.GetCommission(obj.UserID)));
}
}
public void Insert(AgentTourCommission obj)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
_connection.Close();
}
_connection.Open();
_cmd = _connection.CreateCommand();
_cmd.CommandText = " INSERT INTO agenttourcommission (`UserID`, `TourCodeID`, `Commission`,`active_f`) VALUES (@userId, @tourCodeId, @commission,@active_f); ";
_cmd.Parameters.AddWithValue("@userId", obj.UserID);
_cmd.Parameters.AddWithValue("@tourCodeId", obj.TourCodeID);
_cmd.Parameters.AddWithValue("@commission", obj.Commission);
_cmd.Parameters.AddWithValue("@active_f", obj.active_f); //on 04-08-2015
_cmd.ExecuteNonQuery();
_dr.Close();
}
public void Update(AgentTourCommission obj)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
_connection.Close();
}
_connection.Open();
_cmd = _connection.CreateCommand();
// _cmd.CommandText = " UPDATE agenttourcommission SET `Commission`=@commission,`Active_f`=1 where userid=@userId and tourcodeid=@tourCodeId; ";
_cmd.CommandText = " UPDATE agenttourcommission SET `Commission`=@commission,`Active_f`=@active_f where userid=@userId and tourcodeid=@tourCodeId; ";
_cmd.Parameters.AddWithValue("@userId", obj.UserID);
_cmd.Parameters.AddWithValue("@tourCodeId", obj.TourCodeID);
_cmd.Parameters.AddWithValue("@commission", obj.Commission);
_cmd.Parameters.AddWithValue("@active_f", obj.active_f); //on 04-08-2015
_cmd.ExecuteNonQuery();
_dr.Close();
}
