Example #1
0
        public CompetitorResponse InsertUpdateCompetitorMaster
            ([FromBody] CompetitorMaster competitorMaster)
        {
            var objMaster             = _Kernel.Get <IMaster>();
            var objCompetitorResponse = objMaster.
                                        InsertUpdateCompetitorMaster(competitorMaster);

            return(objCompetitorResponse);
        }
Example #2
0
        public CompetitorResponse InsertUpdateCompetitorMaster
            (CompetitorMaster competitorMaster)
        {
            try
            {
                Log.Info("Started call to InsertUpdateCompetitorMaster");
                Log.Info("parameter values"
                         + JsonConvert.SerializeObject(competitorMaster));
                Command.CommandText = "SP_COMPETITOR_MANAGER";
                Command.CommandType = CommandType.StoredProcedure;
                Command.Parameters.Clear();

                Command.Parameters.AddWithValue("@COMPETITOR_XML"
                                                , GetXMLFromObject(competitorMaster));

                if (competitorMaster.AddedBy.HasValue)
                {
                    Command.Parameters.AddWithValue("@USER_ID", competitorMaster.AddedBy.Value);
                }
                else if (competitorMaster.ModifiedBy.HasValue)
                {
                    Command.Parameters.AddWithValue("@USER_ID", competitorMaster.ModifiedBy.Value);
                }
                Connection.Open();
                SqlDataReader reader = Command.ExecuteReader();

                CompetitorResponse result = new CompetitorResponse();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        result = new CompetitorResponse
                        {
                            Id        = Convert.ToInt32(reader["Id"].ToString()),
                            Message   = reader["ReturnMessage"] != DBNull.Value ? reader["ReturnMessage"].ToString() : null,
                            IsSuccess = Convert.ToBoolean(reader["Result"].ToString())
                        };
                    }
                }
                Log.Info("End call to InsertUpdateCompetitorMaster. Result:"
                         + JsonConvert.SerializeObject(result));
                return(result);
            }
            catch (Exception ex)
            {
                Log.Error("Error in InsertUpdateCompetitorMaster. Error:"
                          + JsonConvert.SerializeObject(ex));
                LogError(ex);
                throw;
            }
            finally
            {
                Connection.Close();
            }
        }
Example #3
0
 public CompetitorResponse InsertUpdateCompetitorMaster
     (CompetitorMaster competitorMaster)
 {
     try
     {
         return(this._masterDA.InsertUpdateCompetitorMaster(competitorMaster));
     }
     catch (Exception ex)
     {
         throw;
     }
     finally
     {
     }
 }