public int SaveInsurance(PreInsurance preIns) { int InsuranceNo = 0; // DataSet set = new DataSet(); PreInsurance objpreinsu = new PreInsurance(); try { using (SqlConnection sqlCon = new SqlConnection(_connectionString)) { using (SqlCommand sqlCmd = new SqlCommand("sspSaveInsurance", sqlCon)) { sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new SqlParameter("@PatientName", preIns.PatientName)); sqlCmd.Parameters.Add(new SqlParameter("@Gender", preIns.Gender)); sqlCmd.Parameters.Add(new SqlParameter("@Dataofbirth", preIns.Dataofbirth)); sqlCmd.Parameters.Add(new SqlParameter("@InsuranceCard_IDno", preIns.InsuranceCard_IDno)); sqlCmd.Parameters.Add(new SqlParameter("@MobileNumber", preIns.MobileNumber)); sqlCmd.Parameters.Add(new SqlParameter("@PolicyName", preIns.PolicyName)); sqlCmd.Parameters.Add(new SqlParameter("@PolicyNumber", preIns.PolicyNumber)); sqlCmd.Parameters.Add(new SqlParameter("@PrimaryInsName", preIns.PrimaryInsName)); //sqlCmd.Parameters.Add(new SqlParameter("@OtherInsurance", preIns.OtherInsurance)); sqlCmd.Parameters.Add(new SqlParameter("@TenantID", preIns.TenantID)); sqlCon.Open(); SqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { InsuranceNo = (reader[0] == DBNull.Value ? 0 : Convert.ToInt32(reader[0])); } } reader.Close(); reader = null; //if (set.Tables.Count > 1) //{ // customerNumber = set.Tables[1].Rows[0].ItemArray[0] == DBNull.Value ? 0 : Convert.ToInt32(set.Tables[1].Rows[0].ItemArray[0]); // //ordKitBO.OrderNumber = set.Tables[0].Rows[0].ItemArray[0] == DBNull.Value ? string.Empty : Convert.ToString(set.Tables[0].Rows[0].ItemArray[0]); //} sqlCon.Close(); } } } catch (Exception ex) { //strErrorMsg = ex.Message; throw; } return(InsuranceNo); }
public HttpResponseMessage Post([FromBody] PreInsurance preinsurance) { ApiDA apiDA = new ApiDA(); HttpResponseMessage responce = new HttpResponseMessage(); // bool isEntity=apiDA.CheckEntity(kitOrder.AuthenticateToken); int TenantID = apiDA.CheckEntity(preinsurance.PreAuthoriztionToken); preinsurance.TenantID = TenantID; if (TenantID != 0) { apiDA.SaveInsurance(preinsurance); } return(responce); }