public ITSubHeadMasterResponse InsertUpdateITSubHeadMaster([FromBody] ITSubHeadMaster objITSubHeadMaster) { var objMaster = _Kernel.Get <IMaster>(); var objITSubHeadMasterResponse = objMaster.InsertUpdateITSubHeadMaster(objITSubHeadMaster); return(objITSubHeadMasterResponse); }
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(); } }
public ITSubHeadMasterResponse InsertUpdateITSubHeadMaster(ITSubHeadMaster objITSubHeadMaster) { try { return(this._masterDA.InsertUpdateITSubHeadMaster(objITSubHeadMaster)); } catch (Exception ex) { throw; } finally { //Log } }