public HttpResponseMessage InsertInstances([FromBody] clsinstances request)
        {
            LoggerFactory.LoggerInstance.LogDebug("Request Started for : " + request.InstanceID + "  Name :" + request.InstanceName);
            HttpResponseMessage response = new HttpResponseMessage();

            try
            {
                instancesService objComService = new instancesService();
                var objResponse = objComService.InsertInstances(request);
                if (objResponse != null && objResponse.ToString() != "")
                {
                    response = Request.CreateResponse(HttpStatusCode.OK, objResponse);
                    LoggerFactory.LoggerInstance.LogDebug("Request End for : " + request.InstanceID + "  Name :" + request.InstanceName);
                }
                else
                {
                    response = Request.CreateErrorResponse(HttpStatusCode.NotFound, "No detail found  for  Name : " + request.InstanceName + ".");
                }
            }
            catch (Exception ex)
            {
                LoggerFactory.LoggerInstance.LogException(ex);
                response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while getting  Name " + request.InstanceName + ".");
            }
            return(response);
        }
        public virtual SP_instances_SelectOneResult GetInstancesDetailById(clsinstances obj)
        {
            SP_instances_SelectOneResult objResult = new SP_instances_SelectOneResult();

            try
            {
                objResult = (SP_instances_SelectOneResult)db.SP_instances_SelectOne(obj.InstanceID);
            }
            catch (Exception ex)
            {
                LoggerFactory.LoggerInstance.LogException(ex);
                throw ex;
            }
            return(objResult);
        }
        public virtual int DeleteInstances(clsinstances obj)
        {
            int result = 0;

            try
            {
                result = (int)db.SP_instances_Delete(obj.InstanceID);
            }
            catch (Exception ex)
            {
                LoggerFactory.LoggerInstance.LogException(ex);
                throw ex;
            }

            return(result);
        }
        public virtual int UpdateInstances(clsinstances obj)
        {
            int result = 0;

            try
            {
                result = (int)db.SP_instances_Update(obj.InstanceID, obj.InstanceName, obj.Telephone, obj.MobileNo, obj.Version, obj.Logo, obj.LastUpdateDateTime, obj.LastBackupDate, obj.LastRestoreDate, obj.LastRestoreUpto, obj.LastResetDate, obj.CreatedDate);
            }
            catch (Exception ex)
            {
                LoggerFactory.LoggerInstance.LogException(ex);
                throw ex;
            }

            return(result);
        }
        public virtual long InsertInstances(clsinstances obj)
        {
            long result   = 0;
            long?resultID = 0;

            try
            {
                result = (long)db.SP_instances_Insert(ref resultID, obj.InstanceName, obj.Telephone, obj.MobileNo, obj.Version, obj.Logo, obj.LastUpdateDateTime, obj.LastBackupDate, obj.LastRestoreDate, obj.LastRestoreUpto, obj.LastResetDate, obj.CreatedDate);
            }
            catch (Exception ex)
            {
                LoggerFactory.LoggerInstance.LogException(ex);
                throw ex;
            }

            return(result);
        }