Пример #1
0
        public ITSubHeadMasterResponse InsertUpdateITSubHeadMaster([FromBody] ITSubHeadMaster objITSubHeadMaster)
        {
            var objMaster = _Kernel.Get <IMaster>();
            var objITSubHeadMasterResponse = objMaster.InsertUpdateITSubHeadMaster(objITSubHeadMaster);

            return(objITSubHeadMasterResponse);
        }
Пример #2
0
        public ITSubHeadMasterResponse InsertUpdateITSubHeadMaster
            (ITSubHeadMaster objITSubHeadMaster)
        {
            try
            {
                Log.Info("Started call to InsertUpdateITSubHeadMaster");
                Log.Info("parameter values"
                         + JsonConvert.SerializeObject(objITSubHeadMaster));
                Command.CommandText = "SP_IT_SUB_HEAD_MANAGER";
                Command.CommandType = CommandType.StoredProcedure;
                Command.Parameters.Clear();

                Command.Parameters.AddWithValue("@IT_SUB_HEAD_XML", GetXMLFromObject(objITSubHeadMaster));

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

                ITSubHeadMasterResponse result = new ITSubHeadMasterResponse();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        result = new ITSubHeadMasterResponse
                        {
                            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 InsertUpdateITSubHeadMaster. Result:"
                         + JsonConvert.SerializeObject(result));
                return(result);
            }
            catch (Exception ex)
            {
                Log.Error("Error in InsertUpdateITSubHeadMaster. Error:"
                          + JsonConvert.SerializeObject(ex));
                LogError(ex);
                throw;
            }
            finally
            {
                Connection.Close();
            }
        }
Пример #3
0
 public ITSubHeadMasterResponse InsertUpdateITSubHeadMaster(ITSubHeadMaster objITSubHeadMaster)
 {
     try
     {
         return(this._masterDA.InsertUpdateITSubHeadMaster(objITSubHeadMaster));
     }
     catch (Exception ex)
     {
         throw;
     }
     finally
     {
         //Log
     }
 }