Ejemplo n.º 1
0
        //private DataSet InsertSelectedPlanData(string cstr, SelectedPlan sReq)
        //{
        //    //Enter Values in Recharge Table
        //    try
        //    {
        //        SqlParameter[] param = new SqlParameter[3];
        //        param[0] = new SqlParameter("@enquiryid", sReq.EnquiryID);
        //        param[1] = new SqlParameter("@CompanyName", sReq.EnquiryID);
        //        param[2] = new SqlParameter("@PlanName", sReq.EnquiryID);

        //        return (new CommonDB().ExecuteMultipleQuery(cstr, "InsertSelectedTravelPlanDetail", param));
        //    }
        //    catch (Exception ex)
        //    {
        //        return null;
        //    }
        //}

        private DataSet InsertProposalFormData(string cstr, ProposalForm sReq)
        {
            //Enter Values in Recharge Table
            try
            {
                SqlParameter[] param = new SqlParameter[1];
                param[0] = new SqlParameter("@enquiryid", sReq.enquiryID);

                return(new CommonDB().ExecuteMultipleQuery(cstr, "InsertTravelProposalFormDetail", param));
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
Ejemplo n.º 2
0
        DataReturnModel <dynamic> ITravelServiceFunctions.HitProposalFormApi(ProposalForm request)
        {
            DataReturnModel <dynamic> dr = new DataReturnModel <dynamic>();

            try
            {
                string  cstr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
                DataSet ds   = InsertProposalFormData(cstr, request);
                dr.info.res = JsonConvert.SerializeObject(ds);
                // DataSet dds = JsonConvert.DeserializeObject<DataSet>(dr.info.res);
                // CALL API FROM HERE AND PASS ENQUIRY ID AND ALL PARAMETER RECEVED FROM UI
            }
            catch (Exception ex)
            {
                ErrorLogging(ex);
            }
            return(dr);
        }