//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); } }
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); }