public long InsertCallbackDetail([FromBody] EnquiryCallbackDetail detail)
        {
            long result = 0;

            try
            {
                result = enquiryRepository.InsertCallbackDetail(detail);
            }
            catch (Exception dbEx)
            {
                return(result);
            }
            return(result);
        }
Beispiel #2
0
        public long InsertCallbackDetail([FromBody] EnquiryCallbackDetail detail)
        {
            long result = 0;

            try
            {
                var date = DateTime.ParseExact(detail.CallbackTime, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                detail.CallBackDate = date;
                result = enquiryRepository.InsertCallbackDetail(detail);
            }
            catch (Exception dbEx)
            {
                return(result);
            }
            return(result);
        }
        public Int64 InsertCallbackDetail(EnquiryCallbackDetail detail)
        {
            try
            {
                using (IDbConnection db = new SqlConnection(ConnectionString))
                {
                    string sql      = "EXEC uspInsertCallbackDetail @EnquiryId,@CustomerFeedback,@CallBackDate,@CreatedBy";
                    var    returnId = db.ExecuteScalar <int>(sql, new
                    {
                        EnquiryId        = detail.EnquiryId,
                        CustomerFeedback = detail.CustomerFeedback,
                        CallBackDate     = detail.CallBackDate,
                        CreatedBy        = detail.CreatedBy
                    });

                    return(returnId);
                }
            }
            catch (Exception ex)
            {
                return(0);
            }
        }