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